GP_VAR_CAT0_VW

(SQL View)
 Index Back

Variable by category values

List of the variables and their values (current and future). Used in the variable by category panel

SELECT B.USED_BY , B.COUNTRY , B.PIN_CATEGORY FROM PS_GP_VARIABLE A , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM AND (A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GP_VARIABLE C WHERE A.PIN_NUM = C.PIN_NUM AND C.EFFDT <= %CurrentDateIn) OR A.EFFDT >= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
A=All Countries
C=Specific Country
2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
3 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category