FT_SALARYBASVO

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
4 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
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
7 FT_SALARYBAS_GUID Character(36) VARCHAR2(36) NOT NULL SALARY_BASIS_ID
8 FT_SALB_DESCR Character(80) VARCHAR2(80) NOT NULL Description
9 FT_BUS_GROUP_GUID Character(36) VARCHAR2(36) NOT NULL Business Group ID
10 FT_COMP_USAGE Character(30) VARCHAR2(30) NOT NULL Component Usage
11 FT_EL_TYPE_GUID Character(36) VARCHAR2(36) NOT NULL Element Type Guid
12 FT_GRADE_RATE_GUID Character(36) VARCHAR2(36) NOT NULL Grade Rate GUID
13 FT_INPUT_VL_GUID Character(36) VARCHAR2(36) NOT NULL Input Value Guid
14 FT_LEGALENTY_GUID Character(36) VARCHAR2(36) NOT NULL ORGANIZATION_ID GUID
15 FT_NAME60 Character(60) VARCHAR2(60) NOT NULL Name
16 FT_ANNUALIZATION Number(19,6) DECIMAL(18,6) NOT NULL Annualization Factor
17 FT_SALB_CODE Character(30) VARCHAR2(30) NOT NULL Salary Basis Code
18 FT_SALB_NAME Character(80) VARCHAR2(80) NOT NULL Salary Basis Name
19 EOTF_IMPORT_FLG Character(1) VARCHAR2(1) NOT NULL Import Value Map
N=No
Y=Yes

Y/N Table Edit

Default Value: N

20 FT_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL Process marker field
21 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

Default Value: N

22 FT_BYPASS_FLAG Character(1) VARCHAR2(1) NOT NULL Bypass Flag

Default Value: N

23 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
24 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key