GPUS_LAWSRCPrompt Table: GPUS_STATE_VW
GPUS_GRN_TYPE_NUMEFFDTPrompt Table: GPUS_GRNPRFM_VW
GPUS_GRN_PF_VW(SQL View) |
Index Back |
|---|---|
Proration Rule ViewView of GPUS_PRORUL with garnishment type as a numeric |
| SELECT GPUS_LAWSRC , TO_NUMBER(NVL(RTRIM(SUBSTR(GPUS_GRN_TYPE ,1 ,4)) ,'0')) , EFFDT , GPUS_PIN_PROFM_NUM FROM PS_GPUS_GRN_PRORUL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPUS_LAWSRC |
Character(6) | VARCHAR2(6) NOT NULL |
GPUS_LAWSRC
Prompt Table: GPUS_STATE_VW |
| 2 | GPUS_GRN_TYPE_NUM |
Number(4,0) | SMALLINT NOT NULL | Garnishment Type in numeric format |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | GPUS_PIN_PROFM_NUM | Number(8,0) | INTEGER NOT NULL |
Proration Formula PIN Number
Prompt Table: GPUS_GRNPRFM_VW |