TL_RAPID_TM_AET(SQL Table) |
Index Back |
---|---|
Rapid Time State RecordParameter record used for the TL_SUBMITALL routine which is the connector to TL_ST_LIB for Rapid Time |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | CALL_TA | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the TA process should be run as a direct extension at the end of the Submit Time process.
With the introduction of the option of subjecting reported time to approval, this may in cases no longer be a viable option.
0=Don't Automatically Run Rules 1=Automatically Run Rules |
3 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
6 | EXISTS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery.
0=Exists 1=Not Exists |
7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
8 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
9 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
10 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Submit Time Instance |
11 | TIME_RPTR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time.
E=Elapsed Time Reporter P=Punch Time Reporter |
12 | TL_ADDREP_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field designates whether time should be added to or replace a particular day's time.
A=Addition C=Correction R=Replacement |
13 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
14 | TL_TASK_SUM | Character(243) | VARCHAR2(243) NOT NULL | Task Sum |
15 | TL_TRC_SUM | Character(54) | VARCHAR2(54) NOT NULL | Sum TRC |