OUAC_G2_H2_EC

(SQL Table)
Index Back

OUAC Last Secondary School

# 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_FROM_YYYYMM Character(6) VARCHAR2(6) NOT NULL OUAC From Date - YYYYMM
10 OUAC_TO_YYYYMM Character(6) VARCHAR2(6) NOT NULL OUAC To Date - YYYYMM
11 OUAC_INST_CODE Character(12) VARCHAR2(12) NOT NULL OUAC Institution Code
12 OUAC_DIPLOMA_CODE Character(4) VARCHAR2(4) NOT NULL Diploma/Degree Received Code
13 OUAC_POS_92_95 Character(4) VARCHAR2(4) NOT NULL OUAC Transaction Pos. 92-95
14 FROM_DATE Date(10) DATE From Date
15 TO_DATE Date(10) DATE Latest Date to be sent to PYR
16 DATE_LOADED Date(10) DATE Date Loaded