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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Prompt Table: FPMLEGALSTA_TBL

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

    Y/N Table Edit

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

    Prompt Table: FPMCORPS_TBL

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    54 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
    55 FP_INSTALL_DT Date(10) DATE Installation Date
    56 FP_EQUIV_STEP Character(4) VARCHAR2(4) NOT NULL Corresponding Step
    57 FP_STEP_CD2 Character(4) VARCHAR2(4) NOT NULL Derived Step

    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 2
    65 FP_PT_PCT Character(3) VARCHAR2(3) NOT NULL Working Time Percentage
    050=50
    060=60
    070=70
    080=80
    090=90
    100=100
    66 FP_PT_END_DT Date(10) DATE Part-Time End Date
    67 FP_PT_FOREND_DT Date(10) DATE PT Expected End Date
    68 FP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    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 Retroactivity Code

    Y/N Table Edit

    71 FP_ROW_END_DT Date(10) DATE JOB Instance End Date
    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 Dt
    76 INTCP_XFR_END_DT Date(10) DATE Intercompany Transfer End Date
    77 INTCP_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    78 INTCP_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    79 INTCP_DEPTID2 Character(10) VARCHAR2(10) NOT NULL External DeptID
    80 INTCP_SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Intcmpny Trasnfer Dept SetID
    81 INTCP_COMPANY Character(3) VARCHAR2(3) NOT NULL Intercompany Transfer Company
    82 INTCP_COMPANY2 Character(3) VARCHAR2(3) NOT NULL External Company
    83 INTCP_SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Intcmpny Transfer Supv Lvl
    84 INTCP_SUPV_LVL_ID2 Character(8) VARCHAR2(8) NOT NULL External Supv Lvl
    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