GPFR_AF_VERAT_V

(SQL View)
 Index Back

Attribute Version View

Application Framework - This view is used to list down the attributes with version information

SELECT A.COUNTRY ,A.GPFR_AF_APPL ,A.GPFR_AF_KEY_NODE ,A.GPFR_AF_KEY_ATTR ,A.GPFR_AF_APPL_VER ,A.GPFR_AF_ATTR_NAME ,B.GPFR_AF_VER_DESCR ,A.DESCR60 FROM PS_GPFR_AF_ATTR A , PS_GPFR_AF_VER_VW B WHERE A.COUNTRY=B.COUNTRY AND A.GPFR_AF_APPL=B.GPFR_AF_APPL AND A.GPFR_AF_APPL_VER=B.GPFR_AF_APPL_VER UNION SELECT AA.COUNTRY ,AA.GPFR_AF_APPL ,AA.GPFR_AF_KEY_NODE ,AA.GPFR_AF_KEY_ATTR ,AA.GPFR_AF_APPL_VER ,A.GPFR_AF_ATTR_NAME ,B.GPFR_AF_VER_DESCR ,A.DESCR60 FROM PS_GPFR_AF_ATTR A , PS_GPFR_AF_ATR_LNG AA , PS_GPFR_AF_AVLNG_V B WHERE A.COUNTRY=AA.COUNTRY AND A.GPFR_AF_APPL=AA.GPFR_AF_APPL AND A.GPFR_AF_KEY_NODE=AA.GPFR_AF_KEY_NODE AND A.GPFR_AF_KEY_ATTR=AA.GPFR_AF_KEY_ATTR AND A.GPFR_AF_APPL_VER=AA.GPFR_AF_APPL_VER AND A.COUNTRY=B.COUNTRY AND A.GPFR_AF_APPL=B.GPFR_AF_APPL AND A.GPFR_AF_APPL_VER=B.GPFR_AF_APPL_VER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application
3 GPFR_AF_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node
4 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute
5 GPFR_AF_APPL_VER Number(8,0) INTEGER NOT NULL Application Framework - Application
6 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
7 GPFR_AF_VER_DESCR Character(30) VARCHAR2(30) NOT NULL Attribute Version Description
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description