SCC_ACCOM_R_QVW

(SQL View)
 Index Back

Accommodation Request Query Vw


SELECT A.EMPLID , A.EMPL_RCD , A.ACCOMMODATION_ID , A.DT_REQUESTED , A.COMMENTS , A.RESPONSIBLE_ID , A.REQUEST_STATUS , A.STATUS_DT FROM PS_ACCOM_REQUEST A

  • Parent Record Of SCC_ACCOM_D_QVW SCC_ACCOM_O_QVW SCC_ACCOM_T_QVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: PER_ORG_ASGN_VW

    3 ACCOMMODATION_ID Number(4,0) SMALLINT NOT NULL Accommodation ID
    4 DT_REQUESTED Date(10) DATE NOT NULL Date of Request

    Default Value: %date

    5 COMMENTS Long Character CLOB Comment
    6 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Default Value: JOB.SUPERVISOR_ID

    Prompt Table: PERSON_NAME

    7 REQUEST_STATUS Character(1) VARCHAR2(1) NOT NULL Request Status
    A=Accepted
    P=Pending
    U=Undue Hardship

    Default Value: P

    8 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: SCC_ACCOM_REQ_H.DT_REQUESTED