TL_OPR_SECURITY

(SQL Table)
Index Back

T&L Operator Security Tbl

This record is used to

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
2 PPA_ACCESS Character(1) VARCHAR2(1) NOT NULL Prior Period Adjustment Access

Y/N Table Edit

Default Value: N

3 PPA_ALLOW Number(3,0) SMALLINT NOT NULL Days from Prd End Dt to Adj
4 USE_TL_SYSDATE Character(1) VARCHAR2(1) NOT NULL Use TL System Date

Y/N Table Edit

Default Value: N

5 TL_SYSTEM_DT Date(10) DATE TL System Date
6 FUT_ACCESS Character(1) VARCHAR2(1) NOT NULL Allow Future Time Entry

Y/N Table Edit

Default Value: N

7 FUT_ALLOW Number(3,0) SMALLINT NOT NULL Future Days Grace Allowed
8 PY_ACCESS Character(1) VARCHAR2(1) NOT NULL Restrict Prior Year Time Entry

Y/N Table Edit

9 PY_MONTH Character(2) VARCHAR2(2) NOT NULL Prior Year Ends In
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December