INSTITUTIONPrompt Table: INSTITUTION_TBL
EXT_ORG_IDSERVICE_IMPACTSRVC_IND_CDDefault Value: %date
SSF_ORGSRVC_VW(SQL View) |
Index Back |
|---|---|
SF BU Corp Service IndicatorsStudent Financials view joining the SCC_SI_ORG and SERVICE_IMPACT tables. |
| SELECT A.INSTITUTION ,A.EXT_ORG_ID ,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_SCC_SI_ORG 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 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL | External Org 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 |