EMPLIDEMPL_RCDN=Not Up For Processing
X=In Process
Y=Up For Processing
TL_TR_STATUS(SQL Table) |
Index Back |
|---|---|
Time Reporter StatusThe Time Reporter Status Record maintains information necessary for the accurate execution of Time Administration Rules. There is one Time Reporter Status row for every Time Reporter. On this row, a status indicates whether Time Administration needs to be run for this Time Reporter. In addition, the datetime of last update and the earliest change date since the last Time Administration run are maintained for use by Time Administration processing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | TA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Time Administration Status
N=Not Up For Processing X=In Process Y=Up For Processing |
| 4 | EARLIEST_CHGDT | Date(10) | DATE | Earliest Date of Change |
| 5 | PRCS_THRU_DT | Date(10) | DATE | Process Through Date |
| 6 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 7 | LAST_PRCS_DTTM | DateTime(26) | TIMESTAMP | Contains the time an entity was Last Processed. Introduced for tracking TA processing of time reporters. |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |