OUAC_PI_EC

(SQL Table)
Index Back

OUAC Previous School I

# 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_INST_CODE Character(12) VARCHAR2(12) NOT NULL OUAC Institution Code
10 OUAC_FROM_YYYYMM Character(6) VARCHAR2(6) NOT NULL OUAC From Date - YYYYMM
11 OUAC_TO_YYYYMM Character(6) VARCHAR2(6) NOT NULL OUAC To Date - YYYYMM
12 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL External Academic Level
0=Unknown
01=Pre-Eighth Grade
1=Eighth Grade
2=Ninth Grade
3=Tenth Grade
4=Eleventh Grade
5=Twelfth Grade
6=Postsecondary First Year
7=Postsecondary Sophomore
8=Postsecondary Junior
9=Postsecondary Senior
90=Post-Secondary
91=Postsecondary Professional
92=Postsecondary Master
93=Postsecondary Doctoral
94=Postdoctoral
A1=Basic User/Breakthrough (NLD)
A2=Basic User/Waystage (NLD)
B1=Independ. User/Threshold (NLD)
B2=Independ. User/Vantage (NLD)
C1=Prof. User/Effective (NLD)
C2=Proficient User/Master (NLD)
13 OUAC_PROGRAM Character(5) VARCHAR2(5) NOT NULL Program of Study
14 OUAC_DIPLOMA_CODE Character(4) VARCHAR2(4) NOT NULL Diploma/Degree Received Code
15 OUAC_STUDENT_ID Character(24) VARCHAR2(24) NOT NULL Prev. Institution Student Id
16 ACTION_CODE Character(1) VARCHAR2(1) NOT NULL Action Code
A=Accepted
C=Corrected
D=Duplicate
E=Rejected
N=Not Processed, in Rejected Doc
17 OUAC_DEGREE_DATE Character(6) VARCHAR2(6) NOT NULL OUAC Degree Date - YYYYMM
18 TRANSCRIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Transcript Action
D=Desired
R=Received
19 OUAC_POS_92_95 Character(4) VARCHAR2(4) NOT NULL OUAC Transaction Pos. 92-95
20 FROM_DATE Date(10) DATE From Date
21 TO_DATE Date(10) DATE Latest Date to be sent to PYR
22 DEGREE_DT Date(10) DATE Admissions degree date.
23 DATE_LOADED Date(10) DATE Date Loaded