GPCH_BL_PRNT_VW

(SQL View)
 Index Back

Print Balance Options

Print Balance Options

SELECT A.GPCH_RC_REPORTNAME , A.GPCH_BL_PR_GROUP , A.GPCH_BL_PR_ORDER , A.PIN_NUM , B.PIN_NM , A.EFF_STATUS , A.ENTRY_TYPE_ELEM , A.GPCH_AL_OVERRIDE , A.GPCH_AL_SIGNVALUE , A.GPCH_BL_PR_CALC ,A.GPCH_BL_PR_BASE ,A.GPCH_BL_PR_RATE ,A.GPCH_BL_PR_UNITS ,A.GPCH_BL_PR_PERCENT , A.GPCH_BL_PR_SUM FROM PS_GPCH_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 GPCH_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print Class

Prompt Table: GPCH_BL_PR_RPT

2 GPCH_BL_PR_GROUP Number(2,0) SMALLINT NOT NULL Print Group
3 GPCH_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: GP_ENT_NUMER_VW

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

Y/N Table Edit

Default Value: N

9 GPCH_AL_SIGNVALUE Signed Number(2,0) DECIMAL(1) NOT NULL Element Sign
10 GPCH_BL_PR_CALC Character(1) VARCHAR2(1) NOT NULL To Print Calc_Rslt_Val if this field is checked.

Y/N Table Edit

11 GPCH_BL_PR_BASE Character(1) VARCHAR2(1) NOT NULL Print Base

Y/N Table Edit

12 GPCH_BL_PR_RATE Character(1) VARCHAR2(1) NOT NULL To Print Rate_Rslt_Val when this field is checked.

Y/N Table Edit

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

Y/N Table Edit

14 GPCH_BL_PR_PERCENT Character(1) VARCHAR2(1) NOT NULL Print Percent

Y/N Table Edit

15 GPCH_BL_PR_SUM Character(1) VARCHAR2(1) NOT NULL Print Sum Amount

Y/N Table Edit