GPCH_PK_ST_LANG (SQL Table)	Index Back
Provider Status Lang Table Provider Status Lang Table

GPCH_PK_ST_LANG

(SQL Table)

Provider Status Lang Table

Related Language Record for GPCH_PK_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
0=Identify
1=Others
2=UVG-LAA
3=KTG-AMC
4=UVGZ-LAAC
5=FAK-CAF
6=BVG-LPP
7=AHV-AVS
8=LAW-CDS
9=BFS-OFS
A=QST-IS
B=Write File
C=Base AL08
D=GRFI-FRFI
E=EO-APG
I=BNK_BNQ

2 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code

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

4 GPCH_PK_INS_STATUS Character(8) VARCHAR2(8) NOT NULL PK Insurance Status

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPCH_SI_PROV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Provider Type 0=Identify 1=Others 2=UVG-LAA 3=KTG-AMC 4=UVGZ-LAAC 5=FAK-CAF 6=BVG-LPP 7=AHV-AVS 8=LAW-CDS 9=BFS-OFS A=QST-IS B=Write File C=Base AL08 D=GRFI-FRFI E=EO-APG I=BNK_BNQ
2	GPCH_SI_PROV_CD	Character(6)	VARCHAR2(6) NOT NULL	Provider Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GPCH_PK_INS_STATUS	Character(8)	VARCHAR2(8) NOT NULL	PK Insurance Status
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description