SSF_IHC_PROVIDERSSF_IHC_RPT_NBRSSF_IHC_RPTNBVW(SQL View) |
Index Back |
|---|---|
Report Number ViewInternational Student Health Coverage prompt table view. Used a prompt table for record.field SSF_IHC_RUNCTL.SSF_IHC_RPT_NBR on page SSF_IHC_RUNCTL. |
| SELECT DISTINCT SSF_IHC_PROVIDER ,A.SSF_IHC_RPT_NBR , A.SSF_IHC_RUN_DATE FROM PS_SSF_IHC_STDNT A WHERE A.SSF_IHC_RPT_NBR <> ' ' |
| # | 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_RPT_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Report Number |
| 3 | SSF_IHC_RUN_DATE | Date(10) | DATE | Run Date |