SSR_RC_NQF_RPTS(SQL Table) |
Index Back |
|---|---|
NQF Reports Run Control RecordUsed for running NQF reports |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
| 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: BUS_UNIT_SF_VW |
| 5 | SSR_NQF_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
NQF Process
1=NQF Hook On Request 2=NQF Unit Standards Results 3=NZ Diploma in Business Process Default Value: 1 |
| 6 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: SF_TERM_VW |
| 7 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: SP_ITEMCH_NONVW |
| 8 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
| 9 | FILE_PATH1 | Character(127) | VARCHAR2(127) NOT NULL | File Path and Name |
| 10 | FILE_PATH2 | Character(127) | VARCHAR2(127) NOT NULL | File Path and Name |
| 11 | FILE_PATH3 | Character(127) | VARCHAR2(127) NOT NULL | File Path and Name |
| 12 | FEE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Fee Code
Prompt Table: TERM_FE_CD_TBL |