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 Record
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 Advancment for FPS
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 Set ID
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 HFR
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 HFR
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 HFPS

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 for FPS
42 FP_SCNDMT_CD Character(1) VARCHAR2(1) NOT NULL Secondment for FPS

Y/N Table Edit

43 FP_SCND_TYP Character(1) VARCHAR2(1) NOT NULL Secondment Type for FPS
B=No Effect
E=External Secondment
I=Internal Secondment
44 FP_RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return Code

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 Category for FPS
A=A
B=B
C=C
D=D
X=No Existing Category
47 FP_CATG_LEVEL Character(3) VARCHAR2(3) NOT NULL Category level for FPS
48 FP_CHG_COR_DT Date(10) DATE Change Date for FPS
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 Set ID
51 FP_RK_ENT_DT Date(10) DATE Date Entry for FPS
52 FP_RK_PD_END_DT Date(10) DATE Expected Date for FPS
53 FP_STEP_CD Character(4) VARCHAR2(4) NOT NULL Step

Prompt Table: FPMSALSTEP_TBL

54 FP_STEP_END_DT Date(10) DATE Step Actual End Date for FPS
55 FP_NOMINATION_DT Date(10) DATE Nomination Date for FPS
56 FP_FOR_PROM_DT Date(10) DATE From Date for FPS
57 FP_RK_TRIALPD Character(1) VARCHAR2(1) NOT NULL Probation Date for FPS

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

61 FP_SANCTION Character(1) VARCHAR2(1) NOT NULL Sanction for FPS
N=
S=Sanction Extension
Y=Sanction
62 FP_DOWN_GRA Character(1) VARCHAR2(1) NOT NULL Grade for FPS
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 Step for FPS
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 Part Time Percentage for FPS
050=50
060=60
070=70
080=80
090=90
100=100
70 FP_PR_LEGSTA Character(3) VARCHAR2(3) NOT NULL Position for FPS
71 FP_BUDGET_NBR Number(1,0) SMALLINT NOT NULL Budget Nbr for FPS
72 FP_HDCNT_NBR Number(1,0) SMALLINT NOT NULL Headcount for FPS
73 FP_HIR_DOS_SIT Character(2) VARCHAR2(2) NOT NULL Hire Status for FPS
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 for FPS
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