SSR_AIR_HDR

(SQL Table)
 Index Back

Academic Item Reg Header

  • Related Language Record: SSR_AIR_HDR_LN

  • Parent Record Of SSR_AIR_ADD SSR_AIR_ELEM SSR_AIR_ELEM_V3 SSR_AIR_GRD SSR_AIR_HDR_RPT SSR_AIR_PAMDE_V SSR_AIR_PARM SSR_AIR_PARM_VW SSR_AIR_RSLT SSR_AIR_RSLT_VW SSR_AIR_RSL_DVW SSR_AIR_RULE SSR_AIR_RULE_LN SSR_AIR_RULE_VW SSR_AIR_SCRTY SSR_MP_CRSGP_VW

    • # 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 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID

    Default Value: 00000000000

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 END_EFFDT Date(10) DATE End Effdt
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type

    Prompt Table: SSR_ITEM_TYPE

    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 SSR_DESCRLONG Long Character CLOB Report Description
    9 SSR_CREDITS Number(8,3) DECIMAL(7,3) NOT NULL Credits
    10 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

    Prompt Table: DEGREE_INTRN_VW

    11 SSR_APPR_REQD_FL Character(1) VARCHAR2(1) NOT NULL Requires Approval

    Y/N Table Edit

    Default Value: N

    12 SSR_INSTRCTN_LONG Long Character CLOB Instructions
    13 SSR_INTERNAL_CODE Character(50) VARCHAR2(50) NOT NULL Internal Description

    Prompt Table: SSR_AIR_DESCRVW

    14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time