AUDIT_SCH_TBL(SQL Table) |
Index Back |
|---|---|
Schedule Audit TableThis table is used to record all the audits. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUDIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 2 | AUDIT_STAMP | DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 3 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 6 | DUR | Date(10) | DATE NOT NULL | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 7 | SCH_PRIM_ALT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether this is the employee's Primary or Alternate SChedule
A=Alternate P=Primary |
| 8 | SEQ_NO | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 9 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 10 | SCHED_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Schedule Source indicates the source of Time Reporter Detail Schedule information.
E=Enterprise Learning Management I=Third Party Import L=Long Term Schedule O=On-Line Change |
| 11 | PUNCH_DTTM | DateTime(26) | TIMESTAMP NOT NULL | Date and time when the punch occurred. |
| 12 | SCH_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
Schedule Category
AB=Absence Management MT=Meeting OT=Other RE=Replace TR=Training WK=Work |
| 13 | SCHEDULE_GRP | Character(10) | VARCHAR2(10) NOT NULL | Scheduling Organizational Group Code |
| 14 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 15 | WRKDAY_ID | Character(10) | VARCHAR2(10) NOT NULL | Workday ID |
| 16 | OFFDAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Off Day Indicator
N=Work Shift Y=Off Shift Y/N Table Edit |
| 17 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL | Shift ID |
| 18 | PUNCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer |
| 19 | DELETE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Delete Indicator is used to indicate whether a row has been logically deleted.
Y/N Table Edit Default Value: N |
| 20 | TRC | Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table: TL_TRC_TBL |
| 21 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 23 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 24 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 25 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL |
Locality
Prompt Table: LOCAL_TAX_TBL |
| 26 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: COMP_RT_REG_VW |
| 27 | BILLABLE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Billable Indicator
N=No Y=Yes Y/N Table Edit Default Value: N |
| 28 | OVERRIDE_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Override Rate. |
| 29 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 30 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: TL_BUS_UNIT_VW |
| 31 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 32 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: TL_LOCATION_VW |
| 33 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 34 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: TL_DEPT_TBL_VW |
| 35 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code SetID |
| 36 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: TL_JOBCODE_VW |
| 37 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 38 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product
Prompt Table: TL_PRODUCT_TBL |
| 39 | CUSTOMER | Character(10) | VARCHAR2(10) NOT NULL |
Customer
Prompt Table: TL_CUSTOMER |
| 40 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 41 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 42 | BUSINESS_UNIT_PF | Character(5) | VARCHAR2(5) NOT NULL |
Perf Meas Business Unit
Prompt Table: BUS_UNIT_TBL_PF |
| 43 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
| 44 | SETID_ACTIVITY | Character(5) | VARCHAR2(5) NOT NULL | Activity SetID |
| 45 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 46 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Resource Type
Prompt Table: TL_PROJ_RTYPE_V |
| 47 | SETID_RESOURCE | Character(5) | VARCHAR2(5) NOT NULL | Resource SetID |
| 48 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Resource Category |
| 49 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Resource Sub Category |
| 50 | TASK | Character(5) | VARCHAR2(5) NOT NULL |
Task
Prompt Table: TL_TASK |
| 51 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL |
User Field 1
Prompt Table: TL_USER_FIELD_1 |
| 52 | USER_FIELD_2 | Character(10) | VARCHAR2(10) NOT NULL |
User Field 2
Prompt Table: TL_USER_FIELD_2 |
| 53 | USER_FIELD_3 | Character(15) | VARCHAR2(15) NOT NULL |
User Field 3
Prompt Table: TL_USER_FIELD_3 |
| 54 | USER_FIELD_4 | Character(20) | VARCHAR2(20) NOT NULL |
User Field 4
Prompt Table: TL_USER_FIELD_4 |
| 55 | USER_FIELD_5 | Character(20) | VARCHAR2(20) NOT NULL |
User Field 5
Prompt Table: TL_USER_FIELD_5 |
| 56 | RULE_ELEMENT_1 | Character(10) | VARCHAR2(10) NOT NULL |
Rule Element 1
Prompt Table: TL_RULE_ELEMNT1 |
| 57 | RULE_ELEMENT_2 | Character(10) | VARCHAR2(10) NOT NULL |
Rule Element 2
Prompt Table: TL_RULE_ELEMNT1 |
| 58 | RULE_ELEMENT_3 | Character(10) | VARCHAR2(10) NOT NULL |
Rule Element 3
Prompt Table: TL_RULE_ELEMNT3 |
| 59 | RULE_ELEMENT_4 | Character(10) | VARCHAR2(10) NOT NULL |
Rule Element 4
Prompt Table: TL_RULE_ELEMNT4 |
| 60 | RULE_ELEMENT_5 | Character(10) | VARCHAR2(10) NOT NULL |
Rule Element 5
Prompt Table: TL_RULE_ELEMNT5 |
| 61 | 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. |
| 62 | 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. |
| 63 | 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. |
| 64 | 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. |
| 65 | SCH_EXT_FLD1 | Character(10) | VARCHAR2(10) NOT NULL | Schedule External Key Field 1 |
| 66 | SCH_EXT_FLD2 | Character(10) | VARCHAR2(10) NOT NULL | Schedule External Key Field 2 |
| 67 | SCH_EXT_FLD3 | Character(10) | VARCHAR2(10) NOT NULL | Schedule External Key Field 2 |
| 68 | SCH_EXT_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Activity Status
C=Completed E=Enrolled I=In Progress |
| 69 | SCH_EXT_ACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Schedule Activity Type
001=Sessions 002=Webcast |
| 70 | ACTIVITY_NAME | Character(200) | VARCHAR2(200) NOT NULL | Activity Name |
| 71 | SCH_EXT_EVENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Schedule Event Type
0001=Training 0002=Trainer 001=Training 002=Trainer |
| 72 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 73 | END_DATE | Date(10) | DATE | End Date |
| 74 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 75 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
| 76 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 77 | FACILITY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description of Facility |
| 78 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 79 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 80 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 81 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 82 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 83 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 84 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 85 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 86 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 87 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 88 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 89 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 90 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 91 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 92 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL | In City Limit |
| 93 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 94 | DATETIME_CREATED | DateTime(26) | TIMESTAMP | DateTime Created |
| 95 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last Operator to Update |
| 96 | DATETIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |
| 97 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 98 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 99 | OVERRIDE_RSN_CD | Character(5) | VARCHAR2(5) NOT NULL | Override Reason Code |