GPBR_INC_ACTIONEFFDTDefault Value: %date
GPBR_INC_ACTN_RSNGPBR_ACT_RSN_VW(SQL View) |
Index Back |
|---|---|
Action/Reason CombinationsAction/Reason Combinations |
| SELECT A.ACTION ,A.EFFDT ,A.ACTION_REASON ,C.DESCR FROM PS_ACTN_REASON_BRA A ,PS_GPBR_INC_ACT_VW B ,PS_ACTN_REASON_TBL C WHERE A.ACTION=B.GPBR_INC_ACTION AND A.ACTION=C.ACTION AND A.ACTION_REASON=C.ACTION_REASON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_INC_ACTION |
Character(3) | VARCHAR2(3) NOT NULL | Increase Action |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPBR_INC_ACTN_RSN |
Character(3) | VARCHAR2(3) NOT NULL | Increase Action Reason |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |