GP_GENRPT_RC2 (SQL Table)	Index Back
Run control generic reports/2 Run control record for generic reports. Manages the definition of the columns (from date and to date, per column) for report type 2 (personal summary)

GP_GENRPT_RC2

(SQL Table)

Run control generic reports/2

Run control record for generic reports. Manages the definition of the columns (from date and to date, per column) for report type 2 (personal summary)

Parent record: GP_GENRPT_RC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: GP_GENRPT_RC.RUN_CNTL_ID

3 GP_GENRPT_ROW_NUM Number(5,0) INTEGER NOT NULL Used as counter for row or column number

4 GP_GENRPT_CALID1 Character(10) VARCHAR2(10) NOT NULL Calendar Period used for begin date
Prompt Table: GP_CAL_PRD

5 BGN_DT Date(10) DATE Begin Date

6 GP_GENRPT_CALID2 Character(10) VARCHAR2(10) NOT NULL Calendar Period used for end date
Prompt Table: GP_CAL_PRD

7 END_DT Date(10) DATE end date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: GP_GENRPT_RC.RUN_CNTL_ID
3	GP_GENRPT_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number
4	GP_GENRPT_CALID1	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period used for begin date Prompt Table: GP_CAL_PRD
5	BGN_DT	Date(10)	DATE	Begin Date
6	GP_GENRPT_CALID2	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period used for end date Prompt Table: GP_CAL_PRD
7	END_DT	Date(10)	DATE	end date