SSR_PE_PRG_AIR

(SQL Table)
Index Back

PE Academic Program AIR

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

    Prompt Table: ACAD_PROG_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SSR_PE_MAP_GRP Number(4,0) SMALLINT NOT NULL Group ID
    5 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    6 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

    Prompt Table: SSR_AIR_PRG_VW1

    7 SSR_PE_PRG_GRBASIS Character(3) VARCHAR2(3) NOT NULL Default Grading Basis

    Prompt Table: GRADE_BASIS_TBL

    8 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    9 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    10 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    11 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time