AAWS - Admissions Application Web Services - Listing of great KM docs from Oracle

Here is a listing of KM docs regarding AAWS.

AAWS - CS 9.0 Bundle #23 Functional Documentation and Additional Features October 2011 (Doc ID 1371376.1)

Campus Solutions 9.0 Generic Service Tester Tool (Doc ID 1478817.1)

1323959.1 - AAWS - Data Mapping and Entity Catalog
1373575.1 - AAWS - Sample XML Files for SAD_GETAPPL_REQ and SAD_CREATEAPPL_REQ

Find Records/Tables within a Default Message - PERSON_BASIC_SYNC - Sample SQL

Provide a listing of records for a particular message.  This example is PERSON_BASIC_SYNC.



SELECT DISTINCT C.recname,
                D.rectype "Tables Only",
                C.msgname,
                A.defaultver
FROM   psmsgdefn A,
       psmsgver B,
       psmsgrec C,
       psrecdefn D
WHERE  A.msgname = B.msgname
       AND A.defaultver = B.apmsgver
       AND C.msgname = B.msgname
       AND C.apmsgver = B.apmsgver
       AND D.recname = C.recname
       AND D.rectype = 0
       AND A.msgname = 'PERSON_BASIC_SYNC'
ORDER  BY C.recname ASC 

RECNAME	Tables Only	MSGNAME	DEFAULTVER
ADDRESSES	0	PERSON_BASIC_SYNC	INTERNAL
EMAIL_ADDRESSES	0	PERSON_BASIC_SYNC	INTERNAL
NAMES	0	PERSON_BASIC_SYNC	INTERNAL
NATIONALITY_GER	0	PERSON_BASIC_SYNC	INTERNAL
PERSON	0	PERSON_BASIC_SYNC	INTERNAL
PERSONAL_PHONE	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_BRA	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_FRA	0	PERSON_BASIC_SYNC	INTERNAL
PERSON_SA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_BRA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CAN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_CHE	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_DEU	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_EFFDT	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ESP	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FPS	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_FRA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_IND	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_ITA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_JPN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_MEX	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USA	0	PERSON_BASIC_SYNC	INTERNAL
PERS_DATA_USF	0	PERSON_BASIC_SYNC	INTERNAL
PERS_HUKOU_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_NID	0	PERSON_BASIC_SYNC	INTERNAL
PERS_SMOKER	0	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLIF_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PERS_WRKLV_CHN	0	PERSON_BASIC_SYNC	INTERNAL
PLACE_ORIG_CHE	0	PERSON_BASIC_SYNC	INTERNAL