JOB_JR_VW

(SQL View)
 Index Back

Job Junior VW

JOB_JR_VW is a view of the Job JR record, without any peoplecode.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.LASTUPDDTTM ,A.LASTUPDOPRID ,A.TAXCODE_UK ,A.TAX_BASIS_UK ,A.WORKER_TYPE_MEX ,A.REDUCED_WEEK_MEX ,A.LOCATED_CD_MEX ,A.SALARY_TYPE_MEX ,A.IMS_TERM_DT_MEX ,A.FP_ACTION_2 ,A.CTG_RATE ,A.FP_LEGALSTAT_CD ,A.FP_SCNDMT_CD ,A.FP_SCND_TYP ,A.FP_CIVIL_PENSION ,A.FP_SOURCE_ORG ,A.FP_RECEP_ORG ,A.FP_RETURN_CD ,A.FP_PR_LEGSTA ,A.FP_FOREND_DT ,A.FP_END_DT ,A.FP_CAREFRZPCT ,A.FP_HIR_DOS_SIT ,A.FP_PT_PCT_DET ,A.FP_TITLE_NUM ,A.FP_DURATION_PCT ,A.FP_RATING_PRS_FLG ,A.FP_BUDGET_NBR ,A.FP_HDCNT_NBR ,A.FP_POTENT_NBR ,A.FP_RANK_CD ,A.FP_STEP_CD ,A.FP_RK_ENT_DT ,A.FP_CORPS_CD ,A.FP_CHG_COR_DT ,A.FP_CATG_FP ,A.FP_CATG_LEVEL ,A.FP_RK_TRIALPD ,A.FP_STEP_END_DT ,A.FP_FOR_PROM_DT ,A.FP_NOMINATION_DT ,A.FP_TRAINEE ,A.FP_TRNE_POSN ,A.FP_RK_PD_END_DT ,A.FP_SANCTION ,A.FP_DOWN_GRA ,A.FP_APPL_SAL_DT ,A.FP_CHG_IND ,A.FP_CLD_INST ,A.FP_SETID_RANK ,A.FP_INSTALL_DT ,A.FP_EQUIV_STEP ,A.FP_STEP_CD2 ,A.FP_BUSINESS_CD ,A.FP_APPL_DT ,A.FP_CHG_SAL ,A.FP_POINTYP_CD ,%NumToChar(A.FP_GROSS_IND) ,A.FP_INCS_IND ,A.FP_INCS_IND2 ,A.FP_PT_PCT ,A.FP_PT_END_DT ,A.FP_PT_FOREND_DT ,A.FP_COMPRATE ,A.FP_INST_STAT ,A.FP_RETROSPECT ,A.FP_ROW_END_DT ,A.LAST_UPDATE_DATE ,A.OTHER_ID_JPN ,A.INTCP_XFR_FLG ,A.INTCP_XFR_START_DT ,A.INTCP_XFR_END_DT ,A.INTCP_BUS_UNIT ,A.INTCP_DEPTID ,A.INTCP_DEPTID2 ,A.INTCP_SETID_DEPT ,A.INTCP_COMPANY ,A.INTCP_COMPANY2 ,A.INTCP_SUPV_LVL_ID ,A.INTCP_SUPV_LVL_ID2 ,A.DUTIES_TYPE ,A.ASSIGNMENT_ID ,A.TARGET_COMPRATE ,A.CMP_DONT_ABSORB ,A.SSN_EMPLOYER ,A.UNITA_PROD_CD ,A.ACTION_ITA ,A.ACTION_REASON_ITA ,A.SPECIAL_HIRCTG_ITA ,A.PART_TIME_TYPE_ITA ,A.PART_TIME_PERC_ITA ,A.PARTTIME_ENDDT_ITA ,A.WORKDAYS_NLD ,A.ELS_STATUS FROM PS_JOB_JR A

  • 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
    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
    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 FP_ACTION_2 Character(3) VARCHAR2(3) NOT NULL HFPS
    15 CTG_RATE Number(3,0) SMALLINT NOT NULL Category Rate
    16 FP_LEGALSTAT_CD Character(3) VARCHAR2(3) NOT NULL Civil Service Position Code.

    Prompt Table: FPMLEGALSTA_TBL

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: FPMLEGALSTA_TBL

    24 FP_FOREND_DT Date(10) DATE Position Expected End Date for FPS
    25 FP_END_DT Date(10) DATE Position Actual End Date
    26 FP_CAREFRZPCT Number(3,0) SMALLINT NOT NULL Career Advancment for FPS
    27 FP_HIR_DOS_SIT Character(2) VARCHAR2(2) NOT NULL Hire Status for FPS
    00=Contract Signed
    01=Hiring Done
    02=Hiring Validated
    28 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
    29 FP_TITLE_NUM Character(10) VARCHAR2(10) NOT NULL Title Number for FPS
    30 FP_DURATION_PCT Number(3,0) SMALLINT NOT NULL Duration for FPS
    31 FP_RATING_PRS_FLG Character(1) VARCHAR2(1) NOT NULL Rating for FPS

    Y/N Table Edit

    32 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Nbr for FPS
    33 FP_HDCNT_NBR Number(1,0) SMALLINT NOT NULL Headcount for FPS
    34 FP_POTENT_NBR Number(1,0) SMALLINT NOT NULL Potential FTE for FPS
    35 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade

    Prompt Table: FPMRANK_TBL

    36 FP_STEP_CD Character(4) VARCHAR2(4) NOT NULL Step

    Prompt Table: FPMSALSTEP_TBL

    37 FP_RK_ENT_DT Date(10) DATE Date Entry for FPS
    38 FP_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps

    Prompt Table: FPMCORPS_TBL

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: FPMSALSTEP_TBL

    58 FP_BUSINESS_CD Character(4) VARCHAR2(4) NOT NULL Occupation Code

    Prompt Table: FPMBUISNESS_TBL

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

    Y/N Table Edit

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

    Prompt Table: FPMPOINTYP_TBL

    62 FP_GROSSIND_CD Character(4) VARCHAR2(4) NOT NULL Gross Index Table Code
    63 FP_INCS_IND Number(4,0) SMALLINT NOT NULL Increased Index
    64 FP_INCS_IND2 Number(4,0) SMALLINT NOT NULL Increased Index for FPS
    65 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
    66 FP_PT_END_DT Date(10) DATE Part Time End date for FPS
    67 FP_PT_FOREND_DT Date(10) DATE Expected End Date for FPS
    68 FP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Field for FPS
    69 FP_INST_STAT Character(1) VARCHAR2(1) NOT NULL Instance Status
    D=Request
    R=Actual
    70 FP_RETROSPECT Character(1) VARCHAR2(1) NOT NULL Retro Activity for FPS

    Y/N Table Edit

    71 FP_ROW_END_DT Date(10) DATE Job Instance End date for FPS
    72 LAST_UPDATE_DATE Date(10) DATE Date of last update
    73 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier
    74 INTCP_XFR_FLG Character(1) VARCHAR2(1) NOT NULL Intercompany Transfer Flag
    1=Home Company Information
    2=Host Company Information
    75 INTCP_XFR_START_DT Date(10) DATE Intercompany transfer start date (Japan HR)
    76 INTCP_XFR_END_DT Date(10) DATE Intercompany Transfer End Date (Japan HR)
    77 INTCP_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    78 INTCP_DEPTID Character(10) VARCHAR2(10) NOT NULL Intercompany transfer department (Japan HR)
    79 INTCP_DEPTID2 Character(10) VARCHAR2(10) NOT NULL Department Appointment (Japan HR)
    80 INTCP_SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Intercompany transfer department set ID (Japan HR)
    81 INTCP_COMPANY Character(3) VARCHAR2(3) NOT NULL Intercompany transfer company (Japan HR)
    82 INTCP_COMPANY2 Character(3) VARCHAR2(3) NOT NULL Company Appointment (JAPAN HR)
    83 INTCP_SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Intercompany transfer supervisor level (Japan HR)
    84 INTCP_SUPV_LVL_ID2 Character(8) VARCHAR2(8) NOT NULL Supervisor Level appointment (Japan HR)
    85 DUTIES_TYPE Character(2) VARCHAR2(2) NOT NULL The type of duties for Temporary Assignments.
    86 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.
    87 TARGET_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Target Compensation Rate
    88 CMP_DONT_ABSORB Character(1) VARCHAR2(1) NOT NULL Don't Absorb Changes
    N=No
    Y=Yes

    Y/N Table Edit

    89 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
    90 UNITA_PROD_CD Character(6) VARCHAR2(6) NOT NULL Productive Unit
    91 ACTION_ITA Character(3) VARCHAR2(3) NOT NULL Turnover - Action
    HIR=Hire
    LAY=Lay off
    LEA=Leave of Absence
    TER=Termination
    92 ACTION_REASON_ITA Character(3) VARCHAR2(3) NOT NULL Turnover Action Reason
    93 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
    94 PART_TIME_TYPE_ITA Character(1) VARCHAR2(1) NOT NULL Type of Part Time - ITA
    C=Cyclic
    H=Horizontal
    V=Vertical
    95 PART_TIME_PERC_ITA Number(8,4) DECIMAL(7,4) NOT NULL Percentage of Part Time
    96 PARTTIME_ENDDT_ITA Date(10) DATE Part Time End Date
    97 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

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

    Default Value: 2