FT_SALARY_STG

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID

2 FT_OBJECT_GUID Character(36) VARCHAR2(36) NOT NULL Object Guid

3 FT_EFF_START_DATE Date(10) DATE Effective Start Date

4 FT_EFF_END_DATE Date(10) DATE Effective End Date

5 FT_EFF_SEQUENCE Number(4,0) SMALLINT NOT NULL Effective Sequence

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERS_SRCH_GBL

7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

9 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

10 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

11 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

12 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
Prompt Table: FREQUENCY_TBL

13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

15 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID

16 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

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

18 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

19 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence

20 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
Prompt Table: COMP_RATECD_TBL

21 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount

22 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

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

24 FT_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

25 FT_COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency

26 FT_CURRENCY_CODE Character(15) VARCHAR2(15) NOT NULL Currency Code

27 FT_ACTION_ORIG Character(3) VARCHAR2(3) NOT NULL Action

28 FT_ACT_RSN_ORIG Character(3) VARCHAR2(3) NOT NULL Reason Code

29 FT_SALARY_AMT_ORIG Signed Number(20,6) DECIMAL(18,6) NOT NULL SALARY_AMOUNT

30 FT_SALARY_GUID Character(36) VARCHAR2(36) NOT NULL Salary GUID

31 FT_SALARYCOMP_GUID Character(36) VARCHAR2(36) NOT NULL Salary Component GUID

32 FT_ACTION_GUID Character(36) VARCHAR2(36) NOT NULL Person Address Usuage ID

33 FT_ACTNOCCUR_GUID Character(36) VARCHAR2(36) NOT NULL Action Occurrence GUID

34 FT_ACTNREASON_GUID Character(36) VARCHAR2(36) NOT NULL Person Address Usuage ID

35 FT_ASSIGNMENT_GUID Character(36) VARCHAR2(36) NOT NULL Assignment ID

36 FT_BUS_GROUP_GUID Character(36) VARCHAR2(36) NOT NULL Business Group ID

37 FT_DATE_FROM Date(10) DATE Date From

38 FT_DATE_TO Date(10) DATE Date To

39 FT_EL_ENTR_GUID Character(36) VARCHAR2(36) NOT NULL Element Entry GUID

40 FT_FORCED_RANKING Number(3,0) SMALLINT NOT NULL Forced Ranking

41 FT_MULTIPLE_COMP Character(30) VARCHAR2(30) NOT NULL Multiple Components

42 FT_NEXT_PERF_REV Date(10) DATE Next Performance Review Date

43 FT_NEXT_SAL_REV Date(10) DATE Next Salary Review Date

44 FT_PERFORMANCE_RAT Character(30) VARCHAR2(30) NOT NULL PERFORMANCE_RATING

45 FT_PERFORMREV_GUID Character(36) VARCHAR2(36) NOT NULL PERFORMANCE_REVIEW_ID

46 FT_REVIEW_DATE Date(10) DATE REVIEW_DATE

47 FT_SALARY_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL SALARY_AMOUNT

48 FT_SALARY_APPROVED Character(30) VARCHAR2(30) NOT NULL SALARY_APPROVED

49 FT_SALARYBAS_GUID Character(36) VARCHAR2(36) NOT NULL SALARY_BASIS_ID

50 FT_REASON_CODE Character(30) VARCHAR2(30) NOT NULL Reason Code

51 FT_CHANGE_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL CHANGE_AMOUNT

52 FT_CHANGE_PERCENT Number(19,6) DECIMAL(18,6) NOT NULL CHANGE_PERCENTAGE

53 FT_WT_EFFDT Date(10) DATE Work Term Effective Date

54 FT_WT_EFFDT_PSFMT Character(10) VARCHAR2(10) NOT NULL Work Term Eff Date

55 FT_WT_EFFSEQ Number(3,0) SMALLINT NOT NULL Work Term Eff Seq

56 FT_EFFDT_STR Character(10) VARCHAR2(10) NOT NULL Effective Date

57 FT_VALUE_CHANGED Character(1) VARCHAR2(1) NOT NULL Value Changed
N=No
Y=Yes

58 FT_PROC_SEQ Number(10,0) DECIMAL(10) NOT NULL Process Sequence

59 FT_RUN_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
00=Not Processed
10=Loaded from File
20=Transformed
30=Previewed
40=Manually Posted
50=Posted

60 FT_CHNG_AMNT_ORIG Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount

61 FT_PROC_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
00=Not Processed
10=Loaded from File
20=Transformed
30=Previewed
40=Manually Posted
50=Posted

62 FT_PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL In Process
Default Value: N

63 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field

64 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes
Default Value: N

65 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag
Default Value: N

66 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record

67 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key

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

69 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	FT_RUN_ID	Number(18,0)	DECIMAL(18) NOT NULL	LEGAL_ENTITY_ID
2	FT_OBJECT_GUID	Character(36)	VARCHAR2(36) NOT NULL	Object Guid
3	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
4	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
5	FT_EFF_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Effective Sequence
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
8	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
9	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
10	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
11	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
12	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 Prompt Table: FREQUENCY_TBL
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
14	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
15	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
16	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
17	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
18	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
19	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
20	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RATECD_TBL
21	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
22	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
23	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
24	FT_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
25	FT_COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency
26	FT_CURRENCY_CODE	Character(15)	VARCHAR2(15) NOT NULL	Currency Code
27	FT_ACTION_ORIG	Character(3)	VARCHAR2(3) NOT NULL	Action
28	FT_ACT_RSN_ORIG	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
29	FT_SALARY_AMT_ORIG	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	SALARY_AMOUNT
30	FT_SALARY_GUID	Character(36)	VARCHAR2(36) NOT NULL	Salary GUID
31	FT_SALARYCOMP_GUID	Character(36)	VARCHAR2(36) NOT NULL	Salary Component GUID
32	FT_ACTION_GUID	Character(36)	VARCHAR2(36) NOT NULL	Person Address Usuage ID
33	FT_ACTNOCCUR_GUID	Character(36)	VARCHAR2(36) NOT NULL	Action Occurrence GUID
34	FT_ACTNREASON_GUID	Character(36)	VARCHAR2(36) NOT NULL	Person Address Usuage ID
35	FT_ASSIGNMENT_GUID	Character(36)	VARCHAR2(36) NOT NULL	Assignment ID
36	FT_BUS_GROUP_GUID	Character(36)	VARCHAR2(36) NOT NULL	Business Group ID
37	FT_DATE_FROM	Date(10)	DATE	Date From
38	FT_DATE_TO	Date(10)	DATE	Date To
39	FT_EL_ENTR_GUID	Character(36)	VARCHAR2(36) NOT NULL	Element Entry GUID
40	FT_FORCED_RANKING	Number(3,0)	SMALLINT NOT NULL	Forced Ranking
41	FT_MULTIPLE_COMP	Character(30)	VARCHAR2(30) NOT NULL	Multiple Components
42	FT_NEXT_PERF_REV	Date(10)	DATE	Next Performance Review Date
43	FT_NEXT_SAL_REV	Date(10)	DATE	Next Salary Review Date
44	FT_PERFORMANCE_RAT	Character(30)	VARCHAR2(30) NOT NULL	PERFORMANCE_RATING
45	FT_PERFORMREV_GUID	Character(36)	VARCHAR2(36) NOT NULL	PERFORMANCE_REVIEW_ID
46	FT_REVIEW_DATE	Date(10)	DATE	REVIEW_DATE
47	FT_SALARY_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	SALARY_AMOUNT
48	FT_SALARY_APPROVED	Character(30)	VARCHAR2(30) NOT NULL	SALARY_APPROVED
49	FT_SALARYBAS_GUID	Character(36)	VARCHAR2(36) NOT NULL	SALARY_BASIS_ID
50	FT_REASON_CODE	Character(30)	VARCHAR2(30) NOT NULL	Reason Code
51	FT_CHANGE_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	CHANGE_AMOUNT
52	FT_CHANGE_PERCENT	Number(19,6)	DECIMAL(18,6) NOT NULL	CHANGE_PERCENTAGE
53	FT_WT_EFFDT	Date(10)	DATE	Work Term Effective Date
54	FT_WT_EFFDT_PSFMT	Character(10)	VARCHAR2(10) NOT NULL	Work Term Eff Date
55	FT_WT_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Work Term Eff Seq
56	FT_EFFDT_STR	Character(10)	VARCHAR2(10) NOT NULL	Effective Date
57	FT_VALUE_CHANGED	Character(1)	VARCHAR2(1) NOT NULL	Value Changed N=No Y=Yes
58	FT_PROC_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Process Sequence
59	FT_RUN_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status 00=Not Processed 10=Loaded from File 20=Transformed 30=Previewed 40=Manually Posted 50=Posted
60	FT_CHNG_AMNT_ORIG	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
61	FT_PROC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status 00=Not Processed 10=Loaded from File 20=Transformed 30=Previewed 40=Manually Posted 50=Posted
62	FT_PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	In Process Default Value: N
63	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
64	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
65	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
66	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
67	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key
68	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.
69	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.