INSTITUTIONPrompt Table: INSTITUTION_TBL
EMPLIDSERVICE_IMPACTSRVC_IND_CDDefault Value: %date
SSF_EMPSRVC_VW(SQL View) |
Index Back |
|---|---|
SF BU Student Srvc IndicatorsStudent Financials view joining the SRVC_IND_DATA, SERVICE_IMPACT. |
| SELECT a.institution ,a.emplid ,b.service_impact ,a.srvc_ind_cd ,a.srvc_ind_act_term ,a.srvc_ind_active_dt ,a.scc_si_end_dt ,a.scc_si_end_term ,a.pos_srvc_indicator ,b.effdt FROM PS_SRVC_IND_DATA a , ps_service_impact b WHERE a.institution=b.institution AND a.srvc_ind_cd=b.srvc_ind_cd AND b.effdt=( SELECT MAX(b1.effdt) FROM ps_service_impact b1 WHERE b1.institution=b.institution AND b1.srvc_ind_cd=b.srvc_ind_cd AND b1.effdt<=%CurrentDateIn AND b1.service_impact = b.service_impact AND b1.term_category = b.term_category) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SERVICE_IMPACT |
Character(5) | VARCHAR2(5) NOT NULL | Service Impact |
| 4 | SRVC_IND_CD |
Character(3) | VARCHAR2(3) NOT NULL | Service Indicator Cd |
| 5 | SRVC_IND_ACT_TERM | Character(4) | VARCHAR2(4) NOT NULL | Service Indicator Start Term |
| 6 | SRVC_IND_ACTIVE_DT | Date(10) | DATE | Service Indicator Start Date |
| 7 | SCC_SI_END_DT | Date(10) | DATE | Service Indicator End Date |
| 8 | SCC_SI_END_TERM | Character(4) | VARCHAR2(4) NOT NULL | Service Indicator End Term |
| 9 | POS_SRVC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Positive Service Indicator |
| 10 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |