GPIT_BLPRT_NRVW

(SQL View)
 Index Back

Print Class Record

Print Class Record VIEW for the element relationship map

SELECT GPIT_RC_REPORTNAME , PIN_NUM + 50000000 , EFF_STATUS , ENTRY_TYPE_ELEM , GPIT_AL_OVERRIDE , GPIT_AL_SIGNVALUE , GPIT_BL_PR_ORDER , GPIT_BL_PR_GROUP , GPIT_BL_PR_BASE , GPIT_BL_PR_AMT , GPIT_BL_PR_PERCENT , GPIT_BL_PR_UNITS , GPIT_BL_PR_HOURS , GPIT_BL_PR_FACTOR , GPIT_BL_PR_SUM , GPIT_BL_PR_TOTAL , GPIT_BL_PR_FIX_VAL , GPIT_BL_PR_BOXNO , GPIT_BL_PR_CHK_BOX , GPIT_BL_PR_PRT_FLG , GPIT_BL_PT_COND_EX , GPIT_BL_PR_DESCR , GPIT_CUDNOTE_ID , GPIT_ASSOGGET FROM PS_GPIT_BL_PRINT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPIT_RC_REPORTNAME Character(8) VARCHAR2(8) NOT NULL Print class
2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

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

Prompt Table: GPIT_ENT_PRC_VW

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

Y/N Table Edit

Default Value: N

6 GPIT_AL_SIGNVALUE Signed Number(2,0) DECIMAL(1) NOT NULL Value of Sign
7 GPIT_BL_PR_ORDER Number(6,0) INTEGER NOT NULL Order
8 GPIT_BL_PR_GROUP Number(2,0) SMALLINT NOT NULL Print Group
9 GPIT_BL_PR_BASE Character(1) VARCHAR2(1) NOT NULL Base

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

18 GPIT_BL_PR_BOXNO Number(3,0) SMALLINT NOT NULL Box NO
19 GPIT_BL_PR_CHK_BOX Character(1) VARCHAR2(1) NOT NULL Check Box

Y/N Table Edit

20 GPIT_BL_PR_PRT_FLG Character(1) VARCHAR2(1) NOT NULL PRINT FLAG

Y/N Table Edit

21 GPIT_BL_PT_COND_EX Character(1) VARCHAR2(1) NOT NULL Cond Ex

Y/N Table Edit

22 GPIT_BL_PR_DESCR Character(20) VARCHAR2(20) NOT NULL Description
23 GPIT_CUDNOTE_ID Character(4) VARCHAR2(4) NOT NULL CUD Note ID

Prompt Table: GPIT_CUD_NOTE

24 GPIT_ASSOGGET Character(1) VARCHAR2(1) NOT NULL Subjection type
1=1 - INPS
2=2 - INPS and IRPEF
3=3 - IRPEF
4=4 - Not Subjected