HP_RC_GRSFR_DPT (SQL Table)	Index Back
Gross & Fringe Run Cntl - Dept Gross and Fringe Report - This table is the second tier run control table that stores all specified departments to be reported.

HP_RC_GRSFR_DPT

(SQL Table)

Gross & Fringe Run Cntl - Dept

Gross and Fringe Report - This table is the second tier run control table that stores all specified departments to be reported.

Parent record: HP_RC_GRSFR

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_CNTRL_TBL

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_CNTRL_TBL
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL