GPCH_UV_COV_VW

(SQL View)
 Index Back

View for GPCH_UV_DATA

View for GPCH_UV_DATA

SELECT DISTINCT GPCH_SI_PROV_TYPE , GPCH_SI_PROV_CD , EFFDT , GPCH_SI_COV_UV FROM PS_GPCH_SI_UV_PCT

# 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_TX_UV_PROV_CD Character(6) VARCHAR2(6) NOT NULL Accident Insurance Provider
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 GPCH_SI_COV_UV Character(1) VARCHAR2(1) NOT NULL Risk Group
A=Risk Group A
B=Risk Group B
C=Risk Group C
D=Risk Group D
E=Risk Group E
F=Risk Group F
G=Risk Group G
H=Risk Group H
I=Risk Group I
J=Risk Group J
K=Risk Group K
L=Risk Group L
M=Risk Group M
N=Risk Group N
O=Risk Group O
P=Risk Group P
Q=Risk Group Q
R=Risk Group R
S=Risk Group S
T=Risk Group T
U=Risk Group U
V=Risk Group V
W=Risk Group W
X=Risk Group X
Y=Risk Group Y
Z=Risk Group Z