SCC_ACCOM_O_QVW

(SQL View)
 Index Back

Accommodation Options Query Vw


SELECT A.EMPLID , A.EMPL_RCD , A.ACCOMMODATION_ID , A.ACCOMMODATION_OPT , A.ACCOMMODATION_TYPE , A.DESCRLONG , A.CURRENCY_CD , A.ACCOM_COST , A.EMPLOYER_SUGGESTED , A.ACCOM_STATUS , A.STATUS_DT FROM PS_ACCOM_OPTION A

  • Related Language Record: SCC_ACCOM_OP_LN

  • Parent record: SCC_ACCOM_R_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 ACCOMMODATION_OPT Number(3,0) SMALLINT NOT NULL Accommodation Options
    5 ACCOMMODATION_TYPE Character(6) VARCHAR2(6) NOT NULL Accommodation Type

    Prompt Table: HCR_ACCOM_TYP_I

    6 DESCRLONG Long Character CLOB Long Description
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    8 ACCOM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost of Accommodation
    9 EMPLOYER_SUGGESTED Character(1) VARCHAR2(1) NOT NULL Employer Suggested Option

    Y/N Table Edit

    Default Value: N

    10 ACCOM_STATUS Character(1) VARCHAR2(1) NOT NULL Accommodation Status
    A=Approved
    C=Consider
    O=Offered
    P=Accepted
    R=Rejected
    U=Undue Hardship

    Default Value: C

    11 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: ACCOM_REQUEST.DT_REQUESTED