SAD_SL_04

(SQL Table)
 Index Back

Studielink Msg 04 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_FIRST_NAME Character(200) VARCHAR2(200) NOT NULL First Name
    8 SAD_SL_PREF_NAME Character(200) VARCHAR2(200) NOT NULL Preferred Firstname
    9 SAD_SL_INITIALS Character(10) VARCHAR2(10) NOT NULL Initials
    10 SAD_SL_LAST_NAME Character(200) VARCHAR2(200) NOT NULL Lastname
    11 SAD_SL_NAME_PREFIX Character(200) VARCHAR2(200) NOT NULL Name Prefix
    12 SAD_SL_FULL_NAME Character(220) VARCHAR2(220) NOT NULL Full Name
    13 SAD_SL_ADDR_TYPE Character(9) VARCHAR2(9) NOT NULL Address Type
    14 SAD_SL_STREET Character(80) VARCHAR2(80) NOT NULL Street Name
    15 SAD_SL_APT_TYPE Character(35) VARCHAR2(35) NOT NULL Apartment Type
    16 SAD_SL_APT_PREFIX Character(2) VARCHAR2(2) NOT NULL Apartment Number Prefix
    17 SAD_SL_APT_NBR Character(5) VARCHAR2(5) NOT NULL Apartment Number
    18 SAD_SL_APT_SUFFIX Character(5) VARCHAR2(5) NOT NULL Apartment Num Suffix
    19 SAD_SL_POST_CODE Character(6) VARCHAR2(6) NOT NULL Postal Code
    20 SAD_SL_CITY Character(30) VARCHAR2(30) NOT NULL City
    21 SAD_SL_CNTRY Character(4) VARCHAR2(4) NOT NULL Country Code
    22 SAD_SL_POST_CD_CHK Character(1) VARCHAR2(1) NOT NULL Postcodecheck
    F=False
    T=True

    Default Value: T

    23 SAD_SL_STRTDTC_NLD Character(10) VARCHAR2(10) NOT NULL Start Date
    24 SAD_SL_GENDER Character(2) VARCHAR2(2) NOT NULL Gender
    25 SAD_SL_DEMO_DT_TYP Character(9) VARCHAR2(9) NOT NULL Demographic Date type
    26 SAD_SL_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate
    27 SAD_SL_BIRTHPLACE Character(4) VARCHAR2(4) NOT NULL Place of Birth
    28 SAD_SL_FORGN_TYPE Character(9) VARCHAR2(9) NOT NULL Foreign Address Type
    29 SAD_SL_FA_STDT_NLD Character(10) VARCHAR2(10) NOT NULL Start Date
    30 SAD_SL_FORGN_ADDR1 Character(35) VARCHAR2(35) NOT NULL Street Name
    31 SAD_SL_FA_APT_SFFX Character(10) VARCHAR2(10) NOT NULL Apartment Num Suffix
    32 SAD_SL_FA_POST_CD Character(11) VARCHAR2(11) NOT NULL Postal Code
    33 SAD_SL_FORGN_ADDR2 Character(35) VARCHAR2(35) NOT NULL City
    34 SAD_SL_FORGN_ADDR3 Character(35) VARCHAR2(35) NOT NULL Additional Address
    35 SAD_SL_FORGN_CNTRY Character(4) VARCHAR2(4) NOT NULL Foreign Address Country
    36 SAD_SL_BIRTH_CITY Character(40) VARCHAR2(40) NOT NULL Birth City
    37 SAD_SL_BIRTHDT_IND Character(1) VARCHAR2(1) NOT NULL Birthdate indicator
    38 SAD_SL_NATIONALITY Character(4) VARCHAR2(4) NOT NULL Nationality
    39 SAD_SL_RESIDENT_CD Character(2) VARCHAR2(2) NOT NULL Status of Residence
    40 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
    41 SAD_SL_CIOP_NBR Character(12) VARCHAR2(12) NOT NULL Correspondence number
    42 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
    43 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
    44 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
    45 SAD_SL_REASON_CD Character(4) VARCHAR2(4) NOT NULL Signalcode
    46 SAD_SL_IDEN_DT_TYP Character(9) VARCHAR2(9) NOT NULL Ext Identification date type
    47 SAD_SL_VERIF_DT Character(10) VARCHAR2(10) NOT NULL Date of Verification
    48 SAD_SL_IDENT_PROOF Character(30) VARCHAR2(30) NOT NULL Identification document
    49 SAD_SL_IDENT_NBR Character(15) VARCHAR2(15) NOT NULL Identification Number
    50 SAD_SL_VERIFIER_CD Character(4) VARCHAR2(4) NOT NULL Verified by Brincode
    51 SAD_SL_INST_NAME Character(70) VARCHAR2(70) NOT NULL Verified by Institution
    52 SAD_SL_VERIFIER_NM Character(35) VARCHAR2(35) NOT NULL Verified by Employee
    53 SAD_SL_REMARK Long Character(1000) VARCHAR2(1000) Remark
    54 SAD_SL_CNTRY_CODE Character(5) VARCHAR2(5) NOT NULL Countrycode
    55 SAD_SL_PHONE_NBR Character(13) VARCHAR2(13) NOT NULL Phonenumber
    56 SAD_SL_MOBILE_NBR Character(13) VARCHAR2(13) NOT NULL Mobile number
    57 SAD_SL_EMAIL_ADDR Character(100) VARCHAR2(100) NOT NULL E-mail Address
    58 SAD_SL_MOBILE_CTRY Character(5) VARCHAR2(5) NOT NULL Mobile country code
    59 SAD_SL_NATIONALTY2 Character(4) VARCHAR2(4) NOT NULL Nationality2
    60 SAD_SL_PREF_LANG Character(2) VARCHAR2(2) NOT NULL Language Preferred
    DE=German
    EN=English
    NL=Dutch
    61 SAD_SL_REGTRMNT_DT Character(10) VARCHAR2(10) NOT NULL Registration Termination Date
    62 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    63 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
    64 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    65 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
    66 SSR_SL_PERSDAT_NLD Character(1) VARCHAR2(1) NOT NULL Deliverpersondataagreed
    F=False
    T=True
    67 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    68 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    69 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    70 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    71 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    72 CITY Character(30) VARCHAR2(30) NOT NULL City
    73 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    74 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    75 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    76 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    77 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    78 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    79 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    80 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    81 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    82 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    83 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    84 SAD_SL_VISA_PERMIT Character(3) VARCHAR2(3) NOT NULL Visa/Permit
    85 SAD_SL_EST_CNTRY Character(4) VARCHAR2(4) NOT NULL Country of destination
    86 SAD_SL_DEPDTC_NLD Character(10) VARCHAR2(10) NOT NULL Date of Departure from NLD
    87 SAD_SL_NAT_STRDTC Character(10) VARCHAR2(10) NOT NULL Nationality Start Date
    88 SAD_SL_NAT_ENDDT Character(10) VARCHAR2(10) NOT NULL Nationality End Date
    89 SAD_SL_NAT2_STRDTC Character(10) VARCHAR2(10) NOT NULL Nationality 2 Start Date
    90 SAD_SL_NAT2_ENDDT Character(10) VARCHAR2(10) NOT NULL Nationality 2 End Date
    91 SAD_SL_RES_STRDTC Character(10) VARCHAR2(10) NOT NULL Residency Start Date
    92 SAD_SL_RES_ENDDT Character(10) VARCHAR2(10) NOT NULL Residency End Date
    93 SAD_SL_RES_DOC Character(6) VARCHAR2(6) NOT NULL Residency Document
    94 SAD_SL_RESD_STRDTC Character(10) VARCHAR2(10) NOT NULL Residency Doc Start Date
    95 SAD_SL_RESD_ENDDTC Character(10) VARCHAR2(10) NOT NULL Residency Doc End Date
    96 SAD_SL_DIGID_NLD Character(1) VARCHAR2(1) NOT NULL DIGID Authentication Active