ACCOM_JOB_TASK

(SQL Table)
 Index Back

EE Accommodation Job Tasks

U.S. only. ACCOM_JOB_TASK is part of a set of records used to record data for compliance with the Americans with Disabilities Act (ADA). A disabled employee or applicant can request that an employer make an accommodation for their disability so they can perform their job tasks adequately. Use ACCOM_JOB_TASK to record the job tasks for which an accommodation is to be made for this person. ACCOM_JOB_TASK is subordinate to ACCOM_REQUEST. You can create multiple ACCOM_JOB_TASK records for a person.

  • Parent record: ACCOM_REQUEST

    • # 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 Record

    Prompt Table: PER_ORG_ASGN_VW

    3 ACCOMMODATION_ID Number(4,0) SMALLINT NOT NULL Accommodation ID

    Default Value: 1

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

    Default Value: JOB.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Default Value: JOB.JOBCODE

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: JOBCD_TASK_TBL

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

    Prompt Table: JOB_TASK_TBL_VW