TL_TA000600_AET(SQL Table) |
Index Back |
|---|---|
TA punch process variablesState record for the punch matching routine in TA. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DAYBREAKER_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Day Breaker Option
B=Begin Time Of Shift E=End Time Of Shift M=Majority Of Shift S=Split By Day Breaker |
| 3 | DAYBREAKER | Time(15) | TIMESTAMP | Day Breaker Time |
| 4 | DAYBREAKER_RANGE | Character(1) | VARCHAR2(1) NOT NULL |
The Day Breaker Range defines how to determine which date to allocate the day's hours to, in conjunction with the time of the Day Breaker. The options are to apply the hours to the date when the day begins or the date when the day ends.
For example, if the Day Breaker is set to 2:00PM, should the hours prior to 2:00PM be considered part of this day (End option for Day Breaker range), or the previous day (Begin option for Day Breaker Range).
B=Range Start Day E=Range End Day |
| 5 | OFFSET_MIN_DB | Signed Number(10,0) | DECIMAL(9) NOT NULL | Offset in minutes till DayBreaker |
| 6 | PUNCH_IN | DateTime(26) | TIMESTAMP | Punch In |
| 7 | PUNCH_OUT | DateTime(26) | TIMESTAMP | Punch out |
| 8 | ROUNDING_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Governs the rounding scheme for post-rule rounding in the TA process.
D=Round By Day N=No Rounding S=Round Each Entry |
| 9 | ROUNDING_OPTS_PCH | Character(1) | VARCHAR2(1) NOT NULL |
Governs the rounding applied to individual punches and/or the total duration for a days worth of punches as a whole.
D=Round By Day N=No Rounding P=Round Each Punch |
| 10 | ROUNDING_INTERVALS | Number(6,2) | DECIMAL(5,2) NOT NULL | Rounding interval configuration used on Workgroup |
| 11 | ROUNDING_INT_SIGN | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | ROUNDING_INT |
| 12 | ROUNDING_MARKER | Number(6,2) | DECIMAL(5,2) NOT NULL | Rounding Marker (Minutes) |
| 13 | ROUNDING_MARK_SIGN | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | ROUNDING_MARK_SIGN Sign |
| 14 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 15 | STOP_TIME | Time(15) | TIMESTAMP | Period End Time |
| 16 | TIME_RPTG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Type
E=Exception Time Reporting P=Positive Time Reporting |