SALINC_SIML_JPN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAL_INC_ID	Character(12)	VARCHAR2(12) NOT NULL	Salary Increase ID Prompt Table: SAL_ID_TBL_JPN
2	CALC_NUM	Number(3,0)	SMALLINT NOT NULL	Calculation Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
6	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RATECD_TBL
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
10	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
11	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
12	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
13	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: SAL_GRADE_TBL
14	SALARY_MATRIX_CD	Character(5)	VARCHAR2(5) NOT NULL	Salary Matrix Code
15	BEF_SALINC_AMOUNT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount Before Salary Increase
16	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
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
18	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
19	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
20	SALINC_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Salary Increase Percent
21	SALINC_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of Salary Increase
22	NEW_SAL_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	New Salary Amount
23	SALINC_ADJUST	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjustment Amount
24	AJSTD_SAL_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjusted Salary Amount
25	AJSTD_SALINC_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Adjusted Sal Inc Percent
26	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_TBL
27	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface Default Value: OPR_DEF_TBL_HR.PAY_SYSTEM_FLG
28	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
29	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
30	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
31	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
32	PAID_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Paid Hours
33	PAID_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Paid Work Period
34	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
35	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period