GPUS_RULEIDEFFDTDefault Value: %date
10=Weekly
20=Biweekly
30=Semi-Monthly
40=Monthly
GPUS_RULCAL_VW(SQL View) |
Index Back |
|---|---|
Rule Calculation ViewRule Calculation View |
| SELECT A.GPUS_RULEID , A.EFFDT , A.GPUS_PIN_DEID_NUM , B.GPUS_PIN_EXCAL_NUM , B.GPUS_FREQ FROM PS_GPUS_GRN_RUL A , PS_GPUS_GRN_RULCAL B WHERE A.GPUS_RULEID = B.GPUS_RULEID AND A.EFFDT = B.EFFDT AND A.GPUS_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPUS_RULEID |
Character(30) | VARCHAR2(30) NOT NULL | GPUS_RULEID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | GPUS_PIN_DEID_NUM | Number(8,0) | INTEGER NOT NULL | Disposable Earning AC PIN Number |
| 4 | GPUS_PIN_EXCAL_NUM | Number(8,0) | INTEGER NOT NULL | Exemption Calculation Formula PIN Number |
| 5 | GPUS_FREQ | Character(2) | VARCHAR2(2) NOT NULL |
GPUS_FREQ
10=Weekly 20=Biweekly 30=Semi-Monthly 40=Monthly |