FPY_POS_STG_TBL (SQL Table)	Index Back
Position Staging Table Position Staging Table

FPY_POS_STG_TBL

(SQL Table)

Position Staging Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FPY_POSITION_ID Number(18,0) DECIMAL(18) NOT NULL Position ID

2 FPY_START_DTTM Character(50) VARCHAR2(50) NOT NULL Start Date Time

3 FPY_EFF_END_DT Character(50) VARCHAR2(50) NOT NULL Effective End Date

4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

5 FPY_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL FPY_PROC_MARKER

6 FPY_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL FPY Error Flag
N=No
Y=Yes

7 FPY_MODE Character(1) VARCHAR2(1) NOT NULL FPY_MODE

8 FPY_JOB_CI Character(1) VARCHAR2(1) NOT NULL FPY_JOB_CI

9 FPY_PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Processed Flag

10 FPY_BYPASS_FLG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

11 FPY_ERR_CORR_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
N=No
Y=Yes

12 FPY_BUS_OBJ Character(3) VARCHAR2(3) NOT NULL Business Object
ABS=Absence
ADD=Person Address
ALL=All
BNS=Bonus
BUS=Business Unit
CCI=Company
CMP=Compensation Data
COM=Company
DCI=Department
DEP=Department
EML=Person Email
JCD=JobCode
JCI=Job Data
JOB=Job Data
LCI=Location
LEG=Person Legislative Data
LOC=Location
NAM=Person Name
NID=Person National Identifier
OCI=JobCode
ORG=Organisation Instance
PCI=Person
PER=Person
PHN=Person Phone
POS=Position
SCI=Position

13 FPY_POSITION_CODE Character(120) VARCHAR2(120) NOT NULL Position Code

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

15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

16 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

17 DESCR Character(30) VARCHAR2(30) NOT NULL Description

18 EFFDT Date(10) DATE Effective Date
Default Value: %date

19 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

20 FPY_BUSINESS_UNIT Character(120) VARCHAR2(120) NOT NULL Business Unit Name

21 FPY_BARG_UNIT Character(120) VARCHAR2(120) NOT NULL Bargaining Unit

22 FPY_JOB_SHARE Character(120) VARCHAR2(120) NOT NULL Job Share

23 FPY_STD_HRS_FREQ Character(120) VARCHAR2(120) NOT NULL Standard Hrs Frequency

24 FPY_FTE Number(20,15) DECIMAL(19,15) NOT NULL FTE

25 FPY_FULL_PART_TIME Character(120) VARCHAR2(120) NOT NULL Full /Part Time

26 FPY_EFF_STATUS Character(120) VARCHAR2(120) NOT NULL Active Status

27 FPY_POS_STATUS Character(120) VARCHAR2(120) NOT NULL Position Status

28 FPY_JOB_ID Number(18,0) DECIMAL(18) NOT NULL Job ID

29 FPY_LOCATION_ID Number(18,0) DECIMAL(18) NOT NULL Location Id

30 FPY_DEPT_ID Number(18,0) DECIMAL(18) NOT NULL Dept ID

31 FPY_REG_TEMP Character(120) VARCHAR2(120) NOT NULL Reg Temp

32 FPY_ACTION Character(120) VARCHAR2(120) NOT NULL Action for Job Data

33 FPY_ACTION_DT Character(50) VARCHAR2(50) NOT NULL Action Date

34 FPY_ACTION_REASON Character(120) VARCHAR2(120) NOT NULL Job Action Reason

35 FPY_NAME Character(254) VARCHAR2(254) NOT NULL Name

36 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

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

38 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

39 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
A=Approved
P=Proposed
R=Frozen

40 ACTION Character(3) VARCHAR2(3) NOT NULL Action

41 ACTION_DT Date(10) DATE Action Date

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

43 JOB_SHARE Character(1) VARCHAR2(1) NOT NULL Job Sharing Permitted

44 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

45 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2

46 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

47 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

48 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count

49 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

50 STEP Number(2,0) SMALLINT NOT NULL Step

51 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

52 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

53 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.

54 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FPY_POSITION_ID	Number(18,0)	DECIMAL(18) NOT NULL	Position ID
2	FPY_START_DTTM	Character(50)	VARCHAR2(50) NOT NULL	Start Date Time
3	FPY_EFF_END_DT	Character(50)	VARCHAR2(50) NOT NULL	Effective End Date
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	FPY_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	FPY_PROC_MARKER
6	FPY_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	FPY Error Flag N=No Y=Yes
7	FPY_MODE	Character(1)	VARCHAR2(1) NOT NULL	FPY_MODE
8	FPY_JOB_CI	Character(1)	VARCHAR2(1) NOT NULL	FPY_JOB_CI
9	FPY_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processed Flag
10	FPY_BYPASS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag
11	FPY_ERR_CORR_REQD	Character(1)	VARCHAR2(1) NOT NULL	Correction Required N=No Y=Yes
12	FPY_BUS_OBJ	Character(3)	VARCHAR2(3) NOT NULL	Business Object ABS=Absence ADD=Person Address ALL=All BNS=Bonus BUS=Business Unit CCI=Company CMP=Compensation Data COM=Company DCI=Department DEP=Department EML=Person Email JCD=JobCode JCI=Job Data JOB=Job Data LCI=Location LEG=Person Legislative Data LOC=Location NAM=Person Name NID=Person National Identifier OCI=JobCode ORG=Organisation Instance PCI=Person PER=Person PHN=Person Phone POS=Position SCI=Position
13	FPY_POSITION_CODE	Character(120)	VARCHAR2(120) NOT NULL	Position Code
14	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
15	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
16	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
19	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
20	FPY_BUSINESS_UNIT	Character(120)	VARCHAR2(120) NOT NULL	Business Unit Name
21	FPY_BARG_UNIT	Character(120)	VARCHAR2(120) NOT NULL	Bargaining Unit
22	FPY_JOB_SHARE	Character(120)	VARCHAR2(120) NOT NULL	Job Share
23	FPY_STD_HRS_FREQ	Character(120)	VARCHAR2(120) NOT NULL	Standard Hrs Frequency
24	FPY_FTE	Number(20,15)	DECIMAL(19,15) NOT NULL	FTE
25	FPY_FULL_PART_TIME	Character(120)	VARCHAR2(120) NOT NULL	Full /Part Time
26	FPY_EFF_STATUS	Character(120)	VARCHAR2(120) NOT NULL	Active Status
27	FPY_POS_STATUS	Character(120)	VARCHAR2(120) NOT NULL	Position Status
28	FPY_JOB_ID	Number(18,0)	DECIMAL(18) NOT NULL	Job ID
29	FPY_LOCATION_ID	Number(18,0)	DECIMAL(18) NOT NULL	Location Id
30	FPY_DEPT_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dept ID
31	FPY_REG_TEMP	Character(120)	VARCHAR2(120) NOT NULL	Reg Temp
32	FPY_ACTION	Character(120)	VARCHAR2(120) NOT NULL	Action for Job Data
33	FPY_ACTION_DT	Character(50)	VARCHAR2(50) NOT NULL	Action Date
34	FPY_ACTION_REASON	Character(120)	VARCHAR2(120) NOT NULL	Job Action Reason
35	FPY_NAME	Character(254)	VARCHAR2(254) NOT NULL	Name
36	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
37	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
38	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
39	POSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Position Status A=Approved P=Proposed R=Frozen
40	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
41	ACTION_DT	Date(10)	DATE	Action Date
42	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
43	JOB_SHARE	Character(1)	VARCHAR2(1) NOT NULL	Job Sharing Permitted
44	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
45	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
46	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
47	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
48	MAX_HEAD_COUNT	Number(4,0)	SMALLINT NOT NULL	Max Head Count
49	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
50	STEP	Number(2,0)	SMALLINT NOT NULL	Step
51	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
52	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
53	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.
54	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.