GPHK_NRP_RPT_VW (SQL View)	Index Back
Reporting elements Packager This view is used as an export view for the purpose of packaging.

GPHK_NRP_RPT_VW

(SQL View)

Reporting elements Packager

This view is used as an export view for the purpose of packaging.

SELECT GPHK_REPORT_ELM ,EFFDT ,PIN_NUM + 50000000 ,GPHK_MATH_OPR FROM PS_GPHK_REPT_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPHK_REPORT_ELM Character(2) VARCHAR2(2) NOT NULL Report elements are predetermined values that appear in a report. This field contains labels of various monetary informations' that should be reported on a statutory report.

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPHK_YTD_ACM_VW

4 GPHK_MATH_OPR Character(1) VARCHAR2(1) NOT NULL Math Operation to perform on the Accumulator
0=Add
1=Subtract

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPHK_REPORT_ELM	Character(2)	VARCHAR2(2) NOT NULL	Report elements are predetermined values that appear in a report. This field contains labels of various monetary informations' that should be reported on a statutory report.
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPHK_YTD_ACM_VW
4	GPHK_MATH_OPR	Character(1)	VARCHAR2(1) NOT NULL	Math Operation to perform on the Accumulator 0=Add 1=Subtract