GP_PSLP_TMPLSCT

(SQL Table)
Index Back

Payslip Template Sections

Payslip Template Sections

# 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.
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 GP_CNTRY_PSLP_SCT Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY

6 GP_PSLP_SECTION Character(12) VARCHAR2(12) NOT NULL Payslip Section

Prompt Table: GP_PSLP_SCT_VW

7 GP_PSLP_SECT_BGNLN Number(3,0) SMALLINT NOT NULL Section Begin Line
8 GP_PSLP_SECT_STYLE Character(1) VARCHAR2(1) NOT NULL The style attribute of a section determines if it is static, dynamic or both
B=Both Static and Dynamic
D=Dynamic
S=Static

Prompt Table: GP_PSLP_STYL_VW

9 GP_PSLP_SECT_TYPE Character(1) VARCHAR2(1) NOT NULL This will describe the type of the section that will be used in the template
B=Body
F=Footer
H=Header

Default Value: B

10 GP_PSLP_SECT_RCALC Character(1) VARCHAR2(1) NOT NULL Recalculate Section Start Line

Y/N Table Edit

Default Value: Y