PSA_EXCPT_EE2

(SQL Table)
 Index Back

Employee Attribute Exceptions

This record stores sharing exceptions for employee attributes.

  • Parent record: PSA_SHARE_RULES

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BUPSAE_NONVW

    2 PSA_SHARE_RULE_ID Character(5) VARCHAR2(5) NOT NULL Sharing Rule ID

    Prompt Table: PSA_SHARE_RULES

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

    Prompt Table: JOBCODE_TBL

    4 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried

    Prompt Table: PSA_EMPL_TP_VW

    5 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
    A=Assignee
    C=Consultant
    E=Expatriate
    G=Agency/Temp
    I=Intern
    P=Apprentice
    R=Contractor
    T=Trainee

    Prompt Table: PSA_EMPL_CLS_VW

    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    8 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    10 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause