SAD_SL_REENCCVW

(SQL View)
 Index Back

View for prom Re-enrl chk code

View for promting Re-enrlollment chklist code

SELECT INSTITUTION , CHECKLIST_CD , EFFDT , ADMIN_FUNCTION , EFF_STATUS , DESCR , DESCRSHORT , TRACKING_GROUP , DEFAULT_DUE_DT , DUE_DAYS , COMM_KEY ,SCC_CHECKLIST_TYPE FROM PS_CS_CHKLST_TBL WHERE ADMIN_FUNCTION ='SPRG'

  • Related Language Record: SAD_SL_REENLNG

    • # 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 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CS_CHKLST_TBL.DESCR

    8 TRACKING_GROUP Character(6) VARCHAR2(6) NOT NULL Tracking Group

    Prompt Table: TRACK_GRP_VW

    9 DEFAULT_DUE_DT Date(10) DATE Default Due Date
    10 DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Days
    11 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key

    Prompt Table: COMM_SPDKEY_TBL

    12 SCC_CHECKLIST_TYPE Character(3) VARCHAR2(3) NOT NULL Checklist Type.
    ADC=Condition List
    CML=Communication List
    HIR=Hiring
    MED=Medical
    OTH=Other
    PRM=Promise
    RQL=Requirements List
    SAL=Staff Assignment List
    TER=Termination
    TRN=Training
    XFR=Transfer