GPFR_AF_ATTRV_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 ,B.GPFR_AF_NODE_SET ,A.GPFR_AF_KEY_NODE ,A.GPFR_AF_KEY_ATTR ,A.GPFR_AF_APPL_VER ,A.GPFR_AF_ATTR_NAME ,A.DESCR60 FROM PS_GPFR_AF_ATTR A LEFT OUTER JOIN PS_GPFR_AF_NDSET_A B ON A.COUNTRY =B.COUNTRY AND A.GPFR_AF_APPL=B.GPFR_AF_APPL AND A.GPFR_AF_KEY_NODE=B.GPFR_AF_KEY_NODE AND A.GPFR_AF_KEY_ATTR=B.GPFR_AF_KEY_ATTR UNION SELECT AA.COUNTRY ,AA.GPFR_AF_APPL ,C.GPFR_AF_NODE_SET ,AA.GPFR_AF_KEY_NODE ,AA.GPFR_AF_KEY_ATTR ,AA.GPFR_AF_APPL_VER ,A.GPFR_AF_ATTR_NAME ,A.DESCR60 FROM PS_GPFR_AF_ATTR A LEFT OUTER JOIN PS_GPFR_AF_NDSET_A C ON C.COUNTRY =A.COUNTRY AND C.GPFR_AF_APPL = A.GPFR_AF_APPL AND C.GPFR_AF_KEY_NODE = A.GPFR_AF_KEY_NODE AND C.GPFR_AF_KEY_ATTR=A.GPFR_AF_KEY_ATTR , PS_GPFR_AF_ATR_LNG AA 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

# 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_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set
4 GPFR_AF_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node
5 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute
6 GPFR_AF_APPL_VER Number(8,0) INTEGER NOT NULL Application Framework - Application
7 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description