GPDE_SI_PID_VW (SQL View)	Index Back
SI Provider IDs This 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.

GPDE_SI_PID_VW

(SQL View)

SI Provider IDs

This 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'

Related Language Record: GPDE_SI_PID_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_SI_PROV_ID Character(8) VARCHAR2(8) NOT NULL Provider ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_SI_PROV_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description