SAD_STD_APP_NLD

(SQL Table)
Index Back

Higher Ed Stdnt Admissions NLD

Applications record for Higher Education Netherlands

  • Parent record: ADM_APP_CAR_SEQ
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_I

    2 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

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DATA

    5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

    Prompt Table: ADM_APP_CAR_SEQ

    6 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    8 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
    9 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
    A=Associate Degree
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    K=Candidate
    L=University teacher education
    M=Master
    P=Propaedeutic Phase
    Q=Post-Initial
    T=Interim Doctoral Exam
    V=Continuation Phase
    W=Continuing study
    10 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SCC_BRIN_CD_VW

    12 SSR_SL_PROG_CD_NLD Character(5) VARCHAR2(5) NOT NULL Studielink Program Code

    Prompt Table: CIP_CODE_TBL

    13 SSR_SL_ACAD_YR_NLD Character(4) VARCHAR2(4) NOT NULL Academic Year

    Prompt Table: TERM_YR1_VW

    14 SSR_SL_FIRSTYR_NLD Character(1) VARCHAR2(1) NOT NULL Approval Higher Year
    F=False
    T=True
    15 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
    16 SSR_SL_PAIDBY_NLD Character(1) VARCHAR2(1) NOT NULL Paid by
    A=Other
    E=Another Institution
    O=Parents
    X=Already Paid
    Z=Student
    17 SSR_SL_BL_TRMS_NLD Character(1) VARCHAR2(1) NOT NULL Request Payment Terms
    F=False
    T=True
    18 SSR_SL_STATUS_NLD Character(1) VARCHAR2(1) NOT NULL Studielink 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
    X=Not a Studielink Participant
    19 SSR_SL_DEFSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Deficiency Status
    D=Deficient via Institution
    J=Deficient via IBG counter
    N=Not yet determined
    S=Sufficient
    T=Not Deficient via IBG Counter
    V=Provisional IBG
    W=Provisional Institution
    20 SSR_SL_JOBSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Prof Requirements Status
    A=Rejected
    G=Selected/passed
    N=Not Applicable
    O=Open, not yet determined
    21 SSR_SL_ACTSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Professional Duties Status
    A=Rejected
    G=Selected/passed
    N=Not applicable
    O=Open, not yet determined
    22 SSR_SL_DRAWOPT_NLD Character(1) VARCHAR2(1) NOT NULL Lot Drawing Type
    C=Central
    I=Local
    N=None
    S=Selection & Placement
    23 SSR_SL_STATLNG_NLD Character(1) VARCHAR2(1) NOT NULL Language Test Status
    A=Rejected
    G=Selected/passed
    H=Passed
    N=Not applicable
    O=Open, not yet determined
    24 SSR_SL_IBGSTAT_NLD Character(1) VARCHAR2(1) NOT NULL IBG Status
    A=Rejected by RASP
    G=Sent
    N=Not sent
    V=Processed in RASP
    25 SSR_SL_IBGSRSN_NLD Character(1) VARCHAR2(1) NOT NULL IBG Status Reason
    B=Identity not timely verifieD
    C=Transcript too late
    I=Declaration too late
    L=Too often entered in lotterey
    M=Not permitted to enter lottery
    N=Not complied Admin Requisites
    O=Deceased
    P=No placement certificate
    S=Too often selected
    T=Applied after close date
    V=No temp placement certificate
    W=Correspon.nbr changed
    26 SSR_SL_IBGDEFI_NLD Character(1) VARCHAR2(1) NOT NULL IBG Deficiency Status
    27 SSR_SL_TUITAMT_NLD Character(13) VARCHAR2(13) NOT NULL Payment Amount
    28 SSR_SL_TUITIND_NLD Character(1) VARCHAR2(1) NOT NULL Payment Indicator
    F=Not Paid
    O=Undo Previous Payment
    T=Paid
    29 SSR_SL_DRAW_DT_NLD Date(10) DATE Lot Drawing Date
    30 SSR_SL_DRAWRST_NLD Character(1) VARCHAR2(1) NOT NULL Lot Drawing Result
    D=Locally Drawn
    I=Selected
    J=Selected (decentralized)
    M=Locally Not Participated
    N=Locally Not Selected
    O=Conditionally Selected
    S=Locally Selected
    U=Centrally Not Selected
    V=Temp placement certificate
    31 SSR_SL_DRAWRSN_NLD Character(1) VARCHAR2(1) NOT NULL Lot Drawing Result Reason
    D=Several
    H=Hardship Clause
    N=Language Test
    O=Supremacy
    V=Not yet sufficient
    32 SSR_SL_DRAWSEQ_NLD Character(3) VARCHAR2(3) NOT NULL Lot Drawing Number
    33 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute

    Prompt Table: SCC_SUBBRIN_NLD

    34 SSR_SL_PDINST_NLD Character(4) VARCHAR2(4) NOT NULL Paid at Brincode
    35 SSR_SL_PDINSTN_NLD Character(70) VARCHAR2(70) NOT NULL paidatinstitutename paidatins
    36 SSR_SL_BARCODE_NLD Character(20) VARCHAR2(20) NOT NULL Barcode
    37 SSR_SL_ORDRNBR_NLD Character(30) VARCHAR2(30) NOT NULL Ordernumber
    38 SSR_SL_TUITNBR_NLD Character(2) VARCHAR2(2) NOT NULL Number of Payments
    39 SSR_SL_STARTMO_NLD Character(2) VARCHAR2(2) NOT NULL Start Month
    40 SSR_SL_STARTOC_NLD Character(12) VARCHAR2(12) NOT NULL Start Occasion
    41 SAD_SL_ENRLSQ_NLD Character(20) VARCHAR2(20) NOT NULL Studielink Enroll Seq Nbr
    42 SAD_SL_PARTICP_NLD Character(1) VARCHAR2(1) NOT NULL Participation
    F=False
    T=True
    43 SAD_SL_ADM_DDL_NLD Character(1) VARCHAR2(1) NOT NULL Admission Deadline
    F=False
    T=True
    44 SAD_SL_ADM_DT_NLD Date(10) DATE First Admission Date
    45 SSR_BR_INTPRG_NLD Character(1) VARCHAR2(1) NOT NULL Indication Intensive Program
    0=No
    1=Yes

    Default Value: 0