SSF_RUN_T2202(SQL Table) |
Index Back |
|---|---|
T2202 Run ControlRun Control for T2202 processing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
|
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | CALENDAR_YEAR | Number(4,0) | SMALLINT NOT NULL |
Calendar Year
Prompt Table: SSF_T2202_SETUP |
| 5 | SSF_T2202_XML_OPT | Character(1) | VARCHAR2(1) NOT NULL |
XML Run Option used by Manage T2202 XML run control.
C=Create XML File R=Reset XML Sent fields Default Value: C |
| 6 | SSF_CRA_RPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
CRA - T2202 - Report Type Code A=Amendment O=Original Default Value: O |
| 7 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
| 8 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: T2202_XML_VW |