SSR_PRG_INF_NLD

(SQL Table)
 Index Back

Home Campus Organizations NLD

Registration of Campus, academic program and Brincode Netherlands

  • Parent record: ACAD_PROG

    • # 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 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SSR_PROPD_EXM_NLD Character(1) VARCHAR2(1) NOT NULL Propedeutic Exam
    0=Not Applicable
    1=Yes
    5 SSR_SECTOR_NLD Character(70) VARCHAR2(70) NOT NULL Sector
    6 SSR_SUBSECT_NLD Character(70) VARCHAR2(70) NOT NULL Sub-Sector
    7 SSR_FUNDING_NLD Character(1) VARCHAR2(1) NOT NULL Indication Funding
    1=Funded
    2=Acknowledged
    3=Appointed
    4=Unknown
    5=Not Applicable
    6=Open
    7=Not Funded
    8 SSR_PRGM_CRDT_NLD Number(4,0) SMALLINT NOT NULL Program Credits
    9 SSR_PRGCRD_VT_NLD Number(3,0) SMALLINT NOT NULL Program Credits VT
    10 SSR_ACCRFRM_DT_NLD Date(10) DATE Accreditation From Date
    11 SSR_ACCRTODT_NLD Date(10) DATE Accreditation to date
    12 SSR_ACCREND_DT_NLD Date(10) DATE Dt end enrolment accreditation
    13 SSR_ACCRPST_DT_NLD Date(10) DATE Postponement dt accreditation
    14 SAD_BR_ENR_END_DT Date(10) DATE Enrollment End Date
    15 SSR_ENRL_DEFIC_NLD Character(1) VARCHAR2(1) NOT NULL Indication Enrolment Deficienc
    1=Possible
    2=Not Possible
    3=Not Applicable
    16 SSR_ADMIND_CI_NLD Character(1) VARCHAR2(1) NOT NULL Indication Adm Central/Inst
    C=Central
    I=Institution
    17 SSR_FIXUS_TYP_NLD Character(1) VARCHAR2(1) NOT NULL Indication Type Fixus
    I=Institution Fixus
    S=Program Fixus
    18 SSR_DECNTR_IND_NLD Character(1) VARCHAR2(1) NOT NULL Decentral Selection Indication
    J=Yes
    N=No
    19 SSR_DECN_ENDDT_NLD Date(10) DATE End Date Decentral Selection
    20 SSR_ADDREQ_IND_NLD Character(1) VARCHAR2(1) NOT NULL Indication Additional Requirem
    J=Yes
    N=No
    21 SSR_SL_EQUIPRG_NLD Character(5) VARCHAR2(5) NOT NULL Equivalent Academic program
    22 SSR_CROHO_IND_NLD Character(1) VARCHAR2(1) NOT NULL Indication CROHO
    0=Not in CROHO
    1=In CROHO
    23 SSR_PRFREQ_IND_NLD Character(1) VARCHAR2(1) NOT NULL Indication Professional Req
    J=Yes
    N=No
    24 SSR_OFIC_INTNM_NLD Character(225) VARCHAR2(225) NOT NULL Official International Name
    25 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    26 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    27 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    28 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time