BUSINESS_UNITEMPLIDPrompt Table: HCR_PERSON_I
SSF_IHC_COVER_NBRINSTITUTIONSCC_PS_IHC_BND(SQL View) |
Index Back |
|---|---|
PopSel Bind record for IHCPopSel Bind record for IHC admin function used by 3C Engine |
| SELECT B.BUSINESS_UNIT ,A.EMPLID ,A.SSF_IHC_COVER_NBR ,C.INSTITUTION ,D.NAME FROM PS_SSF_IHC_STDNT A ,PS_SSF_IHC_STDPAR B ,PS_BUS_UNIT_TBL_SF C , PS_SCC_PRI_NAME_VW D WHERE A.EMPLID = B.EMPLID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SSF_IHC_COVER_NBR = B.SSF_IHC_COVER_NBR AND A.EFF_STATUS = 'A' AND A.EFFDT <=%CurrentDateIn AND A.EFFSEQ = ( SELECT MAX (S2.EFFSEQ) FROM PS_SSF_IHC_STDNT S2 WHERE S2.EMPLID = A.EMPLID AND S2.SSF_IHC_COVER_NBR = A.SSF_IHC_COVER_NBR AND S2.EFFDT = A.EFFDT) AND B.EMPLID = D.EMPLID AND D.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SCC_PRI_NAME_VW X WHERE X.EMPLID = D.EMPLID AND X.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: HCR_PERSON_I |
| 3 | SSF_IHC_COVER_NBR |
Number(3,0) | SMALLINT NOT NULL | Coverage Number |
| 4 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |