HR_SALCHG_CALCS (SQL Table)	Index Back
Adhoc Salary Change Summary This table houses new salary amounts

HR_SALCHG_CALCS

(SQL Table)

Adhoc Salary Change Summary

This table houses new salary amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: PERSON.EMPLID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date

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

5 INCREASE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Increase Percent

6 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

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 NEW_ANNL_SALARY Number(15,2) DECIMAL(14,2) NOT NULL New annual salary amount

9 INCREASE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Increase Amount

10 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation per Frequency

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

12 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

13 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

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

15 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	ACTION_DT_SS	Date(10)	DATE NOT NULL	Transaction Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	INCREASE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Increase Percent
6	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
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	NEW_ANNL_SALARY	Number(15,2)	DECIMAL(14,2) NOT NULL	New annual salary amount
9	INCREASE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Increase Amount
10	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation per Frequency
11	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
12	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
13	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
14	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.
15	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.