GVT_CATG_RPT(SQL Table) |
Index Back |
|---|---|
Temporary EE's Buying FEHBThis is a temporary table used by FGPY019.SQR during processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CATEGORY | Character(10) | VARCHAR2(10) NOT NULL | Category Name |
| 3 | GVT_ENROLL_CODE | Character(4) | VARCHAR2(4) NOT NULL | Enrollment Code |
| 4 | GVT_COVRG_AMT1 | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Coverage Code amt1 |
| 5 | GVT_COVRG_CNT1 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Coverage Cnt1 |
| 6 | GVT_COVRG_AMT2 | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Coverage Code amt2 |
| 7 | GVT_COVRG_CNT2 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Coverage Cnt2 |
| 8 | GVT_COVRG_AMT3 | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Coverage Code amt3 |
| 9 | GVT_COVRG_CNT3 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Coverage Cnt3 |
| 10 | GVT_COVRG_CNT4 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Coverage Cnt4 |
| 11 | GVT_COVRG_AMT4 | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Coverage Code amt4 |
| 12 | GVT_COVRG_CNT5 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Coverage Cnt4 |
| 13 | GVT_COVRG_AMT5 | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Coverage Code amt5 |