SCC_ACCOM_T_QVW

(SQL View)
Index Back

Accommodation Tasks Quer y Vw


SELECT A.EMPLID , A.EMPL_RCD , A.ACCOMMODATION_ID , A.JOBCODE , A.LOCATION , A.JOB_TASK , A.BUSINESS_UNIT FROM PS_ACCOM_JOB_TASK A

  • 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 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Default Value: JOB.JOBCODE

    Prompt Table: HCR_JOBCODE_I

    5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: JOBCD_TASK_TBL

    6 JOB_TASK Character(6) VARCHAR2(6) NOT NULL Job Task

    Prompt Table: JOBCD_TASK_DEFN

    7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: JOB.BUSINESS_UNIT

    Prompt Table: HCR_BS_UNT_HR_I