OUAC_A4_U4_EC(SQL Table) |
Index Back |
|---|---|
OUAC Citizenship 2/Personal 3SACE98-A NEW - OUAC A4/U4 Transactions SACE98-D MOD - Added Translate Prompt for Mature Student |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 2 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | ECTRANSINOUTSW |
Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 4 | OUAC_TRAN_ID |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Transaction Identifier |
| 5 | OUAC_REF_NBR |
Character(11) | VARCHAR2(11) NOT NULL | OUAC Reference Number |
| 6 | OUAC_CNV_APPL_NBR |
Character(1) | VARCHAR2(1) NOT NULL | OUAC Converted Application Nbr |
| 7 | OUAC_DIST_NBR |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Distribution Number |
| 8 | OUAC_APPL_NBR |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Application Number |
| 9 | OUAC_CUR_CTZN_CNTR | Character(3) | VARCHAR2(3) NOT NULL | Current Citizenship Country |
| 10 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 11 | COUNTRY_RESIDENCY | Character(3) | VARCHAR2(3) NOT NULL | Country of Residency |
| 12 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL | Province |
| 13 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 14 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table: CITIZEN_STS_TBL |
| 15 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 16 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 17 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 18 | OUAC_1ST_LANGUAGE | Character(2) | VARCHAR2(2) NOT NULL |
OUAC First Language Spoken
E=English F=French |
| 19 | PREFERRED_LANGUAGE | Character(3) | VARCHAR2(3) NOT NULL |
Preferred Language
E=English F=French |
| 20 | OUAC_MATURE_STDNT | Character(1) | VARCHAR2(1) NOT NULL |
OUAC Mature Student
1=Yes 2=No 9=Not Reported |
| 21 | OUAC_SIGNATURE_VER | Character(1) | VARCHAR2(1) NOT NULL | OUAC Signature Verified |
| 22 | OUAC_MIDENT_CODE | Character(8) | VARCHAR2(8) NOT NULL | Prov. Ministry School Number |
| 23 | SCHOOL_BOARD_NBR | Character(5) | VARCHAR2(5) NOT NULL | School Board Number |
| 24 | OUAC_POS_92_95 | Character(4) | VARCHAR2(4) NOT NULL | OUAC Transaction Pos. 92-95 |
| 25 | ONTARIO_EDUC_NBR | Character(9) | VARCHAR2(9) NOT NULL | Ontario Education Number |
| 26 | DATE_LOADED | Date(10) | DATE | Date Loaded |