GP_NRP_PSBLK_VW

(SQL View)
 Index Back

Payslip Template Section Block

Payslip Template Section Block - Non Rules Packager

SELECT GP_CNTRY_PSLP_TMPL , GP_PSLP_TMPL , EFFDT , SEQ_NUM , GP_PSLP_BLK_SEQ , GP_PSLP_BLOCK_NBR , GP_PSLP_BLOCK_TYPE , GP_PSLP_BLOCK_CONT , PIN_ELEM_GRP_NUM + 50000000 FROM PS_GP_PSLP_TMPLBLK WHERE GP_PSLP_BLOCK_TYPE = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_CNTRY_PSLP_TMPL Character(3) VARCHAR2(3) NOT NULL Country
2 GP_PSLP_TMPL Character(12) VARCHAR2(12) NOT NULL This field is used to uniquely identify a payslip template.

Prompt Table: GP_PSLP_TMPL

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 GP_PSLP_BLK_SEQ Number(3,0) SMALLINT NOT NULL Payslip Block Sequence
6 GP_PSLP_BLOCK_NBR Number(3,0) SMALLINT NOT NULL Payslip Template Section Block Number
7 GP_PSLP_BLOCK_TYPE Character(1) VARCHAR2(1) NOT NULL Payslip Template Section Block Detail type
A=Address
E=Element Group
O=Other
8 GP_PSLP_BLOCK_CONT Character(30) VARCHAR2(30) NOT NULL Payslip Block Content

Prompt Table: %EDITTABLE

9 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group

Prompt Table: GP_PSLP_ELN_VW