FPA_JOB_VW

(SQL View)
 Index Back

FPS- ViewJ ob/Job_Jr

FPS- ViewJ ob/Job_Jr

SELECT J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ , F.FP_LEGALSTAT_CD , F.FP_CAREFRZPCT , J.EMPL_STATUS , J.ACTION , J.ACTION_REASON , J.POSITION_NBR , J.POSITION_ENTRY_DT , J.DEPTID , J.SETID_DEPT , J.DEPT_ENTRY_DT , J.JOBCODE , J.JOB_ENTRY_DT , J.LOCATION , J.ESTABID , J.COMPANY , J.COMPRATE , J.COMP_FREQUENCY , J.CHANGE_AMT , J.CHANGE_PCT , J.CURRENCY_CD , J.FULL_PART_TIME , J.HOURLY_RT_FRA , J.STD_HOURS , J.REG_TEMP , J.ACCDNT_CD_FRA , J.PAYGROUP , J.EMPL_TYPE , J.EMPL_CLASS , J.POSITION_OVERRIDE , J.POSN_CHANGE_RECORD , J.BUSINESS_UNIT , J.REG_REGION , J.LABOR_AGREEMENT , J.EMPL_CTG , F.FP_ACTION_2 , F.FP_END_DT , F.FP_FOREND_DT , F.FP_SCNDMT_CD , F.FP_SCND_TYP , F.FP_RETURN_CD , F.FP_CORPS_CD , F.FP_CATG_FP , F.FP_CATG_LEVEL , F.FP_CHG_COR_DT , F.FP_RANK_CD , F.FP_SETID_RANK , F.FP_RK_ENT_DT , F.FP_RK_PD_END_DT , F.FP_STEP_CD , F.FP_STEP_END_DT , F.FP_NOMINATION_DT , F.FP_FOR_PROM_DT , F.FP_RK_TRIALPD , F.FP_TRAINEE , F.FP_TRNE_POSN , F.FP_CLD_INST , F.FP_SANCTION , F.FP_DOWN_GRA , F.FP_POINTYP_CD , F.FP_GROSS_IND , F.FP_INCS_IND , F.FP_STEP_CD2 , F.FP_BUSINESS_CD , F.FP_INSTALL_DT , F.FP_PT_PCT , F.FP_PR_LEGSTA , F.FP_BUDGET_NBR , F.FP_HDCNT_NBR , F.FP_HIR_DOS_SIT , F.FP_INST_STAT , F.FP_ROW_END_DT , J.ANNL_BENEF_BASE_RT , J.HOURLY_RT , J.DAILY_RT , J.MONTHLY_RT , J.ANNUAL_RT , J.JOB_INDICATOR FROM PS_JOB J , PS_JOB_JR F WHERE J.EMPLID = F.EMPLID AND J.EMPL_RCD = F.EMPL_RCD AND J.EFFDT = F.EFFDT AND J.EFFSEQ = F.EFFSEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT Date(10) DATE Effective Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 FP_LEGALSTAT_CD Character(3) VARCHAR2(3) NOT NULL Civil Service Position Code

Prompt Table: FPMLEGALSTA_TBL

6 FP_CAREFRZPCT Number(3,0) SMALLINT NOT NULL Career Advancement %
7 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
8 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

9 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: ACTN_REASON_TBL

10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

11 POSITION_ENTRY_DT Date(10) DATE Position Entry Date
12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

13 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
14 DEPT_ENTRY_DT Date(10) DATE Department Entry Date
15 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

16 JOB_ENTRY_DT Date(10) DATE Job Entry Date
17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

18 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

Prompt Table: ESTAB_COMP_VW

19 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

20 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
21 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
22 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
23 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

25 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
26 HOURLY_RT_FRA Character(3) VARCHAR2(3) NOT NULL Hours Type
27 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
28 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
29 ACCDNT_CD_FRA Character(1) VARCHAR2(1) NOT NULL Work Accident Type Code
0=Do not Pay
1=Building
2=Waterproofing
3=Floor Surface
4=Factory Making
5=Laboratory
6=WorkShop
7=Office
30 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

31 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
32 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

Prompt Table: EMPL_CLASS_TBL
Set Control Field: REG_REGION

33 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

Y/N Table Edit

34 POSN_CHANGE_RECORD Character(1) VARCHAR2(1) NOT NULL Position Management Record

Y/N Table Edit

35 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
36 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
37 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: EMPL_CTG

38 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

Prompt Table: EMPL_CTG_L1

39 FP_ACTION_2 Character(3) VARCHAR2(3) NOT NULL Action after Retroactive Event

Prompt Table: FPMACTION_TBL

40 FP_END_DT Date(10) DATE Position Actual End Date
41 FP_FOREND_DT Date(10) DATE Position Expected End Date
42 FP_SCNDMT_CD Character(1) VARCHAR2(1) NOT NULL Employee on Secondment

Y/N Table Edit

43 FP_SCND_TYP Character(1) VARCHAR2(1) NOT NULL Secondment Type (Int,Ext)
B=No Effect
E=External Secondment
I=Internal Secondment
44 FP_RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return

Y/N Table Edit

45 FP_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps

Prompt Table: FPMCORPS_TBL

46 FP_CATG_FP Character(2) VARCHAR2(2) NOT NULL Civil Service Category
A=A
B=B
C=C
D=D
X=No Existing Category
47 FP_CATG_LEVEL Character(3) VARCHAR2(3) NOT NULL Category Level
48 FP_CHG_COR_DT Date(10) DATE Corps Change Date
49 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade

Prompt Table: FPMRANK_TBL

50 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
51 FP_RK_ENT_DT Date(10) DATE Grade Entry Date
52 FP_RK_PD_END_DT Date(10) DATE PPd Expected End Date
53 FP_STEP_CD Character(4) VARCHAR2(4) NOT NULL Step

Prompt Table: FPMSALSTEP_TBL

54 FP_STEP_END_DT Date(10) DATE (Sub)Step Actual End Date
55 FP_NOMINATION_DT Date(10) DATE Appointment Date
56 FP_FOR_PROM_DT Date(10) DATE Expected Advancement Date
57 FP_RK_TRIALPD Character(1) VARCHAR2(1) NOT NULL Probation Period Grade

Y/N Table Edit

58 FP_TRAINEE Character(1) VARCHAR2(1) NOT NULL Trainee

Y/N Table Edit

59 FP_TRNE_POSN Character(1) VARCHAR2(1) NOT NULL Probationary Period State
A=Rejected
B=None
E=In progress
V=Validated
60 FP_CLD_INST Character(1) VARCHAR2(1) NOT NULL Instance Terminated

Y/N Table Edit

61 FP_SANCTION Character(1) VARCHAR2(1) NOT NULL Sanction
N=
S=Sanction Extension
Y=Sanction
62 FP_DOWN_GRA Character(1) VARCHAR2(1) NOT NULL Demotion
N=
Y=Downgrading
63 FP_POINTYP_CD Character(2) VARCHAR2(2) NOT NULL Point Type Code
64 FP_GROSS_IND Number(4,0) SMALLINT NOT NULL Gross Index

Prompt Table: FPMGROSSIND_TBL

65 FP_INCS_IND Number(4,0) SMALLINT NOT NULL Increased Index

Prompt Table: FPMINDEXAMT_TBL

66 FP_STEP_CD2 Character(4) VARCHAR2(4) NOT NULL Derived Step
67 FP_BUSINESS_CD Character(4) VARCHAR2(4) NOT NULL Occupation Code

Prompt Table: FPMBUISNESS_TBL

68 FP_INSTALL_DT Date(10) DATE Installation Date
69 FP_PT_PCT Character(3) VARCHAR2(3) NOT NULL Working Time Percentage
050=50
060=60
070=70
080=80
090=90
100=100
70 FP_PR_LEGSTA Character(3) VARCHAR2(3) NOT NULL Position before Return
71 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Headcount
72 FP_HDCNT_NBR Number(1,0) SMALLINT NOT NULL Statutory Headcount
73 FP_HIR_DOS_SIT Character(2) VARCHAR2(2) NOT NULL Hire Status
00=Contract Signed
01=Hiring Done
02=Hiring Validated
74 FP_INST_STAT Character(1) VARCHAR2(1) NOT NULL Instance Status
D=Request
R=Actual
75 FP_ROW_END_DT Date(10) DATE JOB Instance End Date
76 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.
77 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
78 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
79 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
80 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
81 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job