HRS_APP_ACMDIAG

(SQL Table)
 Index Back

Accommodation Diagnosis

U.S. only. APP_ACCOM_DIAGN is part of a set of records used to record data for compliance with the Americans with Disabilities Act (ADA). A disabled applicant can request that a potential employer make an accommodation for their disability so they can perform their job tasks adequately. Use APP_ACCOM_DIAG to record the diagnosis of the person's disability. APP_ACCOM_DIAG is subordinate to APP_ACCOM_RQST. You can create multiple APP_ACCOM_DIAG records for a person. U.S. only.

  • Parent record: HRS_APP_ACMRQST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_ACCOMMODATN_ID Number(4,0) SMALLINT NOT NULL Accommodation Id

    Default Value: 1

    3 HRS_DIAGNOSIS_CD Character(6) VARCHAR2(6) NOT NULL Diagnosis Code

    Prompt Table: HRS_DIAGNOSIS_I

    4 HRS_REG_REGION Character(5) VARCHAR2(5) NOT NULL Reg Region

    Prompt Table: HRS_REG_REGN_I

    5 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    6 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    7 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    8 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id