JOB_JR

(SQL Table)
 Index Back

Job Junior

Sibling to the JOB record - used to add new fields to JOB. This table will always have one and only one row for every row in JOB. The key structure on JOB_JR must EXACTLY match the key structure on JOB. If any change is made to the fields in this table - you must also update JOB_JR_VW (without peoplecode) for the POSITION_DATA update incumbants process.

  • Parent record: JOB

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

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 0

    5 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    7 TAXCODE_UK Character(15) VARCHAR2(15) NOT NULL Tax Code for the UK
    8 TAX_BASIS_UK Character(1) VARCHAR2(1) NOT NULL Tax Basis for the UK
    0=Cumulative
    1=Week 1/Month 1

    Default Value: 0

    9 WORKER_TYPE_MEX Character(4) VARCHAR2(4) NOT NULL Worker Type Mexico
    0010=Permanent Worker
    0020=Eventual Worker
    0030=Construction Eventual
    10 REDUCED_WEEK_MEX Character(4) VARCHAR2(4) NOT NULL Detail of Reduced Week for Mexico
    0000=Complete Week
    0010=1 Day per Week
    0020=2 Day per Week
    0030=3 Day per Week
    0040=4 Day per Week
    0050=5 Day per Week
    0060=Workday less than 8 Hours
    11 LOCATED_CD_MEX Character(18) VARCHAR2(18) NOT NULL Location Code for Mexico.
    12 SALARY_TYPE_MEX Character(4) VARCHAR2(4) NOT NULL Salary Type Mexico
    0010=Fixed Salary
    0020=Mixed Salary
    0030=Variable Salary
    0040=All Salaries
    13 IMS_TERM_DT_MEX Date(10) DATE Mexico IMSS Termination Date
    14 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.
    15 FP_ACTION_2 Character(3) VARCHAR2(3) NOT NULL HFPS
    16 CTG_RATE Number(3,0) SMALLINT NOT NULL Category Rate
    17 FP_LEGALSTAT_CD Character(3) VARCHAR2(3) NOT NULL Civil Service Position Code.

    Prompt Table: FPMLEGALSTA_TBL

    18 FP_SCNDMT_CD Character(1) VARCHAR2(1) NOT NULL Secondment for FPS

    Y/N Table Edit

    19 FP_SCND_TYP Character(1) VARCHAR2(1) NOT NULL Secondment Type for FPS
    B=No Effect
    E=External Secondment
    I=Internal Secondment
    20 FP_CIVIL_PENSION Character(1) VARCHAR2(1) NOT NULL Penison for FPS

    Y/N Table Edit

    Default Value: N

    21 FP_SOURCE_ORG Character(50) VARCHAR2(50) NOT NULL Home Organisation for FPS
    22 FP_RECEP_ORG Character(30) VARCHAR2(30) NOT NULL Rec Organisation for FPS
    23 FP_RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return Code

    Y/N Table Edit

    24 FP_PR_LEGSTA Character(3) VARCHAR2(3) NOT NULL Position for FPS

    Prompt Table: FPMLEGALSTA_TBL

    25 FP_FOREND_DT Date(10) DATE Position Expected End Date for FPS
    26 FP_END_DT Date(10) DATE Position Actual End Date
    27 FP_CAREFRZPCT Number(3,0) SMALLINT NOT NULL Career Advancment for FPS
    28 FP_HIR_DOS_SIT Character(2) VARCHAR2(2) NOT NULL Hire Status for FPS
    00=Contract Signed
    01=Hiring Done
    02=Hiring Validated
    29 FP_PT_PCT_DET Character(3) VARCHAR2(3) NOT NULL Work Time for FPS
    100=100
    50=50
    60=60
    70=70
    80=80
    90=90
    30 FP_TITLE_NUM Character(10) VARCHAR2(10) NOT NULL Title Number for FPS
    31 FP_DURATION_PCT Number(3,0) SMALLINT NOT NULL Duration for FPS
    32 FP_RATING_PRS_FLG Character(1) VARCHAR2(1) NOT NULL Rating for FPS

    Y/N Table Edit

    Default Value: N

    33 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Nbr for FPS
    34 FP_HDCNT_NBR Number(1,0) SMALLINT NOT NULL Headcount for FPS
    35 FP_POTENT_NBR Number(1,0) SMALLINT NOT NULL Potential FTE for FPS
    36 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade
    37 FP_STEP_CD Character(4) VARCHAR2(4) NOT NULL Step
    38 FP_RK_ENT_DT Date(10) DATE Date Entry for FPS
    39 FP_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps

    Prompt Table: FPMCORPS_TBL

    40 FP_CHG_COR_DT Date(10) DATE Change Date for FPS
    41 FP_CATG_FP Character(2) VARCHAR2(2) NOT NULL Category for FPS
    A=A
    B=B
    C=C
    D=D
    X=No Existing Category
    42 FP_CATG_LEVEL Character(3) VARCHAR2(3) NOT NULL Category level for FPS
    43 FP_RK_TRIALPD Character(1) VARCHAR2(1) NOT NULL Probation Date for FPS

    Y/N Table Edit

    44 FP_STEP_END_DT Date(10) DATE Step Actual End Date for FPS
    45 FP_FOR_PROM_DT Date(10) DATE From Date for FPS
    46 FP_NOMINATION_DT Date(10) DATE Nomination Date for FPS
    47 FP_TRAINEE Character(1) VARCHAR2(1) NOT NULL Trainee for FPS

    Y/N Table Edit

    48 FP_TRNE_POSN Character(1) VARCHAR2(1) NOT NULL Probationary Period state for FPS
    A=Rejected
    B=None
    E=In progress
    V=Validated
    49 FP_RK_PD_END_DT Date(10) DATE Expected Date for FPS
    50 FP_SANCTION Character(1) VARCHAR2(1) NOT NULL Sanction for FPS
    N=
    S=Sanction Extension
    Y=Sanction
    51 FP_DOWN_GRA Character(1) VARCHAR2(1) NOT NULL Grade for FPS
    N=
    Y=Downgrading
    52 FP_APPL_SAL_DT Date(10) DATE Compensation Application for FPS
    53 FP_CHG_IND Character(1) VARCHAR2(1) NOT NULL Forced Indiex for FPS

    Y/N Table Edit

    54 FP_CLD_INST Character(1) VARCHAR2(1) NOT NULL Instance Terminated for FPS

    Y/N Table Edit

    55 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL Set ID
    56 FP_INSTALL_DT Date(10) DATE Installation Date
    57 FP_EQUIV_STEP Character(4) VARCHAR2(4) NOT NULL Corresponding Step for FPS
    58 FP_STEP_CD2 Character(4) VARCHAR2(4) NOT NULL Step for FPS
    59 FP_BUSINESS_CD Character(4) VARCHAR2(4) NOT NULL Occupation Code

    Prompt Table: FPMBUISNESS_TBL

    60 FP_APPL_DT Date(10) DATE Application Date
    61 FP_CHG_SAL Character(1) VARCHAR2(1) NOT NULL Forced Salary

    Y/N Table Edit

    62 FP_POINTYP_CD Character(2) VARCHAR2(2) NOT NULL Point Type Code

    Prompt Table: FPMPOINTYP_TBL

    63 FP_GROSS_IND Number(4,0) SMALLINT NOT NULL Gross Index
    64 FP_INCS_IND Number(4,0) SMALLINT NOT NULL Increased Index
    65 FP_INCS_IND2 Number(4,0) SMALLINT NOT NULL Increased Index for FPS
    66 FP_PT_PCT Character(3) VARCHAR2(3) NOT NULL Part Time Percentage for FPS
    050=50
    060=60
    070=70
    080=80
    090=90
    100=100
    67 FP_PT_END_DT Date(10) DATE Part Time End date for FPS
    68 FP_PT_FOREND_DT Date(10) DATE Expected End Date for FPS
    69 FP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Field for FPS
    70 FP_INST_STAT Character(1) VARCHAR2(1) NOT NULL Instance Status
    D=Request
    R=Actual
    71 FP_RETROSPECT Character(1) VARCHAR2(1) NOT NULL Retro Activity for FPS

    Y/N Table Edit

    72 FP_ROW_END_DT Date(10) DATE Job Instance End date for FPS
    73 LAST_UPDATE_DATE Date(10) DATE Date of last update
    74 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier
    75 INTCP_XFR_FLG Character(1) VARCHAR2(1) NOT NULL Intercompany Transfer Flag
    1=Home Company Information
    2=Host Company Information
    76 INTCP_XFR_START_DT Date(10) DATE Intercompany transfer start date (Japan HR)
    77 INTCP_XFR_END_DT Date(10) DATE Intercompany Transfer End Date (Japan HR)
    78 INTCP_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUSUNIT_HR_VW

    79 INTCP_DEPTID Character(10) VARCHAR2(10) NOT NULL Intercompany transfer department (Japan HR)

    Prompt Table: DEPT_INT_VW_JPN

    80 INTCP_DEPTID2 Character(10) VARCHAR2(10) NOT NULL Department Appointment (Japan HR)

    Prompt Table: INTCPX_DPT_JPN

    81 INTCP_SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Intercompany transfer department set ID (Japan HR)
    82 INTCP_COMPANY Character(3) VARCHAR2(3) NOT NULL Intercompany transfer company (Japan HR)

    Prompt Table: COMPANY_TBL

    83 INTCP_COMPANY2 Character(3) VARCHAR2(3) NOT NULL Company Appointment (JAPAN HR)

    Prompt Table: INTCPX_CPY_JPN

    84 INTCP_SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Intercompany transfer supervisor level (Japan HR)

    Prompt Table: SUPV_INT_VW_JPN

    85 INTCP_SUPV_LVL_ID2 Character(8) VARCHAR2(8) NOT NULL Supervisor Level appointment (Japan HR)

    Prompt Table: INTCPX_SPV_JPN

    86 START_DATE_JPN Date(10) DATE Tracks the beginning date of an additional appointment assignment.
    87 EXP_END_DATE_JPN Date(10) DATE Tracks the date in the future when the additional appointment assignment is expected to be completed.
    88 END_DATE_JPN Date(10) DATE The actual date that an additional appointment assignment was completed.
    89 DUTIES_TYPE Character(2) VARCHAR2(2) NOT NULL The type of duties for Temporary Assignments.

    Prompt Table: TEMP_DUTIES_TBL

    90 ASSIGNMENT_ID Number(8,0) INTEGER NOT NULL This is a system assigned number solely for Temporary Assignment jobs. It is used as a link between the Temporary Assignment job row and its respective Substantive job that is temporarily put on hold.
    91 TARGET_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Target Compensation Rate
    92 CMP_DONT_ABSORB Character(1) VARCHAR2(1) NOT NULL Don't Absorb Changes
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    93 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

    Prompt Table: ESTB_CCC_ALL_VW

    94 UNITA_PROD_CD Character(6) VARCHAR2(6) NOT NULL Productive Unit

    Prompt Table: UNITA_PROD_TBL

    95 ACTION_ITA Character(3) VARCHAR2(3) NOT NULL Turnover - Action
    HIR=Hire
    LAY=Lay off
    LEA=Leave of Absence
    TER=Termination
    96 ACTION_REASON_ITA Character(3) VARCHAR2(3) NOT NULL Turnover Action Reason

    Prompt Table: TRV_ACTRSN_ITA

    97 SPECIAL_HIRCTG_ITA Character(1) VARCHAR2(1) NOT NULL Special Hiring Category
    1=Mobility List
    2=CIG List
    3=Unemployed List
    4=Unemployed - Weak Wrap
    5=Protected
    98 PART_TIME_TYPE_ITA Character(1) VARCHAR2(1) NOT NULL Type of Part Time - ITA
    C=Cyclic
    H=Horizontal
    V=Vertical
    99 PART_TIME_PERC_ITA Number(8,4) DECIMAL(7,4) NOT NULL Percentage of Part Time
    100 PARTTIME_ENDDT_ITA Date(10) DATE Part Time End Date
    101 WORKDAYS_NLD Number(4,2) DECIMAL(3,2) NOT NULL Number of working days per week... This field keeps track on the number of days an employee is working.

    Default Value: 5

    102 CONT_SAL_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Contract Salary Type Brazil
    1=Monthly
    2=Fortnightly
    3=Weekly
    4=Daily
    5=Hourly
    6=Per Task
    7=Commission
    8=Other

    Default Value: 1

    103 CBO_CD_BRA Character(7) VARCHAR2(7) NOT NULL Occupation Code for Brazil

    Default Value: JOBCODE_TBL_BRA.CBO_CD_BRA

    Prompt Table: CBO_CD_TBL_BRA

    104 SEFIP_CATEGORY_BRA Character(2) VARCHAR2(2) NOT NULL SEFIP CATEGORY Brazil
    01=Employee
    02=Temporary Worker
    03=Worker w/FGTS benefit w/o link
    04=Limited Period Employee
    05=Director not employed w/FGTS
    07=Underaged Intern
    11=Director not employed w/o FGTS
    12=Other Public Agents
    13=Self-empl w/payment withholdng
    14=Selfempl w/base-sal withholdng
    15=Ind. transporter w/contr compe
    16=Ind. transporter w/contr salar
    17=Coop worker, Service Provider
    18=Freight Coop, service provider
    19=Political Agent
    20=Non-permanent Governmnt Worker
    21=Permanent Government Worker
    22=Not Applicable

    Default Value: 01

    105 UNION_CD_ALT_BRA Character(3) VARCHAR2(3) NOT NULL Alternate Union Code Brazil

    Prompt Table: UNION_TBL

    106 ELS_STATUS Character(1) VARCHAR2(1) NOT NULL Employment and Labour Standards Status
    1=Exempt
    2=Non-Exempt

    Default Value: 2