ACTION_IDTGT_FIELDNAMEPrompt Table: TL_RECFIELD_VW1
Prompt Table: TL_RECFIELD_VW2
0=RecField
1=Constant
2=State Variable
3=Meta SQL
4=Expression
5=Rule Template
Prompt Table: TL_STATE_VARS
Prompt Table: TL_METASQL_TBL
TL_ACTION_DTL(SQL Table) |
Index Back |
|---|---|
Time Admin Action DetailDetail record for T&L Time Administration Actions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTION_ID |
Character(12) | VARCHAR2(12) NOT NULL | Action ID |
| 2 | TGT_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: TL_RECFIELD_VW1 |
| 3 | SRC_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
SRC FieldName
Prompt Table: TL_RECFIELD_VW2 |
| 4 | SRC_FIELD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Source Field Indicator
0=RecField 1=Constant 2=State Variable 3=Meta SQL 4=Expression 5=Rule Template |
| 5 | STATEVAR | Character(35) | VARCHAR2(35) NOT NULL |
State Variable
Prompt Table: TL_STATE_VARS |
| 6 | CONSTANT | Character(35) | VARCHAR2(35) NOT NULL | Constant |
| 7 | META_SQL | Character(30) | VARCHAR2(30) NOT NULL |
MetaSQL
Prompt Table: TL_METASQL_TBL |
| 8 | META_SQL_PARM1 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 1 |
| 9 | META_SQL_PARM2 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 2 |
| 10 | META_SQL_PARM3 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 3 |
| 11 | META_SQL_PARM4 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 4 |
| 12 | META_SQL_PARM5 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 5 |
| 13 | META_SQL_PARM6 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 6 |
| 14 | META_SQL_PARM7 | Character(20) | VARCHAR2(20) NOT NULL | MetaSQL Parameter 7 |
| 15 | EXPRESSION_TXT | Character(254) | VARCHAR2(254) NOT NULL | Expression Text |