GP_MDS_SBVLD_VW

(SQL View)
 Index Back

GP MDS Flags View

GP MDS Flags View

SELECT COUNTRY ,GP_CNTRY_MDS_FLAG ,GP_CNTRY_VALID_KEY FROM ( SELECT COUNTRY ,'N' AS GP_CNTRY_MDS_FLAG ,'N' AS GP_CNTRY_VALID_KEY FROM PS_COUNTRY_TBL UNION SELECT 'ALL' AS COUNTRY ,'N' AS GP_CNTRY_MDS_FLAG ,'N' AS GP_CNTRY_VALID_KEY FROM PS_INSTALLATION ) CNTRY WHERE NOT EXISTS ( SELECT 'Y' FROM PSRECDEFN WHERE RECNAME='GP_MDS_SUBSCR') UNION SELECT COUNTRY ,GP_CNTRY_MDS_FLAG ,GP_CNTRY_VALID_KEY FROM ( SELECT COUNTRY ,'N' AS GP_CNTRY_MDS_FLAG ,'N' AS GP_CNTRY_VALID_KEY FROM PS_COUNTRY_TBL UNION SELECT 'ALL' AS COUNTRY ,'N' AS GP_CNTRY_MDS_FLAG ,'N' AS GP_CNTRY_VALID_KEY FROM PS_INSTALLATION ) CNTRY WHERE EXISTS ( SELECT 'Y' FROM PSRECDEFN WHERE RECNAME='GP_MDS_SUBSCR') AND EXISTS ( SELECT GP_CST_INSTALL_IND FROM PS_INSTALLATION LEFT JOIN PS_PTIASPSRCINFO ON 1=1 WHERE %Coalesce(PTIASPIMAGETYPE,GP_CST_INSTALL_IND) IN ('I','N')) UNION SELECT A.COUNTRY ,A.GP_CNTRY_MDS_FLAG ,%Coalesce(B.GP_CNTRY_VALID_KEY,'N') FROM PS_GP_MDS_SUBS_MST A LEFT JOIN PS_GP_MDS_SUBS_KEY B ON A.COUNTRY=B.COUNTRY WHERE EXISTS ( SELECT 'Y' FROM PSRECDEFN WHERE RECNAME='GP_MDS_SUBSCR') AND EXISTS ( SELECT GP_CST_INSTALL_IND FROM PS_INSTALLATION LEFT JOIN PS_PTIASPSRCINFO ON 1=1 WHERE %Coalesce(PTIASPIMAGETYPE,GP_CST_INSTALL_IND) NOT IN ('I','N'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY_VW

2 GP_CNTRY_MDS_FLAG Character(1) VARCHAR2(1) NOT NULL GP Country MDS Flag
N=MDS Disabled
Y=MDS Enabled
3 GP_CNTRY_VALID_KEY Character(1) VARCHAR2(1) NOT NULL Key Valid/Invalid Flag

Y/N Table Edit

Default Value: N