| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VARIANT | Data Entry Profile | nvarchar | 8 | 0 | CHAR | (N' ') | No | | CATSVARIAN | Allow NULL? |
| 3 | CHANGABLE | Profile Can Be Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPROFCH | Allow NULL? |
| 4 | PERNRLIST | Display List of Personnel Numbers | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPERLIS | Allow NULL? |
| 5 | MULTPER | Enter for Several Personnel Numbers | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSMULTPE | Allow NULL? |
| 6 | TIMECLERK | Person Selection by Time Administrator | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSTIMECL | Allow NULL? |
| 7 | ORGOBJ | Person Selection by Organizational Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSORGOBJ | Allow NULL? |
| 8 | SELKOSTL | Person Selection by Cost Center | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSELCOS | Allow NULL? |
| 9 | SELWORKPL | NOT USED ! Person Selection via Work Center | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSELWRK | Allow NULL? |
| 10 | SELCUSTOM | NOT USED ! Person Selection via Customer Enhancement | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSELCUS | Allow NULL? |
| 11 | PERTYPE | Type of Data Entry Period | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPERTYP | Allow NULL? |
| 12 | CATSPERIOD | Number of Days/Weeks on Screen | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CATSPERIOD | Allow NULL? |
| 13 | FIRSTDAYOF | First Day of Week | char | 1 | 0 | NUMC | (N'0') | Yes | | CATSFIRSTD | Allow NULL? |
| 14 | PERLEFT | Number of Screens You Can Scroll Down | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CATSPERLEF | Allow NULL? |
| 15 | PERRIGHT | Number of Screens You Can Scroll Up | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CATSPERRIG | Allow NULL? |
| 16 | RELDATE | Key Date Relative to Current Date | decimal | 1 | 0 | DEC | ((0)) | Yes | | CATSRELDAT | |
| 17 | REJEBRIGHT | Rejected Records Highlighted and Display-Only | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSBRIGHT | Allow NULL? |
| 18 | ADDINFOBRI | Highlight Records with Additional Information | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSADDINF | Allow NULL? |
| 19 | DAYTEXT | Display Weekdays | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSDAYTEX | Allow NULL? |
| 20 | BRGRU | Profile Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCATSA | CATSPROFAG | Allow NULL? |
| 21 | BEGEND | Data Entry with Clock Times | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSBEGEN_ | Allow NULL? |
| 22 | TARGETROW | Line with Target Hours per Day | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSTARGET | Allow NULL? |
| 23 | TIMETYPE | Time Type for Target Hours (Default: Day's Planned Hours) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T555A | CATSTIMETY | Allow NULL? |
| 24 | SUBHRTIMES | Subtract HR Attendance or Absence Hours from Target Hours | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSUBHR | Allow NULL? |
| 25 | UNDERTARGE | Max. Percentage by Which Value May Fall Below Target Hours | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CATSUNDERT | Allow NULL? |
| 26 | UNDERREACT | Reaction if Downward Tolerance Is Not Observed | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSUNDERR | Allow NULL? |
| 27 | OVERTARGET | Max. Percentage by Which Value May Exceed Target Hours | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CATSOVERTA | Allow NULL? |
| 28 | OVERREACT | Reaction if Upward Tolerance Is Not Observed | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSOVERRE | Allow NULL? |
| 29 | SUMROW | Line with Totals for Each Day | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSUMROW | Allow NULL? |
| 30 | CALENDAR | Data Entry for Workdays only | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCALE | Allow NULL? |
| 31 | FUTURE | Release Future Times | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSFUTURE | Allow NULL? |
| 32 | WORKLIST | Display Worklist | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSWRKLST | Allow NULL? |
| 33 | ASSIGNED | Worklist from Resource Planning | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSASSIGN | Allow NULL? |
| 34 | WORKCENTRE | Worklist Based on Work Center Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSWORKCT | Allow NULL? |
| 35 | WORKING | Worklist with Operations that Are in Process | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSWORKNG | Allow NULL? |
| 36 | WORKSINCE | CATS: Worklist - From | decimal | 3 | 0 | DEC | ((0)) | Yes | | CATSSINCEP | |
| 37 | FROMPOOL | Worklist with Pool of Confirmations | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPOOL | Allow NULL? |
| 38 | FROMEXIT | Set Up Worklist Using an SAP Enhancement | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSEXITWL | Allow NULL? |
| 39 | WORKWITH | Copy from Worklist Without Hours | char | 1 | 0 | CHAR | (N' ') | Yes | | WORKWITH | Allow NULL? |
| 40 | WF_APPR | Workflow for Approval | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSWFAPPR | Allow NULL? |
| 41 | FREEATSAVE | Release Records on Saving | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSFREEAT | Allow NULL? |
| 42 | APPROVAL | Approval Required | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSAPPROV | Allow NULL? |
| 43 | DEFKOKRSCO | Propose Controlling Area from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSKOKRSC | Allow NULL? |
| 44 | DEFCOSTCO | Propose Master Cost Center from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCOSTCO | Allow NULL? |
| 45 | DEFCOSTCC | Propose Cost Center from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCOSTCC | Allow NULL? |
| 46 | DEFACTTY | Propose Activity Type from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSACTTY | Allow NULL? |
| 47 | DEFPUROR | Propose Purchase Order from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPUROR | Allow NULL? |
| 48 | DEFLSTST | Propose Service Master from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSLSTLS | Allow NULL? |
| 49 | DEFATYPE | Propose Attendance/Absence Type | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSATYPE | Allow NULL? |
| 50 | DEFAWART | Attendance or Absence Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554S | AWART | Allow NULL? |
| 51 | DEFWTYPE | Propose Wage Type | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSWTYPE | Allow NULL? |
| 52 | DEFLGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512Z | LGART | Allow NULL? |
| 53 | TASK | Task ID | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | SWW_TASK | Allow NULL? |
| 54 | KONTIREACT | Reaction if Quota Is Insufficient | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSQUOTAR | Allow NULL? |
| 55 | KOLLIREACT | Reaction if CATS Records Collide | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCOLLIR | Allow NULL? |
| 56 | KOLHRREACT | Reaction if CATS Records Collide with HR Records | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCOLHRR | Allow NULL? |
| 57 | MAXHRREACT | Reaction if More than 24 Hours Are Entered for a Day | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSMAXHRR | Allow NULL? |
| 58 | DIRECTHR | Immediate Transfer to HR | char | 1 | 0 | CHAR | (N' ') | Yes | | DIRECTHR | Allow NULL? |
| 59 | CATSPRINT | Print Program for the Time Sheet | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | TCATP | CATSPRINT | Allow NULL? |
| 60 | SELREPORT | Time Sheet: Report for Person Selection | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | CATSSELRP | Allow NULL? |
| 61 | HRCOSTASG | Cost Accounting Variants | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSHRCO | Allow NULL? |
| 62 | SELREP | Person Selection Using Selection Report | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSELREP | Allow NULL? |
| 63 | CALENDAR_W | Distribution of Hours in Worklist for Workdays Only | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCALE_W | Allow NULL? |
| 64 | NOBREAKDED | No Deduction of Breaks when Calculating Hours | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSNOBRKS | Allow NULL? |
| 65 | ADDOVERTIME | Add Overtime from HR to Target Hours | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSADDOVER | Allow NULL? |
| 66 | WF_AUTO | Automatic Recipient Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSWFAUTO | Allow NULL? |
| 67 | NOCHANGE | Approved Records Cannot Be Changed | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSNOCHNG | Allow NULL? |
| 68 | SKIPISCR | Skip Initial Screen | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSKIPISCR | Allow NULL? |
| 69 | DEFSPRZNR | Propose Sender Business Process from HR Master Record | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSSPRZNR | Allow NULL? |
| 70 | CATSCELL_SIZE | Time Sheet: Cell Length | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CATSCELL_SIZE | Allow NULL? |
| 71 | T_SCHEMA | Trip schema | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T706S | RSCHE | Allow NULL? |
| 72 | TEMPLATE | Personal Templates | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSTEMPLATE | Allow NULL? |
| 73 | PERLOCK | Include CO Period Lock | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPERLOCK | Allow NULL? |
| 74 | EXC_GROUP | Rule Group for Special Approval | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TCATS_EXC_GROUP | CATS_EXC_GROUP | Allow NULL? |
| 75 | SPECIAL_APPROVAL | Approval Required | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSAPPROV | Allow NULL? |
| 76 | WORKCPRO | Worklist from Project Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCPRO | Allow NULL? |
| 77 | ASSIGNDB | Worklist from Staff Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSASGNDB | Allow NULL? |
| 78 | CHECKASDB | Input Checks from Staff Assignments | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSCHKADB | Allow NULL? |
| 79 | HRENABLED | Enable HR information in CATS | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSHRE | Allow NULL? |
| 80 | DATADISPLAY | Display options for data entry in CATS WDA | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSDDISP | Allow NULL? |
| 81 | CUTOFFDT | Time recording cut-off date at the end of payroll period | char | 1 | 0 | CHAR | (N' ') | Yes | | CATSPPE | Allow NULL? |
| 82 | OFFSETPD | Cut-off end date for time recording in CATS | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CATSODD | Allow NULL? |
| 83 | PUBLICHOLTY | Public holiday type for HR-Enabled CATS | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T554S | CATSHABSTY | Allow NULL? |
