SSR_DEEWR_E702(SQL Table) |
Index Back |
|---|---|
DEEWR Element 702 Mapping TblThis record is used to hold the mapping of Element 702 code with state. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 3 | SSR_DEEWR_E702 |
Character(2) | VARCHAR2(2) NOT NULL |
Element 702 Code
01=ACT Year 12 Certificate 02=New South Wales HSC 03=QLD Certificate of Education 04=SA/NT Certificate of Education 05=TAS Certificate of Education 06=VIC Certificate of Education 07=WA Certificate of Education 08=International Baccalaureate |