GPIT_BL_PRNT_VW

(SQL View)
 Index Back

Print Balance Options

Print Balance Options

SELECT A.GPIT_RC_REPORTNAME , A.GPIT_BL_PR_GROUP , A.GPIT_BL_PR_ORDER , A.PIN_NUM , B.PIN_NM , A.EFF_STATUS , A.ENTRY_TYPE_ELEM , A.GPIT_AL_OVERRIDE , A.GPIT_AL_SIGNVALUE ,A.GPIT_BL_PR_BASE ,A.GPIT_BL_PR_AMT , A.GPIT_BL_PR_PERCENT , A.GPIT_BL_PR_UNITS , A.GPIT_BL_PR_HOURS , A.GPIT_BL_PR_FACTOR , A.GPIT_BL_PR_SUM , A.GPIT_BL_PR_TOTAL , A.GPIT_BL_PR_FIX_VAL FROM PS_GPIT_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 GPIT_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print class

Prompt Table: GPIT_BL_PR_RPT

2 GPIT_BL_PR_GROUP Number(2,0) SMALLINT NOT NULL Print Group
3 GPIT_BL_PR_ORDER Number(6,0) INTEGER NOT NULL Order
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: GP_ENT_NUMER_VW

8 GPIT_AL_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override

Y/N Table Edit

Default Value: N

9 GPIT_AL_SIGNVALUE Signed Number(2,0) DECIMAL(1) NOT NULL Value of Sign
10 GPIT_BL_PR_BASE Character(1) VARCHAR2(1) NOT NULL Base

Y/N Table Edit

11 GPIT_BL_PR_AMT Character(1) VARCHAR2(1) NOT NULL Amount

Y/N Table Edit

Default Value: Y

12 GPIT_BL_PR_PERCENT Character(1) VARCHAR2(1) NOT NULL Percent

Y/N Table Edit

13 GPIT_BL_PR_UNITS Character(1) VARCHAR2(1) NOT NULL Units

Y/N Table Edit

14 GPIT_BL_PR_HOURS Character(1) VARCHAR2(1) NOT NULL Hours

Y/N Table Edit

15 GPIT_BL_PR_FACTOR Character(1) VARCHAR2(1) NOT NULL Factor

Y/N Table Edit

16 GPIT_BL_PR_SUM Character(1) VARCHAR2(1) NOT NULL Sum

Y/N Table Edit

17 GPIT_BL_PR_TOTAL Character(1) VARCHAR2(1) NOT NULL Total

Y/N Table Edit

18 GPIT_BL_PR_FIX_VAL Character(1) VARCHAR2(1) NOT NULL Fix Value

Y/N Table Edit

Default Value: N