GPDE_SI_PID_VW(SQL View) |
Index Back |
---|---|
SI Provider IDsThis view is the search for the SI Provider Rates component GPDE_SI_PROV_RT. It selects the Provider Ids (GPDE_SI_PROV_ID) for all providers that can have either health insurance or refund insurance rates. |
SELECT GPDE_SI_PROV_ID , EFFDT , %Substring(DESCR50,1,30) FROM PS_GPDE_SI_PROV_ID WHERE GPDE_SI_ORG_TYPE = '01' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Provider ID | |
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |