SCC_ACCOM_D_QVW

(SQL View)
 Index Back

Accommodation Diagnosis Query


SELECT A.EMPLID , A.EMPL_RCD , A.ACCOMMODATION_ID , A.DIAGNOSIS_CD , A.REG_REGION FROM PS_ACCOM_DIAGNOSIS 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 DIAGNOSIS_CD Character(6) VARCHAR2(6) NOT NULL Diagnosis Code

    Prompt Table: DIAGNOSIS_TBL

    5 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: JOB.REG_REGION

    Prompt Table: REG_STANDARD_VW