SSR_BR_MENR_DEL

(SQL Table)
 Index Back

BRON HO Enrollment Mirror Tbl

BRON HO Delivery of Enrollment Mirror Table

  • Parent record: SSR_BR_TRIN_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
    3 SSR_BRHO_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL BRON Enrolment Seq Nbr
    4 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
    5 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
    6 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
    7 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
    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 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
    10 SSR_BR_AC_LDAP_NLD Character(2) VARCHAR2(2) NOT NULL Approved Academic Load
    DT=Part-Time
    DU=Dual
    VT=Full-Time
    11 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
    12 ENROLLMENT_DT Date(10) DATE Original Enrollment Date
    13 SAD_BR_ENR_END_DT Date(10) DATE Enrollment End Date
    14 SSR_BR_END_RSN_NLD Character(80) VARCHAR2(80) NOT NULL Funding Source
    15 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies
    16 SSR_BR_INTPRG_NLD Character(1) VARCHAR2(1) NOT NULL Indication Intensive Program
    0=No
    1=Yes