GPUS_NRP_GRL_AD(SQL Table) |
Index Back |
---|---|
GPUS_GARNISHGPUS_GARNISH |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PKG_ID | Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
2 | GPUS_GRN_ID | Character(16) | VARCHAR2(16) NOT NULL | GPUS_GARNID |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | GPUS_RLAWSRC | Character(6) | VARCHAR2(6) NOT NULL | GPUS_LAWSRC |
5 | GPUS_PIN_PROFM_NUM | Number(8,0) | INTEGER NOT NULL | Proration Formula PIN Number |
6 | GPUS_PIN_LMCAL_NUM | Number(8,0) | INTEGER NOT NULL | Limit Calculation Formula PIN Number |
7 | GPUS_PIN_LMCF_NUM | Number(8,0) | INTEGER NOT NULL | Company Fee Limit Formula PIN Number |
8 | GPUS_PIN_LMPF_NUM | Number(8,0) | INTEGER NOT NULL | Recipient Fee Limit Formula PIN Number |
9 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
10 | GPUS_AGENCYNM | Character(60) | VARCHAR2(60) NOT NULL | Agency Name |
11 | GPUS_ATTRNYNM | Character(50) | VARCHAR2(50) NOT NULL | Attroney Name |
12 | GPUS_REMARKS | Long Character | CLOB | GPUS_REMARKS |