GP_NRP_GRBRK_VW

(SQL View)
 Index Back

NRP for Generic Report Breaks

Non Rules Package View for GP_GENRPT_BKLVL

SELECT A.GP_GENRPT_BRK_LVL ,A.DESCR ,A.PIN_NUM +50000000 ,A.DATA_TYPE_CD ,A.ENTRY_TYPE_ID ,A.RECNAME ,A.FIELDNAME FROM PS_GP_GENRPT_BKLVL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_GENRPT_BRK_LVL Character(2) VARCHAR2(2) NOT NULL Break Level Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD7

4 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
N=Customer Data
S=Sample Data
Y=System Data
5 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

Prompt Table: GP_ENT_GRBRK_VW

6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: GP_PSRECDEFN_VW

7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: GP_FIELDNAME_VW