HR_SALCHG_AMT

(SQL Table)
Index Back

Adhoc Salary Change Summary

This table houses new salary amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
3 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
4 INCREASE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Increase Percent
5 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
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 NEW_ANNL_SALARY Number(15,2) DECIMAL(14,2) NOT NULL New annual salary amount
8 INCREASE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Increase Amount
9 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation per Frequency
10 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
11 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
12 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
13 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.
14 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.