SSR_HE_PR_FL_VW(SQL View) |
Index Back |
|---|---|
Provision Return extract field |
| SELECT a.institution , a.ssr_he_ret_name , a.ssr_he_courseid , a.ssr_he_field , a.ssr_he_active , a.ssr_he_rep_val , c1.ssr_he_rep_ord FROM ps_ssr_he_pr_ex_fl a , ps_ssr_he_inst_her b , PS_SSR_HE_ENT_FLDS c1 WHERE c1.ssr_he_entity = 'PROVISION' AND b.ssr_he_ret_type = c1.ssr_he_ret_type AND c1.ssr_he_field = a.ssr_he_field AND a.ssr_he_ret_name = b.ssr_he_ret_name AND a.institution = b.institution AND %EffdtCheck(SSR_HE_ENT_FLDS c2, c1, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_HE_RET_NAME | Character(30) | VARCHAR2(30) NOT NULL | Return Name |
| 3 | SSR_HE_COURSEID | Character(10) | VARCHAR2(10) NOT NULL | Course ID |
| 4 | SSR_HE_FIELD | Character(20) | VARCHAR2(20) NOT NULL | Field |
| 5 | SSR_HE_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 6 | SSR_HE_REP_VAL | Character(254) | VARCHAR2(254) NOT NULL | Reported Value |
| 7 | SSR_HE_REP_ORD | Number(3,0) | SMALLINT NOT NULL | Report Order |