UPG_TL_SCH_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL | Shift ID |
| 4 | EFFDT | Date(10) | DATE | Effective Date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 8 | PUNCH_TIME | Time(15) | TIMESTAMP | Punch Time |
| 9 | END_EFFDT | Date(10) | DATE | End Effdt |
| 10 | SCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Shift Type
E=Elapsed F=Flex P=Punch |
| 11 | SCHED_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Scheduled Work Hours |
| 12 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 13 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
| 14 | END_OFFSET | Signed Number(2,0) | DECIMAL(1) NOT NULL | Date Under Report Offset identifies the number of days following the start day of a shift to assign a specific punch to. If the punch lands on the same day as the start of the shift, the offset is zero. If it lands on the following day, then the offset is one and so on. |
| 15 | STRT_STOP_DIFF | Number(5,2) | DECIMAL(4,2) NOT NULL | Start Stop Time Duration |
| 16 | FLEX_START_TIME | Time(15) | TIMESTAMP | Flex Start Time identifies the earliest time that a Time Reporter working a Flex shift may consider to be the beginning of the shift. |
| 17 | FLEX_END_TIME | Time(15) | TIMESTAMP | Flex End Time identifies the latest time that a Time Reporter working a Flex shift may consider to be the end of the shift. |
| 18 | FLEX_WK_HRS | Number(3,0) | SMALLINT NOT NULL | Flex Weekly Hours identifies the number of hours expected to be worked and compensated for during one week on the flex shift. |
| 19 | SCH_CONFIG1 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 20 | SCH_CONFIG2 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 21 | SCH_CONFIG3 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 22 | SCH_CONFIG4 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 23 | OFFDAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Off Day Indicator
N=Work Shift Y=Off Shift |
| 24 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 25 | TIME_RPTG_TMPLT | Character(10) | VARCHAR2(10) NOT NULL | Time Reporting Template ID |
| 26 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 27 | PUNCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer |
| 28 | DUR_OFFSET | Signed Number(2,0) | DECIMAL(1) NOT NULL | Date Under Report Offset identifies the number of days following the start day of a shift to assign a specific punch to. If the punch lands on the same day as the start of the shift, the offset is zero. If it lands on the following day, then the offset is one and so on. |
| 29 | PUNCH_END_TIME | Time(15) | TIMESTAMP | Punch End Time |
| 30 | SCH_CONFIG_IND1 | Character(1) | VARCHAR2(1) NOT NULL | Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields. |
| 31 | SCH_CONFIG_IND2 | Character(1) | VARCHAR2(1) NOT NULL | Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields. |
| 32 | SCH_CONFIG_IND3 | Character(1) | VARCHAR2(1) NOT NULL | Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields. |
| 33 | SCH_CONFIG_IND4 | Character(1) | VARCHAR2(1) NOT NULL | Schedule Configuration Indicator is used to identify whether or not a specific punch (shift segment) contributes to a Schedule Configuration total field. There are four indicators to support four total fields. |
| 34 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 35 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 36 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 37 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 38 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 39 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL | Comp Rate Code |
| 40 | BILLABLE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Billable Indicator
N=No Y=Yes |
| 41 | OVERRIDE_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Override Rate. |
| 42 | OVERRIDE_RSN_CD | Character(5) | VARCHAR2(5) NOT NULL | Override Reason Code |
| 43 | RULE_ELEMENT_1 | Character(10) | VARCHAR2(10) NOT NULL | Rule Element 1 |
| 44 | RULE_ELEMENT_3 | Character(10) | VARCHAR2(10) NOT NULL | Rule Element 3 |
| 45 | RULE_ELEMENT_2 | Character(10) | VARCHAR2(10) NOT NULL | Rule Element 2 |
| 46 | RULE_ELEMENT_4 | Character(10) | VARCHAR2(10) NOT NULL | Rule Element 4 |
| 47 | RULE_ELEMENT_5 | Character(10) | VARCHAR2(10) NOT NULL | Rule Element 5 |
| 48 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 49 | TL_COMMENTS | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 50 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 51 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 52 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 53 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 54 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 55 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 56 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code SetID |
| 57 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 58 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 59 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product |
| 60 | CUSTOMER | Character(10) | VARCHAR2(10) NOT NULL | Customer |
| 61 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 62 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 63 | BUSINESS_UNIT_PF | Character(5) | VARCHAR2(5) NOT NULL | Perf Meas Business Unit |
| 64 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
| 65 | SETID_ACTIVITY | Character(5) | VARCHAR2(5) NOT NULL | Activity SetID |
| 66 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 67 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Resource Type |
| 68 | SETID_RESOURCE | Character(5) | VARCHAR2(5) NOT NULL | Resource SetID |
| 69 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Resource Category |
| 70 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Resource Sub Category |
| 71 | TASK | Character(5) | VARCHAR2(5) NOT NULL | Task |
| 72 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |
| 73 | USER_FIELD_2 | Character(10) | VARCHAR2(10) NOT NULL | User Field 2 |
| 74 | USER_FIELD_3 | Character(15) | VARCHAR2(15) NOT NULL | User Field 3 |
| 75 | USER_FIELD_4 | Character(20) | VARCHAR2(20) NOT NULL | User Field 4 |
| 76 | USER_FIELD_5 | Character(20) | VARCHAR2(20) NOT NULL | User Field 5 |
| 77 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 78 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 79 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 80 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 81 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 82 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 83 | COMMENTS | Long Character | CLOB | Comment |