EFFDTDefault Value: %Date
COUNTRYPrompt Table: COUNTRY_TBL
Prompt Table: SSR_CNTRY2_AUS
SSR_COUNTRY_AUS(SQL Table) |
Index Back |
|---|---|
Country Mapping Table DESTThis record is used to hold the mapping of DEST country code values to PeopleSoft Country Code values. This is to support the Department of Education, Training and Youth Affairs reporting requirements in Australia. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %Date |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 3 | SSR_COUNTRY_DEST | Character(4) | VARCHAR2(4) NOT NULL |
DEST Country Code
Prompt Table: SSR_CNTRY2_AUS |