ADM_T130_SST_EC

(SQL Table)
 Index Back

Adm Transcript SST EC

Admissions Transcript Electronic Commerce EDI Staging Table. Student Academic Status record for TS130 Transcript transactions. Use ADM_T130_SST_EC to store information eligibility to return to the reporting institution, enrollment status, residency for fee purposes, and date and type or status of high school graduation.

  • Parent record: ADM_T130_ORG_EC

    • # 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

    Default Value: I

    4 TRANS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 EDI_HS_GRAD_TYPE Character(3) VARCHAR2(3) NOT NULL High School Graduation Type
    B17=Did not cmplt secondary schl
    B18=Standard high school diploma
    B19=Advanced or honors diploma
    B20=Vocational diploma
    B21=Special education diploma
    B22=Certificate of completion
    B23=Special certificate of compl
    B24=General Education Development
    B25=Other HS equivalency diploma
    B26=International diploma
    7 HS_GRAD_DT Date(10) DATE Highschool graduation date
    8 EDI_ELIGIBL_RTRN Character(3) VARCHAR2(3) NOT NULL Eligible to Return
    B27=Eligible to Return
    B28=Suspension or dismissal
    B29=Expelled
    9 RETURN_DT Date(10) DATE Return Date
    10 EDI_ENROLL_STAT Character(3) VARCHAR2(3) NOT NULL Enrollment Status Code
    B30=Currently enrolled crs not in
    B31=Currently Enrolled
    B33=Curr Enroll Not Available
    B34=Currently Enrld crses inclded
    11 EDI_YES_NO Character(1) VARCHAR2(1) NOT NULL Yes/No Condition
    N=No
    U=Unknown
    Y=Yes
    12 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID