TL_RULE_OPA (SQL Table)	Index Back
OPA Rule Table This record is used to store OPA rule parameters entered on the time and labor rules page.

TL_RULE_OPA

(SQL Table)

OPA Rule Table

This record is used to store OPA rule parameters entered on the time and labor rules page.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID

2 TL_OPA_RBASE_ID Character(15) VARCHAR2(15) NOT NULL OPA Rule Base ID

3 TL_OPA_CHUNK_MTHS Number(2,0) SMALLINT NOT NULL OPA Number of Chunking Months

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TL_RULE_ID	Character(12)	VARCHAR2(12) NOT NULL	Rule ID
2	TL_OPA_RBASE_ID	Character(15)	VARCHAR2(15) NOT NULL	OPA Rule Base ID
3	TL_OPA_CHUNK_MTHS	Number(2,0)	SMALLINT NOT NULL	OPA Number of Chunking Months