GM_RC_TE (SQL Table)	Index Back
Parameters - Time&Effort Cert Process Scheduler report parameter record utilized by Grants time and effort certification report SQR.

GM_RC_TE

(SQL Table)

Parameters - Time&Effort Cert

Process Scheduler report parameter record utilized by Grants time and effort certification report SQR.

# 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 1

4 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
Prompt Table: PAY_RUN_TBL

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

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

7 PAY_END_DT Date(10) DATE Pay Period End Date
Prompt Table: PAY_CALENDAR

8 CYCLE_SELECT Character(1) VARCHAR2(1) NOT NULL Off-Cycle
B=Both
F=Off-Cycle
O=On-Cycle
Default Value: B

9 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
Y/N Table Edit
Default Value: N

10 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
Prompt Table: PAY_PAGE

11 PAGE_NUM_THRU Number(4,0) SMALLINT NOT NULL Thru Page Number
Prompt Table: PAY_PAGE

12 TEXT20 Character(20) VARCHAR2(20) NOT NULL Text (20 Characters)

13 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	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	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
4	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID Prompt Table: PAY_RUN_TBL
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
7	PAY_END_DT	Date(10)	DATE	Pay Period End Date Prompt Table: PAY_CALENDAR
8	CYCLE_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle B=Both F=Off-Cycle O=On-Cycle Default Value: B
9	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N
10	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page # Prompt Table: PAY_PAGE
11	PAGE_NUM_THRU	Number(4,0)	SMALLINT NOT NULL	Thru Page Number Prompt Table: PAY_PAGE
12	TEXT20	Character(20)	VARCHAR2(20) NOT NULL	Text (20 Characters)
13	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.