PER_OR_ASHP_STG

(SQL Table)
 Index Back

Per Org Asgn for E&G

Staging for job modernization. Extension record for Education and Government (HP) for the PER_ORG_ASGN fields.

  • Parent record: PER_ORG_ASGN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PER_ORG_ASGN

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 HCR_ACTN_SEQN Number(3,0) SMALLINT NOT NULL Sequence number
    6 TENURE_ACCR_FLG Character(1) VARCHAR2(1) NOT NULL Accrue Tenure Services
    N=Do Not Accrue
    Y=Accrue Tenure

    Default Value: N

    7 FTE_TENURE Number(4,2) DECIMAL(3,2) NOT NULL FTE for Tenure Accrual
    8 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group

    Prompt Table: EG_CALC_SVC_VW

    9 FTE_FLX_SRVC Number(4,2) DECIMAL(3,2) NOT NULL FTE for Flex Service Accrual
    10 APPOINT_END_DT Date(10) DATE Appointment End Date
    11 CONTRACT_LENGTH Character(1) VARCHAR2(1) NOT NULL Contract Length
    0=Not Applicable
    1=<9 Month
    1=<9 Month
    2=9-10 Month
    2=9-10 Month
    3=11-12 Month
    3=11-12 Month
    4=9 Month
    5=10 Month
    6=11 Month
    7=12 Month
    8=>12 Month

    Default Value: 0