HR_SALCHG_AMT(SQL Table) |
Index Back |
---|---|
Adhoc Salary Change SummaryThis 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. |