SSR_HE_HIN_RC(SQL Table) |
Index Back |
---|---|
Import HIN Target List Run Ctl |
# | 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 | SSR_HE_PRD_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Reporting Period
Prompt Table: SSR_HE_REPRD_VW |
5 | SSR_HE_FILE_PATH | Character(100) | VARCHAR2(100) NOT NULL | XSD File Path |
6 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
7 | SSR_HE_INCR_YRPRG | Character(1) | VARCHAR2(1) NOT NULL |
Increment Year of Program
Y/N Table Edit Default Value: N |
8 | SSR_HE_INS_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy Instance Details Indicator
Y/N Table Edit Default Value: Y |
9 | SSR_HE_QUALAWD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy Qualifications Awarded Indicator
Y/N Table Edit Default Value: Y |
10 | SSR_HE_RSCH_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy research data flag
Y/N Table Edit Default Value: Y |
11 | SSR_HE_FTE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy FTE Details Indicator
Y/N Table Edit Default Value: Y |
12 | SSR_HE_FIN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy Financial Support Details Indicator
Y/N Table Edit Default Value: Y |
13 | SSR_HE_MOB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Copy Mobility Details Indicator
Y/N Table Edit Default Value: Y |
14 | SSR_HE_ITT_PLC | Character(1) | VARCHAR2(1) NOT NULL |
ITT Placement check box
Y/N Table Edit Default Value: Y |