TL_WORK_TABLES(SQL Table) |
Index Back |
|---|---|
Time Admin Work Tables |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 2 | SQL_ACCESS_D | Character(1) | VARCHAR2(1) NOT NULL |
Allow Deletes
Y/N Table Edit Default Value: Y |
| 3 | SQL_ACCESS_I | Character(1) | VARCHAR2(1) NOT NULL |
Allow Inserts
Y/N Table Edit Default Value: Y |
| 4 | SQL_ACCESS_S | Character(1) | VARCHAR2(1) NOT NULL |
Allow Select
Y/N Table Edit Default Value: Y |
| 5 | SQL_ACCESS_U | Character(1) | VARCHAR2(1) NOT NULL |
Allow Updates
Y/N Table Edit Default Value: Y |
| 6 | STATEREC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
AE State Record
Y/N Table Edit Default Value: N |
| 7 | TA_RUNTIME_TBL | Character(1) | VARCHAR2(1) NOT NULL |
Time Admin Runtime Table
Y/N Table Edit Default Value: Y |
| 8 | AE_PROGRAM | Character(12) | VARCHAR2(12) NOT NULL |
Clear in Program
Prompt Table: TL_TA_AE_PGM_VW |