RUN_CNTL_NSLC(SQL Table) |
Index Back |
|---|---|
SR Run Cntl NSLCThis table will be used to generate an SQR Process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
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 | ACAD_STATS_PERIOD | Character(10) | VARCHAR2(10) NOT NULL |
Academic Statistics Period
Prompt Table: STAT_PERIOD_TBL |
| 5 | NSLC_BRANCH_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Branch Code
Default Value: 00 Prompt Table: NSLC_BRANCH_TBL |
| 6 | NSLC_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Report Type
G=Graduates Only N=Non-Standard Report Y=Standard Report Default Value: Y |
| 7 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
| 8 | FICE_CD | Character(6) | VARCHAR2(6) NOT NULL |
FICE Code
Default Value: INSTITUTION_TBL.FICE_CD |
| 9 | NSLC_OUTPUT_FILE | Character(100) | VARCHAR2(100) NOT NULL | NSC Output File |
| 10 | GRADUATE_LVL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Graduate Level
Y/N Table Edit Default Value: N |
| 11 | SSN_EXCLUSION1 | Character(3) | VARCHAR2(3) NOT NULL | SSN Exclusion 1 |
| 12 | SSN_EXCLUSION2 | Character(3) | VARCHAR2(3) NOT NULL | SSN Exclusion 2 |
| 13 | SSN_EXCLUSION3 | Character(3) | VARCHAR2(3) NOT NULL | SSN Exclusion 3 |
| 14 | SSN_EXCLUSION4 | Character(3) | VARCHAR2(3) NOT NULL | SSN Exclusion 4 |
| 15 | SSN_EXCLUSION5 | Character(3) | VARCHAR2(3) NOT NULL | SSN Exclusion 5 |