| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the record was updated in Pennant. Source: STVATTR_ACTIVITY_DATE |
| Crse_Prog_Attr_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | The code for the course attribute. Source: STVATTR_CODE |
| Crse_Prog_Attr_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | The description of the code found in Crse_Prog_Attr_Code. Source: STVATTR_DESC |
| Crse_Prog_Attr_Desc_Long Indexed - no
Format - Varchar2(150)
May be Null? Y | The long description of the course attribute code, from a Penn custom table:
where UP_ST_UP_S_BANNER_LONG_DESC.BANNER_TABLE(+) = 'STVATTR' and STVATTR_CODE = UP_ST_UP_S_BANNER_LONG_DESC.BANNER_CODE(+) |
| Custom_Id Indexed - no
Format - Number
May be Null? Y | The internal id of the Penn custom long description table. |
| Long_Desc_End_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The end term, i.e., term when the long description is no longer in effect, from a Penn custom table:
where UP_ST_UP_S_BANNER_LONG_DESC.BANNER_TABLE(+) = 'STVATTR' and STVATTR_CODE = UP_ST_UP_S_BANNER_LONG_DESC.BANNER_CODE(+) |
| Long_Desc_Start_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The start term, i.e., term when the long description takes effect, from a Penn custom table:
where UP_ST_UP_S_BANNER_LONG_DESC.BANNER_TABLE(+) = 'STVATTR' and STVATTR_CODE = UP_ST_UP_S_BANNER_LONG_DESC.BANNER_CODE(+) |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest refresh of this record in the warehouse. |
| V_Crse_Prog_Attr_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | primary key will be the unique combination of: A.STVATTR_CODE||nvl(B.START_TERM, 'current_term')||B.Id from saturn_stvattr A, up_st_up_s_banner_long_desc B |
