FA_AU_CHKLST_VW

(SQL View)
 Index Back

FA Admin Functn Checlist View

Used on FA Status page, SS_FA_AU_STATUS.

SELECT A.COMMON_ID ,A.INSTITUTION ,A.SEQ_3C ,A.VAR_DATA_SEQ ,B.CHKLST_ITEM_CD ,C.DESCR ,B.ITEM_STATUS ,B.STATUS_DT ,B.DUE_DT FROM PS_PERSON_CHECKLST A ,PS_PERSON_CHK_ITEM B ,PS_SCC_CKLSITM_TBL C WHERE A.COMMON_ID = B.COMMON_ID AND A.SEQ_3C = B.SEQ_3C AND C.CHKLST_ITEM_CD = B.CHKLST_ITEM_CD AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_SCC_CKLSITM_TBL C1 WHERE C1.CHKLST_ITEM_CD = C.CHKLST_ITEM_CD AND C1.EFFDT <= %CurrentDateIn) AND A.ADMIN_FUNCTION IN ('AWRD','BDGT','FINA','FINT','ISIR','LOAN','RSTR')

  • Related Language Record: FAAUCHKLSTVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    4 VAR_DATA_SEQ Number(4,0) SMALLINT NOT NULL Variable Data Sequence Number
    5 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
    A=Active
    C=Completed
    I=Initiated
    N=Notified
    O=Ordered
    P=Paid Off
    R=Received
    S=Second Notification
    T=Returned
    W=Waived
    X=Cancelled
    8 STATUS_DT Date(10) DATE Status Date
    9 DUE_DT Date(10) DATE Due Date