SAD_SL_TRANSMIT

(SQL Table)
 Index Back

Studielink Transmit Table

Contains Transmit Flags and Dates for each Outgoing XML Message Type.

  • Parent record: SAD_SL_TRANS_P

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

    Prompt Table: SCC_BRINCD_NLD

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    5 SAD_SL_ENRLSQ_NLD Character(20) VARCHAR2(20) NOT NULL Studielink Enroll Seq Nbr
    6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_SCTY

    8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    9 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year

    Prompt Table: TERM_YR1_VW

    10 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
    11 SSR_FORM_STUDY_NLD Character(4) VARCHAR2(4) NOT NULL Form of Study Higher Education
    A=Auditor
    D=Participant
    E=Extraneus
    S=Student
    T=Coop/Dual
    12 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    13 SAD_SL_19_STAT Character(1) VARCHAR2(1) NOT NULL Payment of Fees
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    14 SAD_SL_19_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Message 19 Academic Year

    Prompt Table: TERM_YR1_VW

    15 SAD_SL_19_DTTM DateTime(26) TIMESTAMP 19 Transmit Date
    16 SAD_SL_20_STAT Character(1) VARCHAR2(1) NOT NULL Cost of Fees
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    17 SAD_SL_20_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Message 20 Academic Year

    Prompt Table: TERM_YR1_VW

    18 SAD_SL_20_DTTM DateTime(26) TIMESTAMP 20 Transmit Date
    19 SAD_SL_22_STAT Character(1) VARCHAR2(1) NOT NULL Message to Applicant
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    20 SAD_SL_22_DTTM DateTime(26) TIMESTAMP Transmit Date
    21 SAD_SL_31A_STAT Character(1) VARCHAR2(1) NOT NULL Receipt of Application
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    22 SAD_SL_31A_DTTM DateTime(26) TIMESTAMP Transmit Date
    23 SAD_SL_31B_STAT Character(1) VARCHAR2(1) NOT NULL Confirm Enrollment
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    24 SAD_SL_31B_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Confirm Enrollment Year

    Prompt Table: TERM_YR1_VW

    25 SAD_SL_31B_DTTM DateTime(26) TIMESTAMP Transmit Date
    26 SAD_SL_31C_STAT Character(1) VARCHAR2(1) NOT NULL Confirm Re-enrollment
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    27 SAD_SL_31C_DTTM DateTime(26) TIMESTAMP Transmit Date
    28 SAD_SL_31C_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Confirm Re-enrollment Year

    Prompt Table: TERM_YR1_VW

    29 SAD_SL_31Q_STAT Character(1) VARCHAR2(1) NOT NULL Confirmation Receipt (31Q)
    N=Do Not Send
    Y=Send
    30 SAD_SL_31Q_DTTM DateTime(26) TIMESTAMP Transmit Date
    31 SAD_SL_31Q_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Confirmation Enrollmnt Yr

    Prompt Table: TERM_YR1_VW

    32 SAD_SL_31D_STAT Character(1) VARCHAR2(1) NOT NULL Discontinuation Not Allowed
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    33 SAD_SL_31D_DTTM DateTime(26) TIMESTAMP Transmit Date
    34 SAD_SL_31E_STAT Character(1) VARCHAR2(1) NOT NULL Discontinuation Allowed
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    35 SAD_SL_31E_ACAD_YR Character(4) VARCHAR2(4) NOT NULL Disconinue Allowed YR

    Prompt Table: TERM_YR1_VW

    36 SAD_SL_31E_DTTM DateTime(26) TIMESTAMP Transmit Date
    37 SAD_SL_31F_STAT Character(1) VARCHAR2(1) NOT NULL Cancellation Confirmed
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    38 SAD_SL_31F_DTTM DateTime(26) TIMESTAMP Transmit Date
    39 SAD_SL_31G_STAT Character(1) VARCHAR2(1) NOT NULL Withdrawal Confirmed
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    40 SAD_SL_31G_DTTM DateTime(26) TIMESTAMP Transmit Date
    41 SAD_SL_31H_STAT Character(1) VARCHAR2(1) NOT NULL Non First Year
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    42 SAD_SL_31H_DTTM DateTime(26) TIMESTAMP 31H Transmit Date
    43 SAD_SL_31I_STAT Character(1) VARCHAR2(1) NOT NULL Professional Duties
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    44 SAD_SL_31I_DTTM DateTime(26) TIMESTAMP 31I Transmit Date
    45 SAD_SL_31J_STAT Character(1) VARCHAR2(1) NOT NULL Language Test
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    46 SAD_SL_31J_DTTM DateTime(26) TIMESTAMP 31J Transmit Date
    47 SAD_SL_31K_STAT Character(1) VARCHAR2(1) NOT NULL Prior Ed Deficiency
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    48 SAD_SL_31K_DTTM DateTime(26) TIMESTAMP 31K Transmit Date
    49 SAD_SL_31L_STAT Character(1) VARCHAR2(1) NOT NULL Admission Delete
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    50 SAD_SL_31L_DTTM DateTime(26) TIMESTAMP Transmit Date
    51 SAD_SL_31M_STAT Character(1) VARCHAR2(1) NOT NULL Re-enroll Delete
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    52 SAD_SL_31M_DTTM DateTime(26) TIMESTAMP Transmit Date
    53 SAD_SL_31N_STAT Character(1) VARCHAR2(1) NOT NULL Lot Drawing Result
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    54 SAD_SL_31N_DTTM DateTime(26) TIMESTAMP 31N Transmit Date
    55 SAD_SL_31O_STAT Character(1) VARCHAR2(1) NOT NULL Study Progress
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    56 SAD_SL_31O_DTTM DateTime(26) TIMESTAMP 31O Transmit Date
    57 SAD_SL_31P_STAT Character(1) VARCHAR2(1) NOT NULL Profession Requirements
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    58 SAD_SL_31P_DTTM DateTime(26) TIMESTAMP 31P Transmit Date
    59 SAD_SL_34_STAT Character(1) VARCHAR2(1) NOT NULL New Application
    N=Do Not Send
    Y=Send

    Y/N Table Edit

    60 SAD_SL_34_DTTM DateTime(26) TIMESTAMP Transmit Date
    61 SAD_SL_48_STAT Character(1) VARCHAR2(1) NOT NULL Correction end enroll (48)

    Y/N Table Edit

    62 SAD_SL_48_DTTM DateTime(26) TIMESTAMP Transmit date