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 |