SCC_ACCOM_OPT_H

(SQL View)
 Index Back

EE Accommodation Options

U.S. only. ACCOM_OPTION 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_OPTION to record the various options available for accommodating this person's disability. ACCOM_OPTION is subordinate to ACCOM_REQUEST. You can create multiple ACCOM_OPTION records for a person.

SELECT ' ' , 0 , 0 , 0 , ' ' , D.DB2_NULL_LONG , ' ' , 0 , ' ' , ' ' , %DateNull FROM %Table(INSTALLATION_SA) , PS_DB2_NULL_FLDS D

  • Related Language Record: SCC_ACCOM_OP_LN

  • 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 ACCOMMODATION_OPT Number(3,0) SMALLINT NOT NULL Accommodation Options
    5 ACCOMMODATION_TYPE Character(6) VARCHAR2(6) NOT NULL Accommodation Type

    Prompt Table: HCR_ACCOM_TYP_I

    6 DESCRLONG Long Character CLOB Long Description
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    8 ACCOM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost of Accommodation
    9 EMPLOYER_SUGGESTED Character(1) VARCHAR2(1) NOT NULL Employer Suggested Option

    Y/N Table Edit

    Default Value: N

    10 ACCOM_STATUS Character(1) VARCHAR2(1) NOT NULL Accommodation Status
    A=Approved
    C=Consider
    O=Offered
    P=Accepted
    R=Rejected
    U=Undue Hardship

    Default Value: C

    11 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: ACCOM_REQUEST.DT_REQUESTED