HP_RC_GRSFR (SQL Table)	Index Back
Gross & Fringe Run Control Gross and Fringe Report - This table is the run control table for both load process and report process.

HP_RC_GRSFR

(SQL Table)

Gross & Fringe Run Control

Gross and Fringe Report - This table is the run control table for both load process and report process.

Parent Record Of HP_RC_GRSFR_ACT HP_RC_GRSFR_DPT HP_RC_GRSFR_PRJ

# 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

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

5 FROMDATE Date(10) DATE From Date

6 THRUDATE Date(10) DATE End Date

7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

8 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Accounting Period

9 PAY_END_DT Date(10) DATE Pay Period End Date

10 HP_INCL_RETRO Character(1) VARCHAR2(1) NOT NULL This indicator controls if retro distribution data are loaded to temporary table.
Y/N Table Edit
Default Value: N

11 HP_ALL_COMPPYG Character(1) VARCHAR2(1) NOT NULL This indicator controls if the loading process and report process is running for all companies and paygroups.
Y/N Table Edit
Default Value: Y

12 HP_ALL_DEPT Character(1) VARCHAR2(1) NOT NULL This indicator controls if the report process is running for all departments.
Y/N Table Edit
Default Value: Y

13 HP_ALL_FUNDSRC Character(1) VARCHAR2(1) NOT NULL This indicator controls if the report process is running for all funding sources.
Y/N Table Edit
Default Value: Y

14 HP_ALL_PROJECTS Character(1) VARCHAR2(1) NOT NULL This indicator controls if the report process is running for all projects.
Y/N Table Edit
Default Value: Y

15 HP_RPT_COLDEFN_CD Character(5) VARCHAR2(5) NOT NULL This field identifies the report definition set that the report based on to cumulate gross wages and fringe benefits.
Prompt Table: HP_COL_DEFN_TBL

16 HP_SUMMARY_RPT Character(1) VARCHAR2(1) NOT NULL This indicator controls if the report process to generate a detail report or summary report.
D=Detail Report
S=Summary Report
Default Value: D

17 HP_SORT_FYACTPD Character(1) VARCHAR2(1) NOT NULL This indicator controls if sort by fiscal year and accounting period is required.
Default Value: Y

18 HP_SORT_DEPT Character(1) VARCHAR2(1) NOT NULL This indicator controls if sort by department is required.
Default Value: Y

19 HP_SORT_CD Character(1) VARCHAR2(1) NOT NULL This field identifies the report secondary sort sequence.
F=Funding Source
N=None
P=Position
R=Project
Default Value: N

20 HP_DTL_SORT_CD Character(1) VARCHAR2(1) NOT NULL This field identifies the detail report sort sequence.
C=Pay Check No
I=Employee ID
N=Employee Name
Default Value: I

#	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
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
4	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
5	FROMDATE	Date(10)	DATE	From Date
6	THRUDATE	Date(10)	DATE	End Date
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Accounting Period
9	PAY_END_DT	Date(10)	DATE	Pay Period End Date
10	HP_INCL_RETRO	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if retro distribution data are loaded to temporary table. Y/N Table Edit Default Value: N
11	HP_ALL_COMPPYG	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if the loading process and report process is running for all companies and paygroups. Y/N Table Edit Default Value: Y
12	HP_ALL_DEPT	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if the report process is running for all departments. Y/N Table Edit Default Value: Y
13	HP_ALL_FUNDSRC	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if the report process is running for all funding sources. Y/N Table Edit Default Value: Y
14	HP_ALL_PROJECTS	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if the report process is running for all projects. Y/N Table Edit Default Value: Y
15	HP_RPT_COLDEFN_CD	Character(5)	VARCHAR2(5) NOT NULL	This field identifies the report definition set that the report based on to cumulate gross wages and fringe benefits. Prompt Table: HP_COL_DEFN_TBL
16	HP_SUMMARY_RPT	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if the report process to generate a detail report or summary report. D=Detail Report S=Summary Report Default Value: D
17	HP_SORT_FYACTPD	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if sort by fiscal year and accounting period is required. Default Value: Y
18	HP_SORT_DEPT	Character(1)	VARCHAR2(1) NOT NULL	This indicator controls if sort by department is required. Default Value: Y
19	HP_SORT_CD	Character(1)	VARCHAR2(1) NOT NULL	This field identifies the report secondary sort sequence. F=Funding Source N=None P=Position R=Project Default Value: N
20	HP_DTL_SORT_CD	Character(1)	VARCHAR2(1) NOT NULL	This field identifies the detail report sort sequence. C=Pay Check No I=Employee ID N=Employee Name Default Value: I