SAD_SL_34

(SQL Table)
 Index Back

Studielink Msg 34 Stage Table

  • Parent record: SAD_SL_TRNS_INF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
    I=Inbound
    O=Outbound
    2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
    3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    4 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
    5 SAD_SL_STDLNK_NBR Character(9) VARCHAR2(9) NOT NULL Studielink Number
    6 SAD_SL_NAME_TEXT Character(220) VARCHAR2(220) NOT NULL Merged name
    7 SAD_SL_LAST_NAME Character(200) VARCHAR2(200) NOT NULL Lastname
    8 SAD_SL_NAME_PREFIX Character(200) VARCHAR2(200) NOT NULL Name Prefix
    9 SAD_SL_PREF_NAME Character(200) VARCHAR2(200) NOT NULL Preferred Firstname
    10 SAD_SL_FIRST_NAME Character(200) VARCHAR2(200) NOT NULL First Name
    11 SAD_SL_FULL_NAME Character(220) VARCHAR2(220) NOT NULL Full Name
    12 SAD_SL_INITIALS Character(10) VARCHAR2(10) NOT NULL Initials
    13 SAD_SL_CNTRY_CODE Character(5) VARCHAR2(5) NOT NULL Countrycode
    14 SAD_SL_PHONE_NBR Character(13) VARCHAR2(13) NOT NULL Phonenumber
    15 SAD_SL_MOBILE_NBR Character(13) VARCHAR2(13) NOT NULL Mobile number
    16 SAD_SL_EMAIL_ADDR Character(100) VARCHAR2(100) NOT NULL E-mail Address
    17 SAD_SL_GENDER Character(2) VARCHAR2(2) NOT NULL Gender
    18 SAD_SL_DEMO_DT_TYP Character(9) VARCHAR2(9) NOT NULL Demographic Date type
    19 SAD_SL_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate
    20 SAD_SL_BIRTHPLACE Character(4) VARCHAR2(4) NOT NULL Place of Birth
    21 SAD_SL_MOBILE_CTRY Character(5) VARCHAR2(5) NOT NULL Mobile country code
    22 SAD_SL_BIRTH_CITY Character(40) VARCHAR2(40) NOT NULL Birth City
    23 SAD_SL_BIRTHDT_IND Character(1) VARCHAR2(1) NOT NULL Birthdate indicator
    24 SAD_SL_NATIONALITY Character(4) VARCHAR2(4) NOT NULL Nationality
    25 SAD_SL_PREF_LANG Character(2) VARCHAR2(2) NOT NULL Language Preferred
    DE=German
    EN=English
    NL=Dutch
    26 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
    27 SAD_SL_CIOP_NBR Character(12) VARCHAR2(12) NOT NULL Correspondence number
    28 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
    29 SAD_SL_VERIF_STAT Character(1) VARCHAR2(1) NOT NULL Verified status
    A=Dont allow local Verification
    D=Locally (institution) verified
    E=Not Verified by Institution
    O=Unknown
    30 SAD_SL_REASON_CD Character(4) VARCHAR2(4) NOT NULL Signalcode
    31 SAD_SL_IDEN_DT_TYP Character(9) VARCHAR2(9) NOT NULL Ext Identification date type
    32 SAD_SL_VERIF_DT Character(10) VARCHAR2(10) NOT NULL Date of Verification
    33 SAD_SL_IDENT_PROOF Character(30) VARCHAR2(30) NOT NULL Identification document
    34 SAD_SL_IDENT_NBR Character(15) VARCHAR2(15) NOT NULL Identification Number
    35 SAD_SL_VERIFIER_CD Character(4) VARCHAR2(4) NOT NULL Verified by Brincode
    36 SAD_SL_INST_NAME Character(70) VARCHAR2(70) NOT NULL Verified by Institution
    37 SAD_SL_VERIFIER_NM Character(35) VARCHAR2(35) NOT NULL Verified by Employee
    38 SAD_SL_REMARK Long Character(1000) VARCHAR2(1000) Remark
    39 SAD_SL_ACTIVITY_DT Character(10) VARCHAR2(10) NOT NULL Activity Date
    40 SAD_SL_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    B=Continuing Application
    G=Cancelled/Withdrawn
    I=Registered/Enrolled
    N=No Re-Enrollment
    R=Rejected/Denied
    S=Study Suspended
    U=Departed
    V=Enrollment Requested
    W=Data Change
    X=Not a Studielink Participant
    41 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    42 SAD_SL_EXT_PROG_CD Character(12) VARCHAR2(12) NOT NULL Alternative programcode
    43 SAD_SL_BRIN_CODE Character(4) VARCHAR2(4) NOT NULL Brincode institution
    44 SAD_SL_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic load
    1=Full-time
    2=Part-time
    3=Dual
    45 SAD_SL_ACTEDU_CITY Character(24) VARCHAR2(24) NOT NULL City
    46 SAD_SL_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    M=Master
    P=Propaedeutic Phase
    V=Continuation Phase
    47 SAD_SL_ENRL_MANNER Character(1) VARCHAR2(1) NOT NULL Enrolment Manner
    A=Auditor
    D=Participant
    E=Extraneus
    S=Student
    T=Coop/Dual
    48 SAD_SL_ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    49 SAD_SL_START_MONTH Character(2) VARCHAR2(2) NOT NULL Start month
    50 SAD_SL_DEFICIENT Character(2) VARCHAR2(2) NOT NULL Deficiency Status
    51 SAD_SL_FIRST_YR Character(1) VARCHAR2(1) NOT NULL First Year
    F=False
    T=True
    52 SAD_SL_STATJOB_REQ Character(1) VARCHAR2(1) NOT NULL Status Profnl Requirements
    A=Rejected
    G=Selected/Passed
    N=Not Applicable
    O=Open, not yet detrmined
    53 SAD_SL_STATACT_REQ Character(1) VARCHAR2(1) NOT NULL Status Professional Duties
    A=Rejected
    G=Selected/passed
    N=Not applicable
    O=Open, not yet determined
    54 SAD_SL_STATLNG_REQ Character(1) VARCHAR2(1) NOT NULL Language Test
    A=Rejected
    G=Selected/Passed
    H=Passed
    N=Not Applicable
    O=Open, not yet determined
    55 SAD_SL_PAYED_BY Character(1) VARCHAR2(1) NOT NULL Payed By
    56 SAD_SL_PAY_MODE Character(1) VARCHAR2(1) NOT NULL Payment Mode
    0=Payment Transfer
    1=Auth Printed by Institution
    2=Auth Printed by Student
    3=Foreign Account Number
    4=Other
    57 SAD_SL_PAY_NAME Character(220) VARCHAR2(220) NOT NULL Payment Method name
    58 SAD_SL_ACCT_NBR Character(10) VARCHAR2(10) NOT NULL Payment method bank/giroaccnt
    59 SAD_SL_TERMS_IND Character(1) VARCHAR2(1) NOT NULL Payment method periods
    60 SAD_SL_DRAW_OPTION Character(1) VARCHAR2(1) NOT NULL Draw Option
    61 SAD_SL_SUBINST Character(2) VARCHAR2(2) NOT NULL Sub Institute
    62 SAD_SL_START_OCCSN Character(12) VARCHAR2(12) NOT NULL Start Occasion
    63 SAD_SL_FORGN_ACCNO Character(34) VARCHAR2(34) NOT NULL Foreign Accountnbr
    64 SAD_SL_BANK_NAME Character(50) VARCHAR2(50) NOT NULL Bankname
    65 SAD_SL_BANK_CNTRY Character(4) VARCHAR2(4) NOT NULL Bank Country
    66 SAD_SL_TUITION_IND Character(1) VARCHAR2(1) NOT NULL Payed
    F=False
    T=True
    67 SAD_SL_TUITION_AMT Character(13) VARCHAR2(13) NOT NULL Tution Amount
    68 SAD_SL_NATIONALTY2 Character(4) VARCHAR2(4) NOT NULL Nationality2
    69 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
    70 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    71 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    72 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
    73 SAD_SL_EST_CNTRY Character(4) VARCHAR2(4) NOT NULL Country of destination
    74 SAD_SL_DEPDTC_NLD Character(10) VARCHAR2(10) NOT NULL Date of Departure from NLD
    75 SSR_SL_PERSDAT_NLD Character(1) VARCHAR2(1) NOT NULL Deliverpersondataagreed
    F=False
    T=True
    76 SAD_SL_RESD_ENDDTC Character(10) VARCHAR2(10) NOT NULL Residency Doc End Date
    77 SAD_SL_RESD_STRDTC Character(10) VARCHAR2(10) NOT NULL Residency Doc Start Date
    78 SAD_SL_RES_DOC Character(6) VARCHAR2(6) NOT NULL Residency Document
    79 SAD_SL_CRDTRID_NLD Character(35) VARCHAR2(35) NOT NULL Creditor Id
    80 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
    81 BIC_ID Character(11) VARCHAR2(11) NOT NULL The Bank Identifier Code, also known as a BIC or BIC code, is a universal method of identifying financial institutions in order to facilitate the automated processing of payments.
    82 INTL_BANK_ACCT_NBR Character(34) VARCHAR2(34) NOT NULL IBAN International Bank Account Number
    83 SAD_SL_PAYID_NLD Character(35) VARCHAR2(35) NOT NULL Payment ID
    84 SSR_SL_PAYMODE_NLD Character(1) VARCHAR2(1) NOT NULL Studielink Form of Payment
    0=Payment Transfer
    1=Auth Printed by Institution
    2=Auth Printed by Student
    3=Foreign Account Number
    4=Other
    5=E-Payment
    6=Electronic Direct Debit
    7=Via Institution
    8=Non SEPA Country
    85 SAD_SL_ENRLSQ_NLD Character(20) VARCHAR2(20) NOT NULL Studielink Enroll Seq Nbr
    86 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr