SAD_BR_VA_NLD

(SQL Table)
Index Back

BRON setup VAVO

BRON setup VAVO

  • Parent Record Of SAD_BR_ENREN_VA SAD_BR_ENRP_VA SAD_BR_ILTCG_NL SAD_BR_ILTPG_NL SAD_BR_ILTPP_NL SAD_BR_ILTPS_NL SAD_BR_LINE_NBR SAD_BR_RKNT_NLD SAD_BR_VA_RCTYP SSR_BR_ILTCG_NL SSR_BR_ILTPG_NL SSR_BR_ILTPP_NL SSR_BR_ILTPS_NL SSR_BR_RKNT_NLD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: SCC_BRINCD_NLD

    3 SAD_BR_EDU_SEC_NLD Character(2) VARCHAR2(2) NOT NULL Educational Sector
    BO=Professional Education
    ED=Education
    VA=VAVO

    Default Value: VA

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 SAD_BR_NO_VAVO_NLD Character(1) VARCHAR2(1) NOT NULL 331-332 Do Not Send VAVO Rslt

    Y/N Table Edit

    6 SAD_BR_NEWVAL_NLD Character(4) VARCHAR2(4) NOT NULL BRON New arrival Value

    Prompt Table: STDNT_GROUP_TBL

    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End Date
    9 SAD_BR_TRM_END_NLD Character(1) VARCHAR2(1) NOT NULL Term End Date
    E=Expected Graduation Date
    O=End Date OWO
    10 SAD_BR_HIG_PED_NLD Character(1) VARCHAR2(1) NOT NULL Highest Prior Education
    A=Admissions Prior Education NLD
    R=Student Prior Educations NLD
    11 SAD_BR_SUPM_BY_NLD Date(10) DATE Suppress Mut on Enrol ended by
    12 SAD_BR_306_C_PST Character(1) VARCHAR2(1) NOT NULL Suppress Postal Changes

    Y/N Table Edit

    Default Value: N

    13 SAD_BR_322_NO_SND Character(1) VARCHAR2(1) NOT NULL 322 Do Not Send BPV

    Y/N Table Edit

    Default Value: N

    14 SAD_BR_SRC_EXM_NLD Character(1) VARCHAR2(1) NOT NULL Source for Exam Data
    P=Program Enroll/Activity Mngmnt
    T=Test Administration NLD
    15 SAD_BR_SUPM_TR_NLD Character(4) VARCHAR2(4) NOT NULL Suppress Exam Mut. upto Term

    Prompt Table: SAD_BR_TERM_VW

    16 SAD_BR_SUP_DEL_NLD Character(1) VARCHAR2(1) NOT NULL Sup Del of exch cert for non e

    Y/N Table Edit

    17 SAD_BR_CUM_LAUDE Character(4) VARCHAR2(4) NOT NULL BRON Indication Cum Laude

    Prompt Table: PROG_RSN_BR_VW
    Set Control Field: INSTITUTION