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 Rcd Nbr
    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
    8 TAX_BASIS_UK Character(1) VARCHAR2(1) NOT NULL Tax Basis
    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 Action after Retroactive Event
    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 Employee on Secondment

    Y/N Table Edit

    19 FP_SCND_TYP Character(1) VARCHAR2(1) NOT NULL Secondment Type (Int,Ext)
    B=No Effect
    E=External Secondment
    I=Internal Secondment
    20 FP_CIVIL_PENSION Character(1) VARCHAR2(1) NOT NULL Job Leads to Civil Pension

    Y/N Table Edit

    Default Value: N

    21 FP_SOURCE_ORG Character(50) VARCHAR2(50) NOT NULL Home Organization
    22 FP_RECEP_ORG Character(30) VARCHAR2(30) NOT NULL Receiving Organization
    23 FP_RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return

    Y/N Table Edit

    24 FP_PR_LEGSTA Character(3) VARCHAR2(3) NOT NULL Position before Return

    Prompt Table: FPMLEGALSTA_TBL

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

    Y/N Table Edit

    Default Value: N

    33 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Headcount
    34 FP_HDCNT_NBR Number(1,0) SMALLINT NOT NULL Statutory Headcount
    35 FP_POTENT_NBR Number(1,0) SMALLINT NOT NULL Potential Full-Time Equivalent
    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 Grade Entry Date
    39 FP_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps

    Prompt Table: FPMCORPS_TBL

    40 FP_CHG_COR_DT Date(10) DATE Corps Change Date
    41 FP_CATG_FP Character(2) VARCHAR2(2) NOT NULL Civil Service Category
    A=A
    B=B
    C=C
    D=D
    X=No Existing Category
    42 FP_CATG_LEVEL Character(3) VARCHAR2(3) NOT NULL Category Level
    43 FP_RK_TRIALPD Character(1) VARCHAR2(1) NOT NULL Probation Period Grade

    Y/N Table Edit

    44 FP_STEP_END_DT Date(10) DATE (Sub)Step Actual End Date
    45 FP_FOR_PROM_DT Date(10) DATE Expected Advancement Date
    46 FP_NOMINATION_DT Date(10) DATE Appointment Date
    47 FP_TRAINEE Character(1) VARCHAR2(1) NOT NULL Trainee

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    55 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
    56 FP_INSTALL_DT Date(10) DATE Installation Date
    57 FP_EQUIV_STEP Character(4) VARCHAR2(4) NOT NULL Corresponding Step
    58 FP_STEP_CD2 Character(4) VARCHAR2(4) NOT NULL Derived Step
    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 2
    66 FP_PT_PCT Character(3) VARCHAR2(3) NOT NULL Working Time Percentage
    050=50
    060=60
    070=70
    080=80
    090=90
    100=100
    67 FP_PT_END_DT Date(10) DATE Part-Time End Date
    68 FP_PT_FOREND_DT Date(10) DATE PT Expected End Date
    69 FP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    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 Retroactivity Code

    Y/N Table Edit

    72 FP_ROW_END_DT Date(10) DATE JOB Instance End Date
    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 Dt
    77 INTCP_XFR_END_DT Date(10) DATE Intercompany Transfer End Date
    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 Department

    Prompt Table: DEPT_INT_VW_JPN

    80 INTCP_DEPTID2 Character(10) VARCHAR2(10) NOT NULL External DeptID

    Prompt Table: INTCPX_DPT_JPN

    81 INTCP_SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Intcmpny Trasnfer Dept SetID
    82 INTCP_COMPANY Character(3) VARCHAR2(3) NOT NULL Intercompany Transfer Company

    Prompt Table: COMPANY_TBL

    83 INTCP_COMPANY2 Character(3) VARCHAR2(3) NOT NULL External Company

    Prompt Table: INTCPX_CPY_JPN

    84 INTCP_SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Intcmpny Transfer Supv Lvl

    Prompt Table: SUPV_INT_VW_JPN

    85 INTCP_SUPV_LVL_ID2 Character(8) VARCHAR2(8) NOT NULL External Supv Lvl

    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

    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