TL_PE_OPR_MGRTM (SQL Table)	Index Back
Time Mgmt Settings Personalization settings for Time Management pagelet

TL_PE_OPR_MGRTM

(SQL Table)

Time Mgmt Settings

Personalization settings for Time Management pagelet

# 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 USER_FIELD_1_FLAG Character(1) VARCHAR2(1) NOT NULL Overtime Limit Reached
Y/N Table Edit
Default Value: Y

3 USER_FIELD_2_FLAG Character(1) VARCHAR2(1) NOT NULL Overtime Approval Required
Y/N Table Edit
Default Value: Y

4 USER_FIELD_3_FLAG Character(1) VARCHAR2(1) NOT NULL Payable Time Approval Required
Y/N Table Edit
Default Value: Y

5 USER_FIELD_4_FLAG Character(1) VARCHAR2(1) NOT NULL Exceptions to Review
Y/N Table Edit
Default Value: Y

6 USER_FIELD_5_FLAG Character(1) VARCHAR2(1) NOT NULL Absence Approval Required
Y/N Table Edit
Default Value: Y

#	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	USER_FIELD_1_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Overtime Limit Reached Y/N Table Edit Default Value: Y
3	USER_FIELD_2_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Overtime Approval Required Y/N Table Edit Default Value: Y
4	USER_FIELD_3_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Payable Time Approval Required Y/N Table Edit Default Value: Y
5	USER_FIELD_4_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Exceptions to Review Y/N Table Edit Default Value: Y
6	USER_FIELD_5_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Absence Approval Required Y/N Table Edit Default Value: Y