GPIN_F16RPT_KEYEMPLIDESTABIDGPIN_ASSMNT_YRGPIN_F16_RPT(SQL Table) |
Index Back |
|---|---|
Form 16 Report TblUsed to hold the Form 16/12BA report data for each employee,Estabid & Assessment Year combination in XML string format. The XML String in this table is used as Data Source by Form16 BI Publisher to showup Form 16/12BA report for employees on their login. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPIN_F16RPT_KEY |
Number(20,0) | DECIMAL(20) NOT NULL | Report Key |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 4 | GPIN_ASSMNT_YR |
Character(15) | VARCHAR2(15) NOT NULL | Assessment Year |
| 5 | GPIN_DS_DIGID | Character(30) | VARCHAR2(30) NOT NULL | Digital Signature ID |
| 6 | GPIN_TDS_INWORD | Character(250) | VARCHAR2(250) NOT NULL | TDS inword |
| 7 | GPIN_REPORT_ID | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier |
| 8 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 9 | HCSC_SS_RPT_DT | Date(10) | DATE | Self Service Report Last Seen Date |
| 10 | HCSC_ALERT_DT | Date(10) | DATE | Push Notification Alert Sent Date |
| 11 | HCSC_REPORT_DT | Date(10) | DATE | Self Service Report Availability Date |
| 12 | RAWXML | Long Character | CLOB | Raw XML |
| 13 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL | URL Identifier (see PSURLDEFN). |
| 14 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |