SYUSER

Security User (USERS) Database

Seq Field Name Type Length Dec Description
1 U_APPASSWD C 20 0 Payroll User Password
2 U_APPPANEL C 30 0 Default Applicant Detail
3 U_APUSERID C 8 0 Payroll User ID
4 U_CNEMPLR C 3 0 Users Default CN Payroll Company
5 U_DEFCMPNY C 3 0 Default Payroll Company
6 U_EMAIL C 64 0 Email Address
7 U_EMPGUID C 38 0 GUID For Users Default Employee Page
8 U_ENVOYLNK C 1 0 Allow Envoy Link Access
9 U_FINDTYPE C 1 0 Find Dialog or List Find
10 U_GROUP C 25 0 Security Group
11 U_HIDEWLCM L 1 0 Do Not Show Welcome/Home Page Flag
12 U_HRPANEL C 30 0 Default HR Detail
13 U_INACTIVE L 1 0 User Inactive Status
14 U_INTVDED C 1 0 Deduction Setup Interview
15 U_INTVEARN C 1 0 Earning Setup Interview
16 U_INTVINS C 1 0 Insurance Plan Setup Interview
17 U_INTVSAV C 1 0 Savings Plan Setup Interview
18 U_INTVTAX C 1 0 Tax Setup Interview
19 U_ORGTAB C 10 0 Default Tab on Organizer
20 U_OUTLOOK L 1 0 Schedule Tasks in Outlook Indicator
21 U_PASSWORD C 10 0 User Password
22 U_PAYPANEL C 30 0 Default Payroll Detail
23 U_PEPENRLL C 1 0 Is PEP enrolled? (Y/N)
24 U_PEPLSTUP D 8 0 Last updated date and time of PEP into WEB Service
25 U_PINNED L 1 0 Activity Center Pin Status
26 U_POSITION C 25 0 User's position or job title
27 U_PPEMAIL C 128 0 Passport Email Address
28 U_PPPASWRD C 40 0 Passport User Password
29 U_SHORTBAR C 38 0 GUID for Default Shortcut Bar
30 U_STATUS C 4 0 Employee Status Selection for Find Box
31 U_SUMCODES L 1 0 Sum Time Entry Hours by Code
32 U_SUMDATES L 1 0 Sum Time Entry Hours by Date
33 U_TIMEEXPR C 100 0 Time Sheet Entry Sort Order
34 U_TOOLDOCK N 1 0 Quick Launch Toolbar Position
35 U_TRGGUID C 38 0 GUID For Users Default Training Page
36 U_TRGPANEL C 30 0 Default Training Detail
37 U_TSALLOC N 2 0 Alloc. Ind.Time Sheet Entry Order
38 U_TSCHRGDT N 2 0 Charge Date Time Sheet Entry Order
39 U_TSEARNCD N 2 0 Earnings Code Time Sheet Entry Order
40 U_TSHOURS N 2 0 Hours Time Sheet Entry Order
41 U_TSJOBCD N 2 0 Job Code Time Sheet Entry Order
42 U_TSLAYOUT L 1 0 Layout Defined by Pay Group or User
43 U_TSORG1 N 2 0 Division Timesheet Entry Order
44 U_TSORG2 N 2 0 Department Timesheet Entry Order
45 U_TSORG3 N 2 0 Location Timesheet Entry Order
46 U_TSORG4 N 2 0 Not Defined
47 U_TSORG5 N 2 0 Not Defined
48 U_TSPAY N 2 0 Pay Rate Time Sheet Entry Order
49 U_TSPROJ N 2 0 Project Code Time Sheet Entry Order
50 U_TSSHIFT N 2 0 Shift Code Time Sheet Entry Order
51 U_TSTAXCD N 2 0 Tax Code Time Sheet Entry Order
52 U_USEMPLR C 3 0 Users Default Payroll Company
53 U_USERID C 10 0 User ID
54 U_USERNAME C 25 0 User Name
55 Z_FILTER C 25 0 Filter Function