INSTITUTIONCALENDAR_YEARPROCESS_INSTANCEA=Amendment
O=Original
T2202_XML_VW(SQL View) |
Index Back |
|---|---|
T2202 XML Process ViewView used to return process information of prior runs of T2202 XML Creation. It is used as a prompt on the T2202 XML Run Control to identify the specific process instance to reset the transmittal fields on the T2202_HDR record, which is performed by SFXT2202.SQR. |
| SELECT DISTINCT A.INSTITUTION , A.CALENDAR_YEAR , A.PROCESS_INSTANCE , B.OPRID , B.RUNCNTLID , CASE WHEN A.SSF_CRA_SLIP_TYPE = 'O' THEN 'O' ELSE 'A' END , A.SF_TAX_TRANS_DTTM FROM PS_T2202_HDR_VW A , PSPRCSRQST B WHERE A.PROCESS_INSTANCE = B.PRCSINSTANCE AND A.PROCESS_INSTANCE <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 3 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 6 | SSF_CRA_RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
CRA - T2202 - Report Type Code A=Amendment O=Original |
| 7 | SF_TAX_TRANS_DTTM | DateTime(26) | TIMESTAMP | 1098-T Transmittal Date/Timestamp |