HRS_ACMDIAG_HST

(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 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_ACCOMMODATN_ID Number(4,0) SMALLINT NOT NULL Accommodation Id

    Default Value: 1

    5 HRS_DIAGNOSIS_CD Character(6) VARCHAR2(6) NOT NULL Diagnosis Code
    6 HRS_REG_REGION Character(5) VARCHAR2(5) NOT NULL Reg Region
    7 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    8 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    9 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    10 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id