EG_DFN_SCAT_CAT(SQL Table) |
Index Back |
|---|---|
ServiceThis is a setup table containing Service parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 2 | CATEGORY |
Character(10) | VARCHAR2(10) NOT NULL | Category Name |
| 3 | SVC_ADJ_ACTION1 |
Character(3) | VARCHAR2(3) NOT NULL |
Service Adjustment Action Cd
Prompt Table: ACTION_TBL |
| 4 | SVC_ADJ_ACT_RSN1 |
Character(3) | VARCHAR2(3) NOT NULL |
Svc Adj Action Reason
Prompt Table: EG_ACT_RSN1 |
| 5 | SVC_ADJ_ACTION2 |
Character(3) | VARCHAR2(3) NOT NULL |
Service Adjustment Action 2
Prompt Table: ACTION_TBL |
| 6 | SVC_ADJ_ACT_RSN2 |
Character(3) | VARCHAR2(3) NOT NULL |
Svc Adj Action Reason 2
Prompt Table: EG_ACT_RSN2 |
| 7 | SVC_ADJ_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Service Adjustment Type
A=Add To Current Action/Reason C=Ignore Current Action/Reason F=Ignore Future Action/Reason I=Insert |
| 8 | SVC_ADJ_ADD_NUM | Number(3,0) | SMALLINT NOT NULL | Service Adjustment Add Number |
| 9 | SVC_ADJ_ADD_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Service Adjustment Add Type
D=Days M=Months U=User Code W=Weeks Y=Years |
| 10 | SVC_ADJ_WITHIN_NUM | Number(3,0) | SMALLINT NOT NULL | Occurs Within |
| 11 | SVC_ADJ_WITHIN_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Unit of Measure
D=Days M=Months U=User Code W=Weeks Y=Years |
| 12 | PNL_DOES_NOT | Character(8) | VARCHAR2(8) NOT NULL | |
| 13 | PNL_OCCURS_WITHIN | Character(14) | VARCHAR2(14) NOT NULL | |
| 14 | PNL_WHAT_NEXT | Character(40) | VARCHAR2(40) NOT NULL | Reaction |
| 15 | PNL_INS_IGNR_FUT | Character(15) | VARCHAR2(15) NOT NULL | |
| 16 | PNL_SLASH3 | Character(1) | VARCHAR2(1) NOT NULL | |
| 17 | PNL_SLASH4 | Character(1) | VARCHAR2(1) NOT NULL |