SCC_ACCOM_TSK_H

(SQL View)
 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.

SELECT ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' FROM %Table(INSTALLATION_SA)

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