SSF_IHC_PROVIDERSSF_IHC_RUN_DATESSF_IHC_RPTDTVW(SQL View) |
Index Back |
|---|---|
Report Number ViewInsternational Student Health Coverage prompt view. Used a prompt table for record.field SSF_IHC_RUNCTL.SSF_IHC_RPT_NBR or page SSF_IHC_RUNCTL. |
| SELECT DISTINCT SSF_IHC_PROVIDER ,A.SSF_IHC_RUN_DATE ,A.SSF_IHC_RPT_NBR FROM PS_SSF_IHC_STDNT A WHERE A.SSF_IHC_RUN_DATE IS NOT NULL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSF_IHC_PROVIDER |
Character(8) | VARCHAR2(8) NOT NULL | Provider ID |
| 2 | SSF_IHC_RUN_DATE |
Date(10) | DATE | Run Date |
| 3 | SSF_IHC_RPT_NBR | Character(12) | VARCHAR2(12) NOT NULL | Report Number |