GPDE_BL_PRNT_VW

(SQL View)
Index Back

Balance Print View

Balance Print View

SELECT A.GPDE_RC_REPORTNAME , A.GPDE_BL_PR_GROUP , A.GPDE_BL_PR_ORDER , A.PIN_NUM , B.PIN_NM , A.EFF_STATUS , A.ENTRY_TYPE_ELEM , A.GPDE_AL_OVERRIDE , A.GPDE_AL_SIGNVALUE ,A.GPDE_BL_PR_BASE ,A.GPDE_BL_PR_AMT , A.GPDE_BL_PR_PERCENT , A.GPDE_BL_PR_UNITS , A.GPDE_BL_PR_HOURS , A.GPDE_BL_PR_FACTOR , A.GPDE_BL_PR_SUM , A.GPDE_BL_PR_TOTAL , A.GPDE_BL_PR_FIX_VAL FROM PS_GPDE_BL_PRINT A , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPDE_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print Class

Prompt Table: GPDE_BL_PR_RPT

2 GPDE_BL_PR_GROUP Number(2,0) SMALLINT NOT NULL Print Group
3 GPDE_BL_PR_ORDER Number(6,0) INTEGER NOT NULL Print Sequence
4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GPDE_BL_PRCL_VW

8 GPDE_AL_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Indicator

Y/N Table Edit

Default Value: N

9 GPDE_AL_SIGNVALUE Signed Number(2,0) DECIMAL(1) NOT NULL Element Sign
10 GPDE_BL_PR_BASE Character(1) VARCHAR2(1) NOT NULL Print Base

Y/N Table Edit

Default Value: N

11 GPDE_BL_PR_AMT Character(1) VARCHAR2(1) NOT NULL Print Amount

Y/N Table Edit

Default Value: Y

12 GPDE_BL_PR_PERCENT Character(1) VARCHAR2(1) NOT NULL Print Percent

Y/N Table Edit

Default Value: N

13 GPDE_BL_PR_UNITS Character(1) VARCHAR2(1) NOT NULL Print Units

Y/N Table Edit

Default Value: N

14 GPDE_BL_PR_HOURS Character(1) VARCHAR2(1) NOT NULL Print Hours

Y/N Table Edit

Default Value: N

15 GPDE_BL_PR_FACTOR Character(1) VARCHAR2(1) NOT NULL Print Factor

Y/N Table Edit

Default Value: N

16 GPDE_BL_PR_SUM Character(1) VARCHAR2(1) NOT NULL Print Sum Amount

Y/N Table Edit

Default Value: N

17 GPDE_BL_PR_TOTAL Character(1) VARCHAR2(1) NOT NULL Print Total

Y/N Table Edit

Default Value: N

18 GPDE_BL_PR_FIX_VAL Character(1) VARCHAR2(1) NOT NULL Static PIN Indicator

Y/N Table Edit

Default Value: N