OPRIDRUN_CNTL_IDPY_GARN_LAW_FROMPY_GARN_RULE_FROMEFFDT_FROMSTATE_GARN_LAWPrompt Table: PY_STATE_NA_VW
GARN_RULE_IDDefault Value: %date
PY_RC_GCLN_TO(SQL Table) |
Index Back |
|---|---|
Clone Rules Run ControlGarnishment Rules Cloning Utility Run Control record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PY_GARN_LAW_FROM |
Character(6) | VARCHAR2(6) NOT NULL | Defines Law Source that will be used in cloning process or in referencing the rule whose formula is used in Calculation Formula page. |
| 4 | PY_GARN_RULE_FROM |
Character(10) | VARCHAR2(10) NOT NULL | Defines Garnishment Rule ID that will be used in cloning process or in referencing the rule whose formula is used in Calculation Formula page. |
| 5 | EFFDT_FROM |
Date(10) | DATE NOT NULL | Effective Date From |
| 6 | STATE_GARN_LAW |
Character(6) | VARCHAR2(6) NOT NULL |
Garnish Law Source
Prompt Table: PY_STATE_NA_VW |
| 7 | GARN_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Garnish Rule ID |
| 8 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |