GP_VAR_CAT_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 , B.PIN_NM , A.PIN_NUM , A.EFFDT , A.EFF_STATUS , B.FLD_FMT , A.CHARACTER_VALUE , A.DECIMAL_VALUE , A.VARIABLE_DATE , A.MONETARY_VALUE , A.CURRENCY_CD , A.EFFDT 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
4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
6 EFFDT Date(10) DATE Effective Date

Default Value: %date

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
1=Character
2=Date
3=Monetary
4=Decimal
5=Element Pointer
6=Not Applicable
9 CHARACTER_VALUE Character(20) VARCHAR2(20) NOT NULL character value
10 DECIMAL_VALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Value Decimal
11 VARIABLE_DATE Date(10) DATE Variable Date
12 MONETARY_VALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Monetary Value
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

14 EFFDT_OLD Date(10) DATE Old Effective Date