ADDL_SIJP_ARG

(SQL Table)
 Index Back

SIJP Additional Information

Additional Information - SIJP

  • Parent record: JOB

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

    Prompt Table: EMPLMT_SRCH_GBL

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

    Prompt Table: EMPLMT_SRCH_GBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

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

    Default Value: A

    5 RETPLAN_ARG Character(1) VARCHAR2(1) NOT NULL Retirement Plan
    C=Corporate Retirement Plan
    G=Government Retirement Plan
    U=Undefined

    Default Value: G

    6 AFJP_CD_ARG Character(6) VARCHAR2(6) NOT NULL AFJP Code Field

    Prompt Table: AFJP_TBL_ARG

    7 HIREMOD_CD_ARG Character(3) VARCHAR2(3) NOT NULL Hire Modality Code

    Prompt Table: HIRMOD_TBL_ARG

    8 EMPSIT_CD_ARG Character(2) VARCHAR2(2) NOT NULL Country Extension Argentine - Employee Situation Code Field

    Prompt Table: EMPSIT_TBL_ARG

    9 CONDITION_CD_ARG Character(2) VARCHAR2(2) NOT NULL Condition Code Field

    Prompt Table: COND_TBL_ARG

    10 ACCIDENT_CD_ARG Character(2) VARCHAR2(2) NOT NULL Accident Code Field

    Prompt Table: ACCIDE_TBL_ARG

    11 GEOZONE_CD_ARG Character(2) VARCHAR2(2) NOT NULL Geographical Zone Code

    Prompt Table: GEOZON_TBL_ARG

    12 ACTIVITY_CD_ARG Character(3) VARCHAR2(3) NOT NULL Activity Type Code Field

    Prompt Table: ACT_TBL_ARG

    13 WORKED_TIME_ARG Character(1) VARCHAR2(1) NOT NULL SICOSS parameter value to determine what value will be displayed in the report layout: Worked Hours, Worked Days or Paygroup default value that can be either Worked Hours or Worked Days
    D=Days
    H=Hours
    P=Pay Group default value

    Default Value: P