TRANSACTION_NAMESS_GRP_IDSS_TRANS_IDDefault Value: %date
HR_SALCHG_EFF_V(SQL View) |
Index Back |
|---|---|
Ad Hoc Salary Change Eff DateAdhoc Salary Change. Used to retrieve change effective date |
| SELECT DISTINCT TRANSACTION_NAME , SS_GRP_ID , SS_TRANS_ID , EFFDT FROM PS_SS_DTL_SALCHANG |
| # | 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 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |