Support‎ > ‎

HRPro Data Dictionary

Index
SrObjectType
1[dbo].[Attachment]Table
2[dbo].[AttendanceImportFormatTable]Table
3[dbo].[AutopayFileFormatTable]Table
4[dbo].[BAJobs]Table
5[dbo].[CompanyDictionary]Table
6[dbo].[Custom]Table
7[dbo].[Dictionary]Table
8[dbo].[ecSetup]Table
9[dbo].[EmailQueue]Table
10[dbo].[EmployeeToken]Table
11[dbo].[epSETUP]Table
12[dbo].[EventLog]Table
13[dbo].[GBBANK]Table
14[dbo].[GBCOMP]Table
15[dbo].[GBLOCD]Table
16[dbo].[GBLOCN]Table
17[dbo].[GBPARM]Table
18[dbo].[GBQKTX]Table
19[dbo].[HRProMenu]Table
20[dbo].[IRDCategory]Table
21[dbo].[IRDCategoryM]Table
22[dbo].[LeaveTypeByEEClass]Table
23[dbo].[NoticeBoard]Table
24[dbo].[PersonalOptions]Table
25[dbo].[PFundTypeTable]Table
26[dbo].[plATTD]Table
27[dbo].[plATTLog]Table
28[dbo].[plATTPeriod]Table
29[dbo].[plATTRaw]Table
30[dbo].[plAutoPayClass]Table
31[dbo].[plCLEntitlementApply]Table
32[dbo].[plCompanyProperty]Table
33[dbo].[plCSCR]Table
34[dbo].[plDate]Table
35[dbo].[plDeduction]Table
36[dbo].[plDept]Table
37[dbo].[plDivision]Table
38[dbo].[plEEChangeLog]Table
39[dbo].[plEECLASS]Table
40[dbo].[plEECostCentre]Table
41[dbo].[plEEPeriod]Table
42[dbo].[plEEUpdate]Table
43[dbo].[plEmployee]Table
44[dbo].[plEmployer]Table
45[dbo].[plEmploymentHistory]Table
46[dbo].[plExpense]Table
47[dbo].[plExpenseDeleted]Table
48[dbo].[plExpensePeriod]Table
49[dbo].[plHoliday]Table
50[dbo].[plIR56B]Table
51[dbo].[plIR56BBatch]Table
52[dbo].[plIR56F]Table
53[dbo].[plIR56G]Table
54[dbo].[plIR56M]Table
55[dbo].[plIR56MBatch]Table
56[dbo].[plIRFormChangeLog]Table
57[dbo].[plLeave]Table
58[dbo].[plLeaveAdjustment]Table
59[dbo].[plLeaveApply]Table
60[dbo].[plLeaveApplyCancel]Table
61[dbo].[plLeaveDayRecord]Table
62[dbo].[plLeaveDeleted]Table
63[dbo].[plLeaveEntitlement]Table
64[dbo].[plLeaveNature]Table
65[dbo].[plLeavePeriod]Table
66[dbo].[plLeaveType]Table
67[dbo].[plMPFRules]Table
68[dbo].[plMPFSP]Table
69[dbo].[plOT]Table
70[dbo].[plPayroll]Table
71[dbo].[plPayrollBatch]Table
72[dbo].[plPayrollChangeLog]Table
73[dbo].[plPayType]Table
74[dbo].[plPayTypeAccount]Table
75[dbo].[plPeriod]Table
76[dbo].[plPosition]Table
77[dbo].[plPrePaidPayroll]Table
78[dbo].[plPrepaidPayrollBatch]Table
79[dbo].[plPromotion]Table
80[dbo].[plReminder]Table
81[dbo].[plRoster]Table
82[dbo].[plRosterD]Table
83[dbo].[plSetup]Table
84[dbo].[plShift]Table
85[dbo].[plSkillQuali]Table
86[dbo].[plTermnReason]Table
87[dbo].[plTraining]Table
88[dbo].[plUser]Table
89[dbo].[plUserQuery]Table
90[dbo].[plUserRight]Table
91[dbo].[plUserRightDeptCode]Table
92[dbo].[plUserRightDivisionCode]Table
93[dbo].[plUserRightEEClass]Table
94[dbo].[plWorkHrs]Table
95[dbo].[plWorkHrs_Sat]Table
96[dbo].[RptControl]Table
97[dbo].[RptControlColumnSelection]Table
98[dbo].[RptControlCondition]Table
99[dbo].[RptControlOrderBy]Table
100[dbo].[RptControlSelectionSettings]Table
101[dbo].[smCONTROL]Table
102[dbo].[UDFTable]Table
103[dbo].[wrkAnnualLeaveForfeiture]Table
104[dbo].[wrkColumnSelection]Table
105[dbo].[wrkEPMenuByUserID]Table
106[dbo].[wrkExcelColumns]Table
107[dbo].[wrkExcelSheetNo]Table
108[dbo].[wrkFileUpload]Table
109[dbo].[wrkHRProMenuByUserID]Table
110[dbo].[wrkHRProReminderByUserID]Table
111[dbo].[wrkIR56FG]Table
112[dbo].[wrkLeaveEntryByGroup]Table
113[dbo].[wrkManageEmployeeByGroup]Table
114[dbo].[wrkManageEmployeeByGroupDeptCode]Table
115[dbo].[wrkManageEmployeeByGroupDivisionCode]Table
116[dbo].[wrkManageEmployeeByGroupEEClass]Table
117[dbo].[wrkOutputToEmail]Table
118[dbo].[wrkPayTypeSetup]Table
119[dbo].[wrkRptControlColumnValue]Table
120[dbo].[wrkSMControl]Table
121[dbo].[wrkSubordinates]Table
122[dbo].[wrkUserCompany]Table
123[dbo].[wrkUserGroup]Table
124[dbo].[wrkUserRight]Table
125[dbo].[wrkWriteEmployeeLetter]Table




Index
Table:[dbo].[Attachment]

Description
Attachment Table

Table Columns
Sr.NameDatatypeNullableDescription
1AttachmentIDNUMERICNAttachment ID
2ScreenNVARCHAR(40)YScreen ID
3KeyNoNVARCHAR(60)YKey
4PathNVARCHAR(400)NPath
5DescriptionNVARCHAR(510)YDescription
6IsSalaryBITN
7AttachmentSizeINTY
8AttachmentImageVARBINARYY
9Create_byCHAR(12)NCreated By
10Create_DateDATETIMENCreation Date

Default Constraints
Sr.NameColumnValue
1DF_Attachment_IsSalaryIsSalary((0))

Triggers
Sr.NameDescription
1Attachment_HandleReseedofIdentity
2Attachment_InsertUpdate
3Tr_Attachment
4Tr_Attachment_Validating

Indexes
Sr.NameTypeColumns
1Attachment_Index1NonclusteredScreen
KeyNo
2PK_AttachmentClusteredAttachmentID




Index
Table:[dbo].[AttendanceImportFormatTable]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1ATTENDANCE_IMPORT_FORMATINTN
2DESCRIPTIONNVARCHAR(100)Y
3FILE_FORMATNVARCHAR(100)Y
4ACCEPTNVARCHAR(100)Y
5IMPORT_FORMATNCHAR(2)Y
6IS_DESKTOP_CLIENTBITN
7IS_WEB_CLIENTBITN

Default Constraints
Sr.NameColumnValue
1DF_AttendanceImportFormatTable_IS_DESKTOP_CLIENTIS_DESKTOP_CLIENT((0))
2DF_AttendanceImportFormatTable_IS_WEB_CLIENTIS_WEB_CLIENT((0))

Indexes
Sr.NameTypeColumns
1PK_AttendanceImportFormatTableClusteredATTENDANCE_IMPORT_FORMAT




Index
Table:[dbo].[AutopayFileFormatTable]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1AUTOPAY_FILE_FORMATINTN
2DESCRIPTIONNVARCHAR(100)Y
3DefaultFileNVARCHAR(100)Y
4DialogFilterNVARCHAR(100)Y
5DialogDefaultExtNVARCHAR(20)Y
6CompleteMessageNVARCHAR(1000)Y
7AutopayFunctionNVARCHAR(100)Y
8IS_DESKTOP_CLIENTBITN
9IS_WEB_CLIENTBITN

Default Constraints
Sr.NameColumnValue
1DF_AutopayFileFormatTable_IS_DESKTOP_CLIENTIS_DESKTOP_CLIENT((0))
2DF_AutopayFileFormatTable_IS_WEB_CLIENTIS_WEB_CLIENT((0))

Indexes
Sr.NameTypeColumns
1PK_AutopayFileFormatTableClusteredAUTOPAY_FILE_FORMAT




Index
Table:[dbo].[BAJobs]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1job_noINTN
2nameNVARCHAR(256)N
3enabledBITN
4descriptionNVARCHAR(1024)Y
5job_typeNVARCHAR(40)N
6rptcodeNCHAR(20)Y
7freq_textNVARCHAR(200)Y
8freq_typeINTY
9freq_intervalINTY
10active_start_timeINTY
11active_end_timeINTY
12next_run_datetimeSMALLDATETIMEY
13last_run_datetimeSMALLDATETIMEY
14last_run_statusNVARCHAR(2048)Y
15notify_emailBITY
16emailNVARCHAR(512)Y
17ccNVARCHAR(512)Y
18SubjectNVARCHAR(512)Y
19MessageNVARCHAR(8000)Y
20PriorityINTY
21notify_faxINTY
22faxNVARCHAR(100)Y
23database_nameSYSNAMEN
24commandNVARCHAR(8000)Y
25additional_parametersNVARCHAR(-1)Y
26CREATE_BYNCHAR(20)Y
27CREATE_DATEDATETIMEY
28LAST_UPDATE_BYNCHAR(20)Y
29LAST_UPDATE_DATEDATETIMEY

Triggers
Sr.NameDescription
1Tr_BAJobs

Indexes
Sr.NameTypeColumns
1PK_BAJOBSClusteredjob_no




Index
Table:[dbo].[CompanyDictionary]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2LANGUAGENVARCHAR(10)N
3ENGLISHNVARCHAR(880)N
4TRANSLATE_TONVARCHAR(-1)Y

Default Constraints
Sr.NameColumnValue
1DF_CompanyDictionary_LANGUAGELANGUAGE('zh-HK')

Indexes
Sr.NameTypeColumns
1CompanyDictionary_Index1NonclusteredLANGUAGE
ENGLISH
2PK_CompanyDictionaryClusteredID




Index
Table:[dbo].[Custom]

Description
Customization Table

Table Columns
Sr.NameDatatypeNullableDescription
1ACTIVEBITY
2CUSTOM_NOCHAR(4)N
3CUSTOMERNVARCHAR(60)Y
4CUSTOM_DESCRNVARCHAR(-1)Y

Indexes
Sr.NameTypeColumns
1CUSTOM_INDEX1NonclusteredACTIVE
2PK_CUSTOMClusteredCUSTOM_NO




Index
Table:[dbo].[Dictionary]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1LANGUAGENCHAR(20)N
2ENGLISHNVARCHAR(880)N
3TRANSLATE_TONVARCHAR(-1)Y
4AUTO_UPDATECHAR(1)Y

Default Constraints
Sr.NameColumnValue
1DF_Dictionary_LANGUAGELANGUAGE('zh-HK')

Indexes
Sr.NameTypeColumns
1IX_DictionaryNonclusteredLANGUAGE
2PK_Dictionary_1ClusteredLANGUAGE
ENGLISH




Index
Table:[dbo].[ecSetup]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2ENABLE_EXPENSE_MODULEBITN
3EXPENSE_PERIOD_START_DAYINTN
4EXPENSE_PERIOD_OF_MONTHINTN
5EXPENSE_PERIOD_OFFSETINTN
6EXPENSE_APPLICATION_ACTION_IS_FINALBITN
7DISALLOW_AMEND_WEBLEAVE_EXPENSE_RECORDSBITN
8EC_USER01_VISIBLEBITN
9EC_USER01_NAMENVARCHAR(100)N
10EC_USER02_VISIBLEBITN
11EC_USER02_NAMENVARCHAR(100)N
12EC_USER03_VISIBLEBITN
13EC_USER03_NAMENVARCHAR(100)N
14EC_USER04_VISIBLEBITN
15EC_USER04_NAMENVARCHAR(100)N
16EC_USER05_VISIBLEBITN
17EC_USER05_NAMENVARCHAR(100)N
18EC_USER06_VISIBLEBITN
19EC_USER06_NAMENVARCHAR(100)N
20EC_USER07_VISIBLEBITN
21EC_USER07_NAMENVARCHAR(100)N
22EC_USER08_VISIBLEBITN
23EC_USER08_NAMENVARCHAR(100)N
24EC_USER09_VISIBLEBITN
25EC_USER09_NAMENVARCHAR(100)N
26EC_USER10_VISIBLEBITN
27EC_USER10_NAMENVARCHAR(100)N
28EC_USER11_VISIBLEBITN
29EC_USER11_NAMENVARCHAR(100)N
30EC_USER12_VISIBLEBITN
31EC_USER12_NAMENVARCHAR(100)N
32EC_USER13_VISIBLEBITN
33EC_USER13_NAMENVARCHAR(100)N
34EC_USER14_VISIBLEBITN
35EC_USER14_NAMENVARCHAR(100)N
36EC_USER15_VISIBLEBITN
37EC_USER15_NAMENVARCHAR(100)N
38EC_USER16_VISIBLEBITN
39EC_USER16_NAMENVARCHAR(100)N
40EC_USER17_VISIBLEBITN
41EC_USER17_NAMENVARCHAR(100)N
42EC_USER18_VISIBLEBITN
43EC_USER18_NAMENVARCHAR(100)N
44EC_USER19_VISIBLEBITN
45EC_USER19_NAMENVARCHAR(100)N
46EC_USER20_VISIBLEBITN
47EC_USER20_NAMENVARCHAR(100)N
48CREATE_BYCHAR(10)N
49CREATE_DATEDATETIMEN
50LAST_UPDATE_BYCHAR(10)N
51LAST_UPDATE_DATEDATETIMEN

Default Constraints
Sr.NameColumnValue
1DF_ecSetup_DISALLOW_AMEND_WEBLEAVE_EXPENSE_RECORDSDISALLOW_AMEND_WEBLEAVE_EXPENSE_RECORDS((0))
2DF_ecSetup_EC_USER01_NAMEEC_USER01_NAME('')
3DF_ecSETUP_EC_USER01_VISIBLEEC_USER01_VISIBLE((0))
4DF_ecSetup_EC_USER02_NAMEEC_USER02_NAME('')
5DF_ecSETUP_EC_USER02_VISIBLEEC_USER02_VISIBLE((0))
6DF_ecSetup_EC_USER03_NAMEEC_USER03_NAME('')
7DF_ecSETUP_EC_USER03_VISIBLEEC_USER03_VISIBLE((0))
8DF_ecSetup_EC_USER04_NAMEEC_USER04_NAME('')
9DF_ecSETUP_EC_USER04_VISIBLEEC_USER04_VISIBLE((0))
10DF_ecSetup_EC_USER05_NAMEEC_USER05_NAME('')
11DF_ecSETUP_EC_USER05_VISIBLEEC_USER05_VISIBLE((0))
12DF_ecSetup_EC_USER06_NAMEEC_USER06_NAME('')
13DF_ecSETUP_EC_USER06_VISIBLEEC_USER06_VISIBLE((0))
14DF_ecSetup_EC_USER07_NAMEEC_USER07_NAME('')
15DF_ecSETUP_EC_USER07_VISIBLEEC_USER07_VISIBLE((0))
16DF_ecSetup_EC_USER08_NAMEEC_USER08_NAME('')
17DF_ecSETUP_EC_USER08_VISIBLEEC_USER08_VISIBLE((0))
18DF_ecSetup_EC_USER09_NAMEEC_USER09_NAME('')
19DF_ecSETUP_EC_USER09_VISIBLEEC_USER09_VISIBLE((0))
20DF_ecSetup_EC_USER10_NAMEEC_USER10_NAME('')
21DF_ecSETUP_EC_USER10_VISIBLEEC_USER10_VISIBLE((0))
22DF_ecSetup_EC_USER11_NAMEEC_USER11_NAME('')
23DF_ecSETUP_EC_USER11_VISIBLEEC_USER11_VISIBLE((0))
24DF_ecSetup_EC_USER12_NAMEEC_USER12_NAME('')
25DF_ecSETUP_EC_USER12_VISIBLEEC_USER12_VISIBLE((0))
26DF_ecSetup_EC_USER13_NAMEEC_USER13_NAME('')
27DF_ecSETUP_EC_USER13_VISIBLEEC_USER13_VISIBLE((0))
28DF_ecSetup_EC_USER14_NAMEEC_USER14_NAME('')
29DF_ecSETUP_EC_USER14_VISIBLEEC_USER14_VISIBLE((0))
30DF_ecSetup_EC_USER15_NAMEEC_USER15_NAME('')
31DF_ecSETUP_EC_USER15_VISIBLEEC_USER15_VISIBLE((0))
32DF_ecSetup_EC_USER16_NAMEEC_USER16_NAME('')
33DF_ecSETUP_EC_USER16_VISIBLEEC_USER16_VISIBLE((0))
34DF_ecSetup_EC_USER17_NAMEEC_USER17_NAME('')
35DF_ecSETUP_EC_USER17_VISIBLEEC_USER17_VISIBLE((0))
36DF_ecSetup_EC_USER18_NAMEEC_USER18_NAME('')
37DF_ecSETUP_EC_USER18_VISIBLEEC_USER18_VISIBLE((0))
38DF_ecSetup_EC_USER19_NAMEEC_USER19_NAME('')
39DF_ecSETUP_EC_USER19_VISIBLEEC_USER19_VISIBLE((0))
40DF_ecSetup_EC_USER20_NAMEEC_USER20_NAME('')
41DF_ecSETUP_EC_USER20_VISIBLEEC_USER20_VISIBLE((0))
42DF_ecSetup_ENABLE_EXPENSE_MODULEENABLE_EXPENSE_MODULE((1))
43DF_ecSetup_EXPENSE_APPLICATION_ACTION_IS_FINALEXPENSE_APPLICATION_ACTION_IS_FINAL((0))
44DF_ecSetup_EXPENSE_PERIOD_OF_MONTHEXPENSE_PERIOD_OF_MONTH((1))
45DF_ecSetup_EXPENSE_PERIOD_OFFSETEXPENSE_PERIOD_OFFSET((0))
46DF_ecSetup_EXPENSE_PERIOD_START_DAYEXPENSE_PERIOD_START_DAY((1))

Triggers
Sr.NameDescription
1Tr_ecSETUPChangeLog

Indexes
Sr.NameTypeColumns
1PK_ecSETUPClusteredCOMPANY_CODE




Index
Table:[dbo].[EmailQueue]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EmailIDINTN
2EmailToNVARCHAR(400)N
3EmailCCNVARCHAR(400)N
4EmailBCCNVARCHAR(400)N
5EmailSubjectNVARCHAR(400)N
6EmailBodyNVARCHAR(-1)N
7IsAttachmentBITN
8AttachmentFileNameNVARCHAR(400)N
9AttachmentVARBINARYY
10WithEmbeddedImageBITN
11EmailSentDateDATETIMEY
12IsSentBITN
13IsErrorBITN
14ResultMessageNVARCHAR(-1)N
15CREATE_BYNVARCHAR(20)N
16CREATE_DATEDATETIMEN

Default Constraints
Sr.NameColumnValue
1DF_EmailQueue_AttachmentFileNameAttachmentFileName('')
2DF_EmailQueue_IsAttachmentIsAttachment((0))
3DF_EmailQueue_IsErrorIsError((0))
4DF_EmailQueue_WithEmbeddedImageWithEmbeddedImage((0))

Indexes
Sr.NameTypeColumns
1PK_EmailQueueClusteredEmailID




Index
Table:[dbo].[EmployeeToken]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2CREATE_DATEDATETIMEN
3TOKENNVARCHAR(600)N

Indexes
Sr.NameTypeColumns
1PK_EmployeeTokenClusteredEE_NO




Index
Table:[dbo].[epSETUP]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2WEBLEAVE_DECIMALINTY
3WEBLEAVE_HOUR_DECIMALINTY
4WEBLEAVE_DISALLOW_LEAVE_APPLICATION_WHEN_ZERO_BALANCEBITN
5WEBLEAVE_SHOW_LEAVE_ADJUSTMENT_IN_LEAVE_HISTORYBITN
6WEBLEAVE_SHOW_LEAVE_ADJUSTMENT_IN_SUBORDINATE_LEAVE_HISTORYBITN
7WEBLEAVE_SHOW_COMPENSATION_LEAVE_BALANCEBITN
8WEBLEAVE_COM_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
9WEBLEAVE_SHOW_SICK_LEAVE_BALANCEBITN
10WEBLEAVE_SICK_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
11WEBLEAVE_SHOW_FULLPAY_SICK_LEAVE_BALANCEBITN
12WEBLEAVE_FULLPAY_SICK_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
13WEBLEAVE_ANNUAL_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
14WEBLEAVE_SHOW_ALTERNATE_ANNUAL_LEAVE_BALANCEBITN
15WEBLEAVE_SHOW_ENTITLED_ANNUAL_LEAVE_BALANCEBITN
16WEBLEAVE_ALTERNATE_ANNUAL_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
17WEBLEAVE_SHOW_CURRENT_YEAR_TAKENBITN
18WEBLEAVE_CURRENT_YEAR_TAKEN_STATEMENTNVARCHAR(160)Y
19WEBLEAVE_ENABLE_ATTACHMENTBITN
20WEBLEAVE_ENABLE_HR_RECEIVES_APPROVED_REJECTED_EMAILBITN
21WEBLEAVE_ENABLE_DEPT_MGR_RECEIVES_APPROVED_REJECTED_EMAILBITN
22WEBLEAVE_MAKE_APPLY_LEAVE_AS_STARTUP_PAGEBITN
23WEBLEAVE_ENABLE_CHINESEBITN
24WEBLEAVE_REQUIRE_APPROVAL_FOR_BOTH_APPROVERSBITN
25WEBLEAVE_APPROVAL_WORKFLOWINTY
26WEBLEAVE_SHOW_AL_PENDING_APPROVALBITN
27WEBLEAVE_SHOW_AL_APPROVEDBITN
28WEBLEAVE_ENABLE_CL_ENTITLEMENT_APPLICATIONBITN
29WEBLEAVE_ENABLE_CL_ENTITLEMENT_APPROVALBITN
30WEBLEAVE_ENABLE_EXPENSE_CLAIMS_APPLICATIONBITN
31WEBLEAVE_ENABLE_EXPENSE_CLAIMS_APPROVALBITN
32WEBLEAVE_ALLOW_OT_COM_BY_COM_LEAVEBITN
33WEBLEAVE_ALLOW_OT_COM_BY_OT_PAYBITN
34WEBLEAVE_MAX_DAYS_FOR_OT_COM_LEAVEINTY
35WEBLEAVE_MAX_DAYS_FOR_OT_COM_APPLICATIONINTY
36WEBLEAVE_APPLICANT_CHOOSE_APPROVERBITN
37WEBLEAVE_ENABLE_CANCEL_REQUESTBITN
38WEBLEAVE_ENABLE_CANCEL_REQUEST_EVEN_PAST_LEAVEBITN
39WEBLEAVE_SHOW_AL_BROUGHT_FORWARDBITN
40WEBLEAVE_SHOW_AL_ENTITLEDBITN
41WEBLEAVE_SHOW_CURRENT_YEAR_ADJUSTMENTBITN
42WEBLEAVE_OT_COM_VALIDATE_ATTENDANCEBITN
43WEBLEAVE_OT_COM_REQUIRED_ATTACHMENTBITN
44WEBLEAVE_OT_COM_APPROVER_NO1_ASINTN
45WEBLEAVE_OT_COM_APPROVER_NO2_ASINTN
46WEBLEAVE_OT_COM_APPROVER_NO3_ASINTN
47WEBLEAVE_OT_COM_APPROVAL_WORKFLOWINTN
48WEBLEAVE_ENABLE_LEAVE_DAYS_OVERWRITEBITN
49WEBLEAVE_SET_DEFAULT_LEAVE_DATE_TO_TODAYBITN
50WEBLEAVE_LEAVE_BALANCE_INCLUDE_PENDING_APPROVALBITN
51WEBLEAVE_SHOW_CASUAL_LEAVE_BALANCEBITN
52WEBLEAVE_SHOW_CASUAL_LEAVE_APPROVEDBITN
53WEBLEAVE_ENABLE_LEAVE_BY_TIMEBITN
54WEBLEAVE_OT_FROMTO_VALIDATE_INOUT_TIMEBITN
55WEBLEAVE_ENABLE_REAL_TIME_VALIDATION_WHEN_APPLYING_LEAVEBITN
56WEBLEAVE_ENABLE_REPLENISH_ATTACHMENTBITN
57WEBLEAVE_SHOW_AAL_BROUGHT_FORWARDBITN
58WEBLEAVE_SHOW_AAL_ENTITLEDBITN
59WEBLEAVE_SHOW_ENTITLED_AAL_BALANCEBITN
60WEBLEAVE_SHOW_ACTUAL_AAL_BALANCEBITN
61WEBLEAVE_SHOW_AAL_PENDING_APPROVALBITN
62WEBLEAVE_SHOW_AAL_APPROVEDBITN
63WEBLEAVE_SHOW_AAL_CURRENT_YEAR_TAKENBITN
64WEBLEAVE_SHOW_AAL_CURRENT_YEAR_ADJUSTMENTBITN
65WEBLEAVE_SHOW_COMPENSATION_LEAVE_APPROVEDBITN
66WEBLEAVE_SHOW_LEAVE_TYPE_BALANCEBITN
67WEBLEAVE_SHOW_AL_BROUGHT_FORWARD_STATEMENTNVARCHAR(160)N
68WEBLEAVE_SHOW_AL_ENTITLED_STATEMENTNVARCHAR(160)N
69WEBLEAVE_SHOW_AL_PENDING_APPROVAL_STATEMENTNVARCHAR(160)N
70WEBLEAVE_SHOW_AL_APPROVED_STATEMENTNVARCHAR(160)N
71WEBLEAVE_SHOW_CURRENT_YEAR_ADJUSTMENT_STATEMENTNVARCHAR(160)N
72WEBLEAVE_SHOW_AAL_BROUGHT_FORWARD_STATEMENTNVARCHAR(160)N
73WEBLEAVE_SHOW_AAL_ENTITLED_STATEMENTNVARCHAR(160)N
74WEBLEAVE_SHOW_ENTITLED_AAL_BALANCE_STATEMENTNVARCHAR(160)N
75WEBLEAVE_SHOW_ACTUAL_AAL_BALANCE_STATEMENTNVARCHAR(160)N
76WEBLEAVE_SHOW_AAL_PENDING_APPROVAL_STATEMENTNVARCHAR(160)N
77WEBLEAVE_SHOW_AAL_APPROVED_STATEMENTNVARCHAR(160)N
78WEBLEAVE_SHOW_AAL_CURRENT_YEAR_TAKEN_STATEMENTNVARCHAR(160)N
79WEBLEAVE_SHOW_AAL_CURRENT_YEAR_ADJUSTMENT_STATEMENTNVARCHAR(160)N
80WEBLEAVE_SHOW_COMPENSATION_LEAVE_APPROVED_STATEMENTNVARCHAR(160)N
81WEBLEAVE_SHOW_CASUAL_LEAVE_BALANCE_STATEMENTNVARCHAR(160)N
82WEBLEAVE_SHOW_CASUAL_LEAVE_APPROVED_STATEMENTNVARCHAR(160)N
83EP_ENABLE_WEBLEAVEBITN
84EP_ENABLE_ATTENDANCE_RECORDBITN
85EP_ENABLE_UPDATE_PERSONAL_PARTICULARSBITN
86EP_APPROVE_UPP_BYNCHAR(20)Y
87EP_ENABLE_UPP_REPLY_BY_EMAILBITN
88EP_UPP_APPROVE_SUBJECTNVARCHAR(510)Y
89EP_UPP_APPROVE_CONTENTNVARCHAR(2048)Y
90EP_UPP_REJECT_SUBJECTNVARCHAR(510)Y
91EP_UPP_REJECT_CONTENTNVARCHAR(2048)Y
92EP_ENABLE_NOTICE_BOARDBITN
93EP_ENABLE_COMPANY_LIBRARYBITN
94EP_ENABLE_PHONE_LISTBITN
95EP_ENABLE_COMPANY_CALENDARBITN
96EP_SHOW_POSITION_ON_PHONE_LISTBITN
97EP_ENABLE_SALARY_HISTORYBITN
98EP_SH_NO_OF_PERIODINTY
99EP_IR56B_NO_OF_YEARINTY
100EP_SHOW_PAYSLIP_REMARKS_ON_SALARY_DETAILSBITN
101EP_ENABLE_CHANGE_PASSWORDBITN
102EP_LOGINPAGE_MESSAGENVARCHAR(-1)Y
103EP_SHOW_SHIFT_CODE_ON_EVENT_CALENDARBITN
104EP_COMPANY_CALENDAR_SHOW_BIRTHDAYBITN
105EP_ENABLE_SUPERIOR_VIEW_SUBORDINATEBITN
106EP_DISABLE_EMPLOYEE_PORTALBITN
107EP_ENABLE_UPDATE_ROSTERBITN
108EP_ENABLE_SUBORDINATE_PROFILEBITN
109EP_SHOW_APPLY_INOUT_TIME_OVERWRITE_LINKBITN
110EP_SHOW_APPLY_INOUT_TIME_CORRECTION_LINK_ON_EVERYDAYBITN
111EP_ENABLE_LEAVE_APPLICATION_REPLY_BY_EMAIL_IN_HRPROBITN
112EP_ENABLE_CAPTCHA_ON_LOGIN_PAGEBITN
113EP_ALLOW_LOGIN_BY_EMAILBITN
114EP_ENABLE_VIEW_PAYSLIPBITN
115EP_ENABLE_VIEW_IR56BBITN
116EP_ENABLE_DRILLDOWN_ON_CALENDARBITN
117EP_SHOW_CARD_TIMES_IN_ATTENDANCE_RECORDBITN
118EP_DISABLE_EMAIL_NOTIFICATIONBITN
119EP_ENABLE_ATTENDANCE_PERFORMANCEBITN
120EP_EVENT_CALENDAR_SHOWS_BIRTHDAYBITN
121EP_EVENT_CALENDAR_SHOWS_PROBATION_END_DATEBITN
122EP_ENABLE_APPROVER_SELF_DELEGATIONBITN
123EP_ENABLE_ICALENDAR_LINKBITN
124EP_ENABLE_ICALENDAR_FEEDBITN
125EP_ENABLE_BACKGROUNDBITN
126EP_BACKGROUND_NO_REPEATBITN
127EP_BACKGROUND_CENTERBITN
128EP_SHOW_PHOTO_ON_DIRECTORYBITN
129EP_SHOW_REPORT_TO_ON_DIRECTORYBITN
130EP_PASSWORD_MIN_LENGTHINTN
131EP_PASSWORD_LOWER_CASEBITN
132EP_PASSWORD_UPPER_CASEBITN
133EP_PASSWORD_DIGITBITN
134EP_PASSWORD_SYMBOLBITN
135EP_SHOW_EP_PASSWORD_IN_EMPLOYEE_MASTERBITN
136EP_ENABLE_UPDATE_PERSONAL_PARTICULARS_UPDATE_QUALI_AND_EMPLOYMENT_HISTORYBITN
137EP_COMPANY_CALENDAR_SHOW_LEGENDBITN
138EP_EVENT_CALENDAR_SHOW_LEGENDBITN
139EP_ICALENDAR_FEED_VALID_DAYSINTN
140EP_ENABLE_SUBORDINATE_OT_COMPENSATION_APPLICATION_HISTORYBITN
141EP_ENABLE_BACKGROUND_EMAILBITN
142EP_ENABLE_DELETE_UNDELIVERABLE_EMAILBITN
143EP_SHOW_QR_CODE_LINKBITN
144EP_PASSWORD_PROTECT_DOWNLOAD_DOCUMENTSBITN
145EP_EXTERNAL_LINK_DESC1NVARCHAR(200)N
146EP_EXTERNAL_LINK_URL1NVARCHAR(1000)N
147EP_EXTERNAL_LINK_DESC2NVARCHAR(200)N
148EP_EXTERNAL_LINK_URL2NVARCHAR(1000)N
149EP_EXTERNAL_LINK_DESC3NVARCHAR(200)N
150EP_EXTERNAL_LINK_URL3NVARCHAR(1000)N
151EP_EXTERNAL_LINK_DESC4NVARCHAR(200)N
152EP_EXTERNAL_LINK_URL4NVARCHAR(1000)N
153EP_EXTERNAL_LINK_DESC5NVARCHAR(200)N
154EP_EXTERNAL_LINK_URL5NVARCHAR(1000)N
155LAST_UPDATE_BY_EPCHAR(10)Y
156LAST_UPDATE_DATE_EPDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_epSETUP_EP_BACKGROUND_CENTEREP_BACKGROUND_CENTER((0))
2DF_epSETUP_EP_BACKGROUND_REPEATEP_BACKGROUND_NO_REPEAT((0))
3DF_epSETUP_EP_COMPANY_CALENDAR_SHOW_LEGENDEP_COMPANY_CALENDAR_SHOW_LEGEND((1))
4DF_epSETUP_EP_ENABLE_APPROVER_SELF_DELEGATIONEP_ENABLE_APPROVER_SELF_DELEGATION((0))
5DF_epSETUP_EP_ENABLE_ATTENDANCE_PERFORMANCEEP_ENABLE_ATTENDANCE_PERFORMANCE((0))
6DF_epSETUP_EP_ENABLE_BACKGROUNDEP_ENABLE_BACKGROUND((0))
7DF_epSETUP_EP_ENABLE_BACKGROUND_EMAILEP_ENABLE_BACKGROUND_EMAIL((0))
8DF_epSETUP_EP_ENABLE_COMPANY_CALENDAREP_ENABLE_COMPANY_CALENDAR((1))
9DF_epSETUP_EP_ENABLE_DELETE_UNDELIVERABLE_EMAILEP_ENABLE_DELETE_UNDELIVERABLE_EMAIL((0))
10DF_epSETUP_EP_ENABLE_ICALENDAR_FEEDEP_ENABLE_ICALENDAR_FEED((0))
11DF_epSETUP_EP_ENABLE_ICALENDAR_LINKEP_ENABLE_ICALENDAR_LINK((0))
12DF_epSETUP_EP_ENABLE_NOTICE_BOARDEP_ENABLE_NOTICE_BOARD((1))
13DF_epSETUP_EP_ENABLE_UPDATE_PERSONAL_PARTICULARS_UPDATE_QUALI_AND_EMPLOYMENT_HISTORYEP_ENABLE_UPDATE_PERSONAL_PARTICULARS_UPDATE_QUALI_AND_EMPLOYMENT_HISTORY((0))
14DF_epSETUP_EP_ENABLE_WEBLEAVEEP_ENABLE_WEBLEAVE((1))
15DF_epSETUP_EP_EVENT_CALENDAR_SHOW_BIRTHDAYEP_EVENT_CALENDAR_SHOWS_BIRTHDAY((1))
16DF_epSETUP_EP_EVENT_CALENDAR_SHOW_LEGENDEP_EVENT_CALENDAR_SHOW_LEGEND((1))
17DF_epSETUP_EP_EVENT_CALENDAR_SHOW_PROBATION_END_DATEEP_EVENT_CALENDAR_SHOWS_PROBATION_END_DATE((1))
18DF_epSETUP_EP_EXTERNAL_LINK_DESCEP_EXTERNAL_LINK_DESC1('')
19DF_epSETUP_EP_EXTERNAL_LINK_DESC2EP_EXTERNAL_LINK_DESC2('')
20DF_epSETUP_EP_EXTERNAL_LINK_DESC3EP_EXTERNAL_LINK_DESC3('')
21DF_epSETUP_EP_EXTERNAL_LINK_DESC4EP_EXTERNAL_LINK_DESC4('')
22DF_epSETUP_EP_EXTERNAL_LINK_DESC5EP_EXTERNAL_LINK_DESC5('')
23DF_epSETUP_EP_EXTERNAL_LINK_URL1EP_EXTERNAL_LINK_URL1('')
24DF_epSETUP_EP_EXTERNAL_LINK_URL2EP_EXTERNAL_LINK_URL2('')
25DF_epSETUP_EP_EXTERNAL_LINK_URL3EP_EXTERNAL_LINK_URL3('')
26DF_epSETUP_EP_EXTERNAL_LINK_URL4EP_EXTERNAL_LINK_URL4('')
27DF_epSETUP_EP_EXTERNAL_LINK_URL5EP_EXTERNAL_LINK_URL5('')
28DF_epSETUP_EP_ICALENDAR_FEED_VALID_DAYSEP_ICALENDAR_FEED_VALID_DAYS((90))
29DF_epSETUP_EP_IR56B_NO_OF_PERIODEP_IR56B_NO_OF_YEAR((1))
30DF_epSETUP_EP_PASSWORD_DIGITEP_PASSWORD_DIGIT((0))
31DF_epSETUP_EP_PASSWORD_LOWER_CASEEP_PASSWORD_LOWER_CASE((0))
32DF_epSETUP_EP_PASSWORD_MIN_LENGTHEP_PASSWORD_MIN_LENGTH((4))
33DF_epSETUP_EP_PASSWORD_PROTECT_DOWNLOAD_DOCUMENTSEP_PASSWORD_PROTECT_DOWNLOAD_DOCUMENTS((0))
34DF_epSETUP_EP_PASSWORD_SYMBOLEP_PASSWORD_SYMBOL((0))
35DF_epSETUP_EP_PASSWORD_UPPER_CASEEP_PASSWORD_UPPER_CASE((0))
36DF_epSETUP_EP_SHOW_APPLY_INOUT_TIME_CORRECTION_LINK_ON_EVERYDAYEP_SHOW_APPLY_INOUT_TIME_CORRECTION_LINK_ON_EVERYDAY((0))
37DF_epSETUP_EP_SHOW_EP_PASSWORD_IN_EMPLOYEE_MASTEREP_SHOW_EP_PASSWORD_IN_EMPLOYEE_MASTER((0))
38DF_epSETUP_EP_SHOW_PHOTO_ON_DIRECTORYEP_SHOW_PHOTO_ON_DIRECTORY((0))
39DF_epSETUP_EP_SHOW_QR_CODE_LINKEP_SHOW_QR_CODE_LINK((1))
40DF_epSETUP_EP_SHOW_REPORT_TO_ON_DIRECTORYEP_SHOW_REPORT_TO_ON_DIRECTORY((0))
41DF_epSETUP_WEBLEAVE_ALLOW_OT_COM_BY_COM_LEAVEWEBLEAVE_ALLOW_OT_COM_BY_COM_LEAVE((1))
42DF_epSETUP_WEBLEAVE_ENABLE_CL_ENTITLEMENT_APPROVALWEBLEAVE_ENABLE_CL_ENTITLEMENT_APPROVAL((1))
43DF_epSETUP_WEBLEAVE_ENABLE_DEPT_MGR_ RECEIVES_APPROVED_REJECTED_EMAILWEBLEAVE_ENABLE_DEPT_MGR_RECEIVES_APPROVED_REJECTED_EMAIL((0))
44DF_epSETUP_WEBLEAVE_ENABLE_EXPENSE_CLAIMS_APPLICATIONWEBLEAVE_ENABLE_EXPENSE_CLAIMS_APPLICATION((1))
45DF_epSETUP_WEBLEAVE_ENABLE_EXPENSE_CLAIMS_APPROVALWEBLEAVE_ENABLE_EXPENSE_CLAIMS_APPROVAL((1))
46DF_epSETUP_WEBLEAVE_ENABLE_LEAVE_BY_TIMEWEBLEAVE_ENABLE_LEAVE_BY_TIME((0))
47DF_epSETUP_WEBLEAVE_ENABLE_REAL_TIME_VALIDATION_WHEN_APPLYING_LEAVEWEBLEAVE_ENABLE_REAL_TIME_VALIDATION_WHEN_APPLYING_LEAVE((0))
48DF_epSETUP_WEBLEAVE_ENABLE_REPLENISH_ATTACHMENTWEBLEAVE_ENABLE_REPLENISH_ATTACHMENT((0))
49DF_epSETUP_WEBLEAVE_ENABLE_SUBORDINATE_OT_COMPENSATION_APPLICATIONEP_ENABLE_SUBORDINATE_OT_COMPENSATION_APPLICATION_HISTORY((0))
50DF_epSETUP_WEBLEAVE_OT_COM_APPROVAL_WORKFLOWWEBLEAVE_OT_COM_APPROVAL_WORKFLOW((0))
51DF_epSETUP_WEBLEAVE_OT_COM_APPROVER_NO1_ASWEBLEAVE_OT_COM_APPROVER_NO1_AS((1))
52DF_epSETUP_WEBLEAVE_OT_COM_APPROVER_NO2_ASWEBLEAVE_OT_COM_APPROVER_NO2_AS((2))
53DF_epSETUP_WEBLEAVE_OT_COM_APPROVER_NO3_ASWEBLEAVE_OT_COM_APPROVER_NO3_AS((3))
54DF_epSETUP_WEBLEAVE_OT_COM_REQUIRED_ATTACHMENTWEBLEAVE_OT_COM_REQUIRED_ATTACHMENT((0))
55DF_epSETUP_WEBLEAVE_OT_FROMTO_VALIDATE_INOUT_TIMEWEBLEAVE_OT_FROMTO_VALIDATE_INOUT_TIME((1))
56DF_epSETUP_WEBLEAVE_SHOW_AAL_APPROVEDWEBLEAVE_SHOW_AAL_APPROVED((0))
57DF_epSETUP_WEBLEAVE_SHOW_AAL_APPROVED_STATEMENTWEBLEAVE_SHOW_AAL_APPROVED_STATEMENT('')
58DF_epSETUP_WEBLEAVE_SHOW_AAL_BROUGHT_FORWARDWEBLEAVE_SHOW_AAL_BROUGHT_FORWARD((0))
59DF_epSETUP_WEBLEAVE_SHOW_AAL_BROUGHT_FORWARD_STATEMENTWEBLEAVE_SHOW_AAL_BROUGHT_FORWARD_STATEMENT('')
60DF_epSETUP_WEBLEAVE_SHOW_AAL_CURRENT_YEAR_ADJUSTMENTWEBLEAVE_SHOW_AAL_CURRENT_YEAR_ADJUSTMENT((0))
61DF_epSETUP_WEBLEAVE_SHOW_AAL_CURRENT_YEAR_ADJUSTMENT_STATEMENTWEBLEAVE_SHOW_AAL_CURRENT_YEAR_ADJUSTMENT_STATEMENT('')
62DF_epSETUP_WEBLEAVE_SHOW_AAL_CURRENT_YEAR_TAKENWEBLEAVE_SHOW_AAL_CURRENT_YEAR_TAKEN((0))
63DF_epSETUP_WEBLEAVE_SHOW_AAL_CURRENT_YEAR_TAKEN_STATEMENTWEBLEAVE_SHOW_AAL_CURRENT_YEAR_TAKEN_STATEMENT('')
64DF_epSETUP_WEBLEAVE_SHOW_AAL_ENTITLEDWEBLEAVE_SHOW_AAL_ENTITLED((0))
65DF_epSETUP_WEBLEAVE_SHOW_AAL_ENTITLED_STATEMENTWEBLEAVE_SHOW_AAL_ENTITLED_STATEMENT('')
66DF_epSETUP_WEBLEAVE_SHOW_AAL_PENDING_APPROVALWEBLEAVE_SHOW_AAL_PENDING_APPROVAL((0))
67DF_epSETUP_WEBLEAVE_SHOW_AAL_PENDING_APPROVAL_STATEMENTWEBLEAVE_SHOW_AAL_PENDING_APPROVAL_STATEMENT('')
68DF_epSETUP_WEBLEAVE_SHOW_ACTUAL_AAL_BALANCEWEBLEAVE_SHOW_ACTUAL_AAL_BALANCE((0))
69DF_epSETUP_WEBLEAVE_SHOW_ACTUAL_AAL_BALANCE_STATEMENTWEBLEAVE_SHOW_ACTUAL_AAL_BALANCE_STATEMENT('')
70DF_epSETUP_WEBLEAVE_SHOW_AL_APPROVED_STATEMENTWEBLEAVE_SHOW_AL_APPROVED_STATEMENT('')
71DF_epSETUP_WEBLEAVE_SHOW_AL_BROUGHT_FORWARD_STATEMENTWEBLEAVE_SHOW_AL_BROUGHT_FORWARD_STATEMENT('')
72DF_epSETUP_WEBLEAVE_SHOW_AL_CURRENT_YEAR_ADJUSTMENTWEBLEAVE_SHOW_CURRENT_YEAR_ADJUSTMENT((0))
73DF_epSETUP_WEBLEAVE_SHOW_AL_ENTITLED_STATEMENTWEBLEAVE_SHOW_AL_ENTITLED_STATEMENT('')
74DF_epSETUP_WEBLEAVE_SHOW_AL_PENDING_APPROVAL_STATEMENTWEBLEAVE_SHOW_AL_PENDING_APPROVAL_STATEMENT('')
75DF_epSETUP_WEBLEAVE_SHOW_CASUAL_LEAVE_APPROVEDWEBLEAVE_SHOW_CASUAL_LEAVE_APPROVED((1))
76DF_epSETUP_WEBLEAVE_SHOW_CASUAL_LEAVE_APPROVED_STATEMENTWEBLEAVE_SHOW_CASUAL_LEAVE_APPROVED_STATEMENT('')
77DF_epSETUP_WEBLEAVE_SHOW_CASUAL_LEAVE_BALANCE_STATEMENTWEBLEAVE_SHOW_CASUAL_LEAVE_BALANCE_STATEMENT('')
78DF_epSETUP_WEBLEAVE_SHOW_COMPENSATION_LEAVE_APPROVEDWEBLEAVE_SHOW_COMPENSATION_LEAVE_APPROVED((0))
79DF_epSETUP_WEBLEAVE_SHOW_COMPENSATION_LEAVE_APPROVED_STATEMENTWEBLEAVE_SHOW_COMPENSATION_LEAVE_APPROVED_STATEMENT('')
80DF_epSETUP_WEBLEAVE_SHOW_CURRENT_YEAR_ADJUSTMENT_STATEMENTWEBLEAVE_SHOW_CURRENT_YEAR_ADJUSTMENT_STATEMENT('')
81DF_epSETUP_WEBLEAVE_SHOW_ENTITLED_AAL_BALANCEWEBLEAVE_SHOW_ENTITLED_AAL_BALANCE((0))
82DF_epSETUP_WEBLEAVE_SHOW_ENTITLED_AAL_BALANCE_STATEMENTWEBLEAVE_SHOW_ENTITLED_AAL_BALANCE_STATEMENT('')
83DF_epSETUP_WEBLEAVE_SHOW_LEAVE_TYPE_BALANCEWEBLEAVE_SHOW_LEAVE_TYPE_BALANCE((0))

Triggers
Sr.NameDescription
1Tr_epSETUPChangeLog

Indexes
Sr.NameTypeColumns
1PK_epSETUPClusteredCOMPANY_CODE




Index
Table:[dbo].[EventLog]

Description
Event Log Table

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EventTypeCHAR(1)Y
3EventTimeDATETIMEN
4ComputerNameNVARCHAR(200)N
5BrowserIDNVARCHAR(200)N
6UserIDVARCHAR(20)N
7SourceNVARCHAR(100)Y
8CategoryNVARCHAR(100)Y
9EventNVARCHAR(8000)N
10OriginalValuesNVARCHAR(8000)Y
11NewValuesNVARCHAR(8000)Y

Default Constraints
Sr.NameColumnValue
1DF_EventLog_BrowserIDBrowserID('')

Indexes
Sr.NameTypeColumns
1EVENTLOG_INDEX1NonclusteredComputerName
2EVENTLOG_INDEX2NonclusteredRowSerial
3PK_EventLogClusteredRowSerial




Index
Table:[dbo].[GBBANK]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1BANK_CODEVARCHAR(5)N
2BANK_NAMENVARCHAR(200)N
3ALTERNATE_NAMENVARCHAR(200)Y
4CREATE_BYCHAR(10)Y
5CREATE_DATEDATETIMEY
6LAST_UPDATE_BYCHAR(10)Y
7LAST_UPDATE_DATEDATETIMEY

Triggers
Sr.NameDescription
1Tr_GBBANK
2Tr_GBBANK_Deleting

Indexes
Sr.NameTypeColumns
1PK_GBBANKClusteredBANK_CODE




Index
Table:[dbo].[GBCOMP]

Description
Company Table

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2LOGOVARBINARYY
3WEB_SITEVARCHAR(40)Y
4DATE_FORMATCHAR(10)Y
5QTY_DECIMALINTY
6ENGLISH_PRINTOUTINTY
7ERPRO_VERSIONCHAR(12)Y
8ERPRO_VERSION_DATEDATETIMEY
9EVENTLOG_RETAIN_DAYSSMALLINTY

Default Constraints
Sr.NameColumnValue
1DF_GBCOMP_EVENTLOG_RETAIN_DAYSEVENTLOG_RETAIN_DAYS((30))

Indexes
Sr.NameTypeColumns
1PK_GBCOMPClusteredCOMPANY_CODE




Index
Table:[dbo].[GBLOCD]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2LOCATIONNVARCHAR(20)N
3DEVICENVARCHAR(40)N

Indexes
Sr.NameTypeColumns
1GBLOCD_Index1NonclusteredDEVICE
2GBLOCD_Index2NonclusteredLOCATION
3PK_GBLOCDClusteredTS_KEY




Index
Table:[dbo].[GBLOCN]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1LOCATIONNVARCHAR(20)N
2LOCATION_NAMENVARCHAR(120)Y
3LOCATION_ADDRESSNVARCHAR(510)Y
4AREANVARCHAR(40)Y
5PHONENVARCHAR(40)Y
6FAXNVARCHAR(40)Y
7EMAILNVARCHAR(120)Y
8CONTACT_PERSONNVARCHAR(60)Y
9CREATE_BYCHAR(10)N
10CREATE_DATEDATETIMEN
11LAST_UPDATE_BYCHAR(10)N
12LAST_UPDATE_DATEDATETIMEN

Triggers
Sr.NameDescription
1Tr_GBLOCN
2Tr_GBLOCN_Deleting

Indexes
Sr.NameTypeColumns
1PK_GBLOCNClusteredLOCATION




Index
Table:[dbo].[GBPARM]

Description
Database Parameters Table

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2ENGLISH_NAMENVARCHAR(200)Y
3ALTERNATE_NAMENVARCHAR(100)Y
4ENGLISH_ADDRESSNVARCHAR(510)Y
5ALTERNATE_ADDRESSNVARCHAR(510)Y
6TEL_NONVARCHAR(40)Y
7FAX_NONVARCHAR(40)Y
8E_MAILNVARCHAR(80)Y
9CURRENCYNCHAR(6)Y
10COUNTRYNVARCHAR(100)N
11LOGOVARBINARYY
12EP_BACKGROUND_IMAGEVARBINARYY
13WEB_SITENVARCHAR(100)Y
14DATE_FORMATCHAR(10)Y
15QTY_DECIMALINTY
16ENGLISH_PRINTOUTINTY
17ERPRO_VERSIONCHAR(12)Y
18ERPRO_VERSION_DATEDATETIMEY
19HRPRO_VERSIONNVARCHAR(24)Y
20HRPRO_VERSION_DATEDATETIMEY
21EVENTLOG_RETAIN_DAYSSMALLINTY
22EE_AUTO_NOBITN
23NO_PREFIXVARCHAR(50)Y
24NEXT_NOINTY
25AM_AUTO_NOBITN
26AM_NO_PREFIXVARCHAR(50)Y
27AM_NEXT_NOINTY
28WC_LICENSE_KEYVARCHAR(-1)Y
29EP_LICENSE_KEYVARCHAR(-1)Y
30MEP_LICENSE_KEYVARCHAR(-1)Y
31SMTP_FROMNVARCHAR(100)N
32SMTP_FROM_NAMENVARCHAR(200)N
33SMTP_NETWORK_HOSTNVARCHAR(200)N
34SMTP_NETWORK_PORTINTN
35SMTP_USER_NAMENVARCHAR(100)N
36SMTP_PASSWORDNVARCHAR(100)N
37SMTP_ENABLESSLBITN
38SMTP_CCTOSENDERBITN
39SMTP_BCCTOSENDERBITN
40CREATE_BYCHAR(10)Y
41CREATE_DATEDATETIMEY
42LAST_UPDATE_BYCHAR(10)Y
43LAST_UPDATE_DATEDATETIMEY
44LAST_UPDATE_BY_PMCHAR(10)Y
45LAST_UPDATE_DATE_PMDATETIMEY
46LAST_UPDATE_BY_TMCHAR(10)Y
47LAST_UPDATE_DATE_TMDATETIMEY
48LAST_UPDATE_BY_AMCHAR(10)Y
49LAST_UPDATE_DATE_AMDATETIMEY
50LAST_UPDATE_BY_LMCHAR(10)Y
51LAST_UPDATE_DATE_LMDATETIMEY
52LAST_UPDATE_BY_UFCHAR(10)Y
53LAST_UPDATE_DATE_UFDATETIMEY
54LAST_UPDATE_BY_RSCHAR(10)Y
55LAST_UPDATE_DATE_RSDATETIMEY
56LAST_UPDATE_BY_EPCHAR(10)Y
57LAST_UPDATE_DATE_EPDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_GBPARM_AM_AUTO_NOAM_AUTO_NO((0))
2DF_GBPARM_COUNTRYCOUNTRY('')
3DF_GBPARM_EE_AUTO_NOEE_AUTO_NO((0))
4DF_GBPARM_SMTP_BCCTOSENDERSMTP_BCCTOSENDER((0))
5DF_GBPARM_SMTP_CCTOSENDERSMTP_CCTOSENDER((0))
6DF_GBPARM_SMTP_ENABLESSLSMTP_ENABLESSL((0))
7DF_GBPARM_SMTP_FROMSMTP_FROM('')
8DF_GBPARM_SMTP_FROM_NAMESMTP_FROM_NAME('')
9DF_GBPARM_SMTP_NETWORK_HOSTSMTP_NETWORK_HOST('')
10DF_GBPARM_SMTP_NETWORK_PORTSMTP_NETWORK_PORT((0))
11DF_GBPARM_SMTP_PASSWORDSMTP_PASSWORD('')
12DF_GBPARM_SMTP_USER_NAMESMTP_USER_NAME('')

Triggers
Sr.NameDescription
1Tr_GBPARM_Validating
2Tr_GBPARMChangeLog

Indexes
Sr.NameTypeColumns
1PK_GBPARMClusteredCOMPANY_CODE




Index
Table:[dbo].[GBQKTX]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1QT_KEYINTN
2QT_TEXTNVARCHAR(-1)N
3CREATE_BYCHAR(10)Y
4CREATE_DATEDATETIMEY
5LAST_UPDATE_BYCHAR(10)Y
6LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_GBQKTXClusteredQT_KEY




Index
Table:[dbo].[HRProMenu]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1LINE_NOINTN
2MENU_LEVELINTN
3FUNCTION_NAMENVARCHAR(240)N
4FUNCTION_IDNVARCHAR(20)N
5FUNCTION_TYPENCHAR(2)N
6MODULECHAR(2)N
7IS_WEBCLIENT_VISIBLEBITN
8IS_DESKTOP_VISIBLEBITN
9AUTO_UPDATECHAR(1)N
10IS_PARENTBITN
11PARENT_LINE_NOINTN

Default Constraints
Sr.NameColumnValue
1DF_HRProMenu_AUTO_UPDATEAUTO_UPDATE('Y')
2DF_HRProMenu_IS_DESKTOP_VISIBLEIS_DESKTOP_VISIBLE((0))
3DF_HRProMenu_IS_PARENTIS_PARENT((0))
4DF_HRProMenu_IS_WEBCLIENT_VISIBLEIS_WEBCLIENT_VISIBLE((0))
5DF_HRProMenu_MODULEMODULE('')
6DF_HRProMenu_PARENT_LINE_NOPARENT_LINE_NO((0))

Indexes
Sr.NameTypeColumns
1HRProMenu_Index1NonclusteredFUNCTION_ID
2PK_HRProMenuClusteredLINE_NO




Index
Table:[dbo].[IRDCategory]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IRD_CAT_CODEVARCHAR(2)N
2IRD_CAT_DESCRIPTIONNVARCHAR(510)N

Indexes
Sr.NameTypeColumns
1PK_IRDCategoryClusteredIRD_CAT_CODE




Index
Table:[dbo].[IRDCategoryM]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IRD_CAT_CODEVARCHAR(2)N
2IRD_CAT_DESCRIPTIONNVARCHAR(510)N

Indexes
Sr.NameTypeColumns
1PK_IRDCategoryMClusteredIRD_CAT_CODE




Index
Table:[dbo].[LeaveTypeByEEClass]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2LEAVE_CODENVARCHAR(24)N
3EE_CLASSNVARCHAR(24)N

Indexes
Sr.NameTypeColumns
1PK_LeaveTypeByEEClassClusteredID




Index
Table:[dbo].[NoticeBoard]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1NB_IDNUMERICN
2DEPT_CODENVARCHAR(24)N
3NB_DATEDATEN
4NB_SUBJECTNVARCHAR(510)N
5NB_BODYNVARCHAR(-1)N
6EFFECTIVE_FROMDATEY
7EFFECTIVE_TODATEY
8ATTACHMENT_NAMENVARCHAR(400)Y
9ATTACHMENT_IMAGEVARBINARYY
10ATTACHMENT_SIZEINTY
11EMAIL_SUBJECTNVARCHAR(100)N
12EMAIL_TONVARCHAR(-1)N
13EMAIL_CONTENTNVARCHAR(-1)N
14EMAIL_SEND_DATEDATETIMEY
15LAST_UPDATE_BYCHAR(12)N
16LAST_UPDATE_DATEDATETIMEN
17CREATE_BYCHAR(12)N
18CREATE_DATEDATETIMEN

Default Constraints
Sr.NameColumnValue
1DF_NoticeBoard_DEPT_CODEDEPT_CODE('')
2DF_NoticeBoard_EMAIL_CONTENTEMAIL_CONTENT('')
3DF_NoticeBoard_EMAIL_SUBJECTEMAIL_SUBJECT('')
4DF_NoticeBoard_EMAIL_TOEMAIL_TO('')

Triggers
Sr.NameDescription
1NoticeBoard_HandleReseedofIdentity

Indexes
Sr.NameTypeColumns
1PK_NoticeBoardClusteredNB_ID




Index
Table:[dbo].[PersonalOptions]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2UseridCHAR(10)Y
3SectionNVARCHAR(100)Y
4ValueNameNVARCHAR(4000)Y
5ValueDataNVARCHAR(-1)Y
6CREATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PersonalOptions_Index1NonclusteredUserid
2PersonalOptions_Index2NonclusteredSection
3PersonalOptions_Index3NonclusteredUserid
Section
ValueName
4PK_PersonalOptionsClusteredID




Index
Table:[dbo].[PFundTypeTable]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PFUND_TYPENVARCHAR(20)N

Indexes
Sr.NameTypeColumns
1PK_PFundTypeTableClusteredPFUND_TYPE




Index
Table:[dbo].[plATTD]

Description
Attendance Record Details

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2WORK_DATESMALLDATETIMEN
3PERIODCHAR(7)Y
4POSTEDINTY
5DEVICENVARCHAR(40)Y
6IN_TIME1NCHAR(10)Y
7OUT_TIME1NCHAR(10)Y
8IN_TIME2NCHAR(10)Y
9OUT_TIME2NCHAR(10)Y
10IN_TIME3NCHAR(10)Y
11OUT_TIME3NCHAR(10)Y
12IN_TIME4NCHAR(10)Y
13OUT_TIME4NCHAR(10)Y
14CARD_IN_TIME1NCHAR(10)Y
15CARD_OUT_TIME1NCHAR(10)Y
16CARD_IN_TIME2NCHAR(10)Y
17CARD_OUT_TIME2NCHAR(10)Y
18CARD_IN_TIME3NCHAR(10)Y
19CARD_OUT_TIME3NCHAR(10)Y
20CARD_IN_TIME4NCHAR(10)Y
21CARD_OUT_TIME4NCHAR(10)Y
22WORK_HRSDECIMAL(18,4)Y
23WORK_HRS_S1DECIMAL(18,4)Y
24WORK_HRS_S2DECIMAL(18,4)Y
25WORK_HRS_S3DECIMAL(18,4)Y
26REGULAR_HRSDECIMAL(18,4)Y
27OT_HRSDECIMAL(18,4)Y
28OT_HRS2DECIMAL(18,4)Y
29OT_HRS3DECIMAL(18,4)Y
30OT_HRS4DECIMAL(18,4)Y
31OT_HRS5DECIMAL(18,4)Y
32OT_HRS6DECIMAL(18,4)Y
33OT_DAYSINTY
34OT_DAYS2INTY
35OT_DAYS3INTY
36OT_DAYS4INTY
37OT_DAYS5INTY
38OT_DAYS6INTY
39SHORTDECIMAL(18,2)Y
40LATE_INDECIMAL(18,2)Y
41LUNCH_EARLY_OUTDECIMAL(18,2)Y
42LUNCH_LATE_INDECIMAL(18,2)Y
43LUNCH_SHORTDECIMAL(18,2)Y
44REST_EARLY_OUTDECIMAL(18,2)Y
45REST_LATE_INDECIMAL(18,2)Y
46REST_SHORTDECIMAL(18,2)Y
47EARLY_OUTDECIMAL(18,2)Y
48SHIFT_CODENVARCHAR(20)Y
49REMARKSNVARCHAR(8000)Y
50IS_ABSENTBITY
51CREATE_BYCHAR(10)Y
52CREATE_DATEDATETIMEY
53LAST_UPDATE_BYCHAR(10)Y
54LAST_UPDATE_DATEDATETIMEY
55RowVersionTIMESTAMPN

Default Constraints
Sr.NameColumnValue
1DF_plATTD_IS_ABSENTIS_ABSENT((0))
2DF_plATTD_WORK_HRS_S1WORK_HRS_S1((0))
3DF_plATTD_WORK_HRS_S2WORK_HRS_S2((0))
4DF_plATTD_WORK_HRS_S3WORK_HRS_S3((0))

Triggers
Sr.NameDescription
1plATTD_InsertUpdate

Indexes
Sr.NameTypeColumns
1PK_plATTDClusteredEE_NO
WORK_DATE
2plATTD_INDEX1NonclusteredEE_NO
3plATTD_INDEX10NonclusteredWORK_DATE
SHORT
4plATTD_INDEX11NonclusteredEE_NO
WORK_DATE
IS_ABSENT
5plATTD_INDEX16NonclusteredOT_HRS2
6plATTD_INDEX20NonclusteredEE_NO
LATE_IN
7plATTD_INDEX3NonclusteredPERIOD
8plATTD_INDEX4NonclusteredWORK_DATE
9plATTD_INDEX5NonclusteredEE_NO
PERIOD
10plATTD_INDEX7NonclusteredWORK_HRS
11plATTD_INDEX8NonclusteredWORK_DATE
LATE_IN
12plATTD_INDEX9NonclusteredWORK_DATE
EARLY_OUT




Index
Table:[dbo].[plATTLog]

Description
Attendance Raw Data Table

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2TerminalSMALLINTY
3DeviceNVARCHAR(40)Y
4EnrollNoINTY
5BADGE_NONCHAR(40)Y
6EE_NONVARCHAR(20)N
7chkYearSMALLINTN
8chkMonthSMALLINTN
9chkDaySMALLINTN
10chkHourSMALLINTN
11chkMinuteSMALLINTN
12chkSecondSMALLINTY
13VerifyModeSMALLINTY
14InOutModeSMALLINTN
15WorkCodeSMALLINTY
16RemarksNVARCHAR(8000)Y
17POSTEDSMALLINTY
18CREATE_BYCHAR(10)Y
19CREATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plATTLogClusteredId
2plATTLog_Index1NonclusteredEE_NO
3plATTLog_Index2NonclusteredEE_NO
chkYear
chkMonth
chkDay
chkHour
chkMinute
chkSecond
InOutMode




Index
Table:[dbo].[plATTPeriod]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMDATEY
3PERIOD_TODATEY
4CREATE_BYCHAR(10)N
5CREATE_DATEDATETIMEN
6LAST_UPDATE_BYCHAR(10)Y
7LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plATTPeriodClusteredPERIOD
2plATTPeriod_INDEX1NonclusteredPERIOD_FROM
3plATTPeriod_INDEX2NonclusteredPERIOD_TO




Index
Table:[dbo].[plATTRaw]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2DeviceNVARCHAR(100)Y
3BADGE_NONCHAR(40)Y
4EE_NONVARCHAR(20)N
5chkDateTimeDATETIMEY
6chkYearSMALLINTN
7chkMonthSMALLINTN
8chkDaySMALLINTN
9chkHourSMALLINTN
10chkMinuteSMALLINTN
11chkSecondSMALLINTY
12InOutModeSMALLINTN
13RemarksNVARCHAR(8000)Y
14CREATE_BYCHAR(10)Y
15CREATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plATTRawClusteredRowSerial
2plATTRaw_Index1NonclusteredEE_NO
chkYear
chkMonth
chkDay
3plATTRaw_Index2NonclusteredInOutMode
4plATTRaw_Index3NonclusteredEE_NO
chkYear
chkMonth
chkDay
chkHour
chkMinute
chkSecond
InOutMode




Index
Table:[dbo].[plAutoPayClass]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1AUTOPAY_CLASSNVARCHAR(24)N
2AUTOPAY_CLASS_NAMENVARCHAR(120)N
3AUTOPAY_FILE_FORMATINTN
4HSBC_ACCOUNT_CODENVARCHAR(24)Y
5HSBC_APC_NONVARCHAR(6)Y
6CITI_PCODENVARCHAR(6)Y
7CITI_ACNONVARCHAR(20)Y
8CITI_CLIDNVARCHAR(16)Y
9CITI_CLNAMNVARCHAR(70)Y
10DBS_BATNONVARCHAR(10)Y
11DBS_ACNONVARCHAR(30)Y
12DBS_ACNAMNVARCHAR(40)Y
13DBS_BATNAMNVARCHAR(50)Y
14SC_ACCOUNT_NONVARCHAR(28)Y
15AUTOPAY_ACCOUNT_NO1NVARCHAR(40)Y
16AUTOPAY_ACCOUNT_NO2NVARCHAR(40)Y
17AUTOPAY_ACCOUNT_NAMENVARCHAR(100)Y
18CREATE_BYCHAR(10)N
19CREATE_DATEDATETIMEN
20LAST_UPDATE_BYCHAR(10)Y
21LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plAUTOPAYCLASS_AUTOPAY_CLASS_NAMEAUTOPAY_CLASS_NAME('')

Triggers
Sr.NameDescription
1Tr_plAutopayClass
2Tr_plAutopayClass_Deleting
3Tr_plAutopayClass_Validating

Indexes
Sr.NameTypeColumns
1PK_plAUTOPAYCLASSClusteredAUTOPAY_CLASS




Index
Table:[dbo].[plCLEntitlementApply]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3FR_DATESMALLDATETIMEY
4TO_DATESMALLDATETIMEY
5FR_TIMECHAR(5)Y
6TO_TIMECHAR(5)Y
7AMPMNCHAR(2)Y
8DAYSDECIMAL(12,4)Y
9HOURSDECIMAL(12,4)Y
10COMPENSATED_BYINTY
11OVERTIME_AT_INDINTY
12REMARKSNVARCHAR(8000)Y
13APPROVED_STSNVARCHAR(40)Y
14PARTIALLY_APPROVED_BYNVARCHAR(40)Y
15PARTIALLY_APPROVED_DATESMALLDATETIMEY
16MAJORITY_APPROVED_BYNVARCHAR(40)Y
17MAJORITY_APPROVED_DATESMALLDATETIMEY
18ACTION_BYCHAR(10)Y
19ACTION_DATEDATETIMEY
20CHOSEN_EMAILNVARCHAR(20)Y
21ATTACHMENT_NAMENVARCHAR(400)Y
22ATTACHMENT_IMAGEVARBINARYY
23CREATE_BYCHAR(10)N
24CREATE_DATEDATETIMEN
25LAST_UPDATE_BYCHAR(10)Y
26LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plCLEntitlementApply_OVERTIME_ON_INDOVERTIME_AT_IND((0))

Triggers
Sr.NameDescription
1plCLEntitlementApply_HandleReseedofIdentity
2Tr_plCLEntitlementApply

Indexes
Sr.NameTypeColumns
1PK_plCLEntitlementApplyClusteredRowSerial
2plCLEntitlementApply_Index1NonclusteredEE_NO
FR_DATE
DAYS
HOURS
COMPENSATED_BY
OVERTIME_AT_IND
APPROVED_STS
3plCLEntitlementApply_Index2NonclusteredCREATE_DATE
4plCLEntitlementApply_Index3NonclusteredAPPROVED_STS




Index
Table:[dbo].[plCompanyProperty]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2EE_NONVARCHAR(20)N
3PROPERTY_CODENVARCHAR(40)Y
4PROPERTY_DESCRIPTIONNVARCHAR(200)Y
5SERIAL_NONVARCHAR(60)Y
6START_DATEDATETIMEY
7RETURN_DATEDATETIMEY
8STATUSNVARCHAR(40)Y
9REMARKSNVARCHAR(510)Y
10CREATE_BYCHAR(10)Y
11CREATE_DATEDATETIMEY
12LAST_UPDATE_BYCHAR(10)Y
13LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plCompanyPropertyClusteredTS_KEY




Index
Table:[dbo].[plCSCR]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1COST_CENTRENVARCHAR(60)N
2AUTHORIZEDBITN
3DESCRIPTIONNVARCHAR(120)N
4REMARKSNVARCHAR(1024)Y
5AUTOPAY_BANK_ACCOUNTVARCHAR(10)Y
6CHEQUE_BANK_ACCOUNTVARCHAR(10)Y
7MPF_BANK_ACCOUNTVARCHAR(10)Y
8SALARY_ACCOUNTVARCHAR(10)Y
9OT_ACCOUNTVARCHAR(10)Y
10LATE_DEDUCTION_ACCOUNTVARCHAR(10)Y
11ALLOWANCE_ACCOUNTVARCHAR(10)Y
12DOUBLE_PAY_ACCOUNTVARCHAR(10)Y
13BONUS_ACCOUNTVARCHAR(10)Y
14NOPAY_ACCOUNTVARCHAR(10)Y
15WAGES_IN_LIEU_ACCOUNTVARCHAR(10)Y
16LSP_SP_ACCOUNTVARCHAR(10)Y
17PAY_TYPE1_ACCOUNTVARCHAR(10)Y
18PAY_TYPE2_ACCOUNTVARCHAR(10)Y
19PAY_TYPE3_ACCOUNTVARCHAR(10)Y
20PAY_TYPE4_ACCOUNTVARCHAR(10)Y
21PAY_TYPE5_ACCOUNTVARCHAR(10)Y
22PAY_TYPE6_ACCOUNTVARCHAR(10)Y
23PAY_TYPE7_ACCOUNTVARCHAR(10)Y
24PAY_TYPE8_ACCOUNTVARCHAR(10)Y
25PAY_TYPE9_ACCOUNTVARCHAR(10)Y
26PAY_TYPE10_ACCOUNTVARCHAR(10)Y
27PAY_TYPE11_ACCOUNTVARCHAR(10)Y
28PAY_TYPE12_ACCOUNTVARCHAR(10)Y
29PAY_TYPE13_ACCOUNTVARCHAR(10)Y
30PAY_TYPE14_ACCOUNTVARCHAR(10)Y
31PAY_TYPE15_ACCOUNTVARCHAR(10)Y
32EEC_ACCOUNTVARCHAR(50)Y
33ERC_ACCOUNTVARCHAR(50)Y
34AUTOPAY_BANK_SUBACCOUNT1VARCHAR(12)Y
35CHEQUE_BANK_SUBACCOUNT1VARCHAR(12)Y
36MPF_BANK_SUBACCOUNT1VARCHAR(12)Y
37SALARY_SUBACCOUNT1VARCHAR(12)Y
38OT_SUBACCOUNT1VARCHAR(12)Y
39LATE_DEDUCTION_SUBACCOUNT1VARCHAR(12)Y
40ALLOWANCE_SUBACCOUNT1VARCHAR(12)Y
41DOUBLE_PAY_SUBACCOUNT1VARCHAR(12)Y
42BONUS_SUBACCOUNT1VARCHAR(12)Y
43NOPAY_SUBACCOUNT1VARCHAR(12)Y
44WAGES_IN_LIEU_SUBACCOUNT1VARCHAR(12)Y
45LSP_SP_SUBACCOUNT1VARCHAR(12)Y
46PAY_TYPE1_SUBACCOUNT1VARCHAR(12)Y
47PAY_TYPE2_SUBACCOUNT1VARCHAR(12)Y
48PAY_TYPE3_SUBACCOUNT1VARCHAR(12)Y
49PAY_TYPE4_SUBACCOUNT1VARCHAR(12)Y
50PAY_TYPE5_SUBACCOUNT1VARCHAR(12)Y
51PAY_TYPE6_SUBACCOUNT1VARCHAR(12)Y
52PAY_TYPE7_SUBACCOUNT1VARCHAR(12)Y
53PAY_TYPE8_SUBACCOUNT1VARCHAR(12)Y
54PAY_TYPE9_SUBACCOUNT1VARCHAR(12)Y
55PAY_TYPE10_SUBACCOUNT1VARCHAR(12)Y
56PAY_TYPE11_SUBACCOUNT1VARCHAR(12)Y
57PAY_TYPE12_SUBACCOUNT1VARCHAR(12)Y
58PAY_TYPE13_SUBACCOUNT1VARCHAR(12)Y
59PAY_TYPE14_SUBACCOUNT1VARCHAR(12)Y
60PAY_TYPE15_SUBACCOUNT1VARCHAR(12)Y
61EEC_SUBACCOUNT1VARCHAR(12)Y
62ERC_SUBACCOUNT1VARCHAR(12)Y
63CREATE_BYCHAR(10)N
64CREATE_DATEDATETIMEN
65LAST_UPDATE_BYCHAR(10)Y
66LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_PLCSCR_AUTHORIZEDAUTHORIZED((0))
2DF_PLCSCR_LSP_SP_ACCOUNTLSP_SP_ACCOUNT('')
3DF_PLCSCR_LSP_SP_SUBACCOUNT1LSP_SP_SUBACCOUNT1('')

Triggers
Sr.NameDescription
1Tr_PLCSCR
2Tr_PLCSCR_Deleting
3Tr_PLCSCR_Validating

Indexes
Sr.NameTypeColumns
1PK_PLCSCRClusteredCOST_CENTRE




Index
Table:[dbo].[plDate]

Description
Date Sequence Table

Table Columns
Sr.NameDatatypeNullableDescription
1HR_DateDATEN

Indexes
Sr.NameTypeColumns
1PK_plDateClusteredHR_Date




Index
Table:[dbo].[plDeduction]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1DEDUCTION_TYPENVARCHAR(20)N
2DESCRIPTIONNVARCHAR(100)N
3BASE_ONVARCHAR(20)N
4FACTORDECIMAL(18,10)Y
5FIXED_AMOUNTDECIMAL(18,2)Y
6FORMULANVARCHAR(4000)Y
7TOLERANCESMALLINTY
8DEDUCTION_AMOUNT_EXCLUDED_THIS_TOLERANCE_MINUTESBITN
9MAXIMUM_DEDUCTION_AMOUNT_PER_MONTHDECIMAL(18,2)Y
10CREATE_BYCHAR(10)N
11CREATE_DATEDATETIMEN
12LAST_UPDATE_BYCHAR(10)Y
13LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plDeduction_BASE_ONBASE_ON('Formula')
2DF_plDeduction_DEDUCTION_AMOUNT_EXCLUDED_THIS_TOLERANCE_MINUTESDEDUCTION_AMOUNT_EXCLUDED_THIS_TOLERANCE_MINUTES((0))
3DF_plDeduction_DESCRIPTIONDESCRIPTION('')
4DF_plDeduction_FACTORFACTOR((0))
5DF_plDeduction_FIXED_AMOUNTFIXED_AMOUNT((0))

Triggers
Sr.NameDescription
1Tr_plDeduction
2Tr_plDeduction_Deleting
3Tr_plDeduction_Validating

Indexes
Sr.NameTypeColumns
1PK_plDeductionClusteredDEDUCTION_TYPE




Index
Table:[dbo].[plDept]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1DEPT_CODENVARCHAR(24)N
2AUTHORIZEDBITN
3DEPT_NAMENVARCHAR(120)Y
4REFERENCENVARCHAR(40)Y
5MANAGERNVARCHAR(20)Y
6EXPECTED_EMPLOYEESINTY
7NOTESNVARCHAR(-1)Y
8CREATE_BYCHAR(10)N
9CREATE_DATEDATETIMEN
10LAST_UPDATE_BYCHAR(10)Y
11LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plDept_AUTHORIZEDAUTHORIZED((0))

Triggers
Sr.NameDescription
1Tr_plDept
2Tr_plDept_Deleting

Indexes
Sr.NameTypeColumns
1PK_plDEPTClusteredDEPT_CODE
2plDept_Index1NonclusteredDEPT_NAME




Index
Table:[dbo].[plDivision]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1DIVISION_CODENVARCHAR(24)N
2AUTHORIZEDBITN
3DIVISION_NAMENVARCHAR(120)Y
4REFERENCENVARCHAR(40)Y
5MANAGERNVARCHAR(20)Y
6EXPECTED_EMPLOYEESINTY
7NOTESNVARCHAR(-1)Y
8CREATE_BYCHAR(10)N
9CREATE_DATEDATETIMEN
10LAST_UPDATE_BYCHAR(10)Y
11LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plDivision_AUTHORIZEDAUTHORIZED((0))

Triggers
Sr.NameDescription
1Tr_plDivision
2Tr_plDivision_Deleting

Indexes
Sr.NameTypeColumns
1PK_plDivisionClusteredDIVISION_CODE




Index
Table:[dbo].[plEEChangeLog]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialINTN
2EE_NONVARCHAR(20)Y
3EventDateTimeDATETIMEN
4UserIDCHAR(10)N
5FieldNVARCHAR(100)Y
6IsSalaryINTY
7OriginalValuesNVARCHAR(8000)Y
8NewValuesNVARCHAR(8000)Y

Indexes
Sr.NameTypeColumns
1PK_plEEChangeLogClusteredRowSerial




Index
Table:[dbo].[plEECLASS]

Description
Employee Class Table

Table Columns
Sr.NameDatatypeNullableDescription
1EE_CLASSNVARCHAR(24)N
2EE_CLASS_NAMENVARCHAR(120)N
3SALARY_BYNCHAR(2)Y
4OT_TYPENVARCHAR(20)N
5OT_TYPE2NVARCHAR(20)Y
6OT_TYPE3NVARCHAR(20)Y
7OT_TYPE4NVARCHAR(20)Y
8OT_TYPE5NVARCHAR(20)Y
9OT_TYPE6NVARCHAR(20)Y
10OT_TYPE7NVARCHAR(20)Y
11OT_TYPE8NVARCHAR(20)Y
12DEDUCTION_TYPENVARCHAR(20)Y
13SICK_RATESMALLINTY
14SICK_RATE2SMALLINTY
15MATERNITYLEAVE_RATESMALLINTY
16WORK_HRS_TYPENVARCHAR(20)Y
17ROSTER_CODENVARCHAR(20)Y
18COST_CENTRENVARCHAR(60)Y
19ENTITLEMENT_CODENVARCHAR(24)Y
20INS_PLANNVARCHAR(24)Y
21INS_GRADENVARCHAR(24)Y
22HOLIDAY_TYPEVARCHAR(3)Y
23MPF_SP_CODENVARCHAR(20)Y
24PFUND_TYPENVARCHAR(20)Y
25PFUND_EEDECIMAL(23,9)Y
26PFUND_ERDECIMAL(23,9)Y
27Voluntary_EEDECIMAL(23,9)Y
28Voluntary_ERDECIMAL(23,9)Y
29EEVC_SIGNCHAR(1)Y
30ERVC_SIGNCHAR(1)Y
31PF_PLAN_NONVARCHAR(40)Y
32PF_BENEFIT_PLAN_NONVARCHAR(12)Y
33PF_CERT_NONVARCHAR(40)Y
34USER01NVARCHAR(100)Y
35USER02NVARCHAR(100)Y
36USER03NVARCHAR(100)Y
37USER04NVARCHAR(100)Y
38USER05NVARCHAR(100)Y
39USER06NUMERICY
40USER07NUMERICY
41USER08NUMERICY
42USER09NUMERICY
43USER10NUMERICY
44USER11DATETIMEY
45USER12DATETIMEY
46USER13DATETIMEY
47USER14DATETIMEY
48USER15DATETIMEY
49USER16BITN
50USER17BITN
51USER18BITN
52USER19BITN
53USER20BITN
54USER21NVARCHAR(40)Y
55USER22NVARCHAR(40)Y
56USER23NVARCHAR(40)Y
57USER24NVARCHAR(40)Y
58USER25NVARCHAR(40)Y
59PRORATED_BYNCHAR(2)Y
60SATURDAYNCHAR(2)Y
61AUTOPAY_FILE_FORMATINTY
62HSBC_ACCOUNT_CODENVARCHAR(24)Y
63HSBC_APC_NONVARCHAR(6)Y
64CITI_PCODENVARCHAR(6)Y
65CITI_ACNONVARCHAR(20)Y
66CITI_CLIDNVARCHAR(16)Y
67CITI_CLNAMNVARCHAR(70)Y
68DBS_BATNONVARCHAR(10)Y
69DBS_ACNONVARCHAR(30)Y
70DBS_ACNAMNVARCHAR(40)Y
71DBS_BATNAMNVARCHAR(50)Y
72SC_ACCOUNT_NONVARCHAR(28)Y
73AUTOPAY_ACCOUNT_NO1NVARCHAR(40)Y
74AUTOPAY_ACCOUNT_NO2NVARCHAR(40)Y
75AUTOPAY_ACCOUNT_NAMENVARCHAR(100)Y
76ENABLE_AUTOBONUSBITN
77AUTOBONUS_PAY_TYPEINTN
78AUTOBONUS_PAY_TYPE_TABLE_DESCNVARCHAR(100)N
79AUTOBONUS_START_MONTHINTN
80AUTOBONUS_RELEASE_MONTHINTN
81AUTOBONUS_EXCLUDE_NEW_EMPLOYEEBITN
82AUTOBONUS_EXCLUDE_PROBATION_DATEBITN
83AUTOBONUS_FORMULANVARCHAR(4000)Y
84HOLIDAYPAY_3_MONTHSINTN
85NO_PAY_RATE_FORMULANVARCHAR(400)N
86CREATE_BYCHAR(10)N
87CREATE_DATEDATETIMEN
88LAST_UPDATE_BYCHAR(10)Y
89LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plEECLASS_AUTO_BONUS_FORMULAAUTOBONUS_FORMULA('')
2DF_plEECLASS_AUTOBONUS_EXCLUDE_NEW_EMPLOYEEAUTOBONUS_EXCLUDE_NEW_EMPLOYEE((1))
3DF_plEECLASS_AUTOBONUS_EXCLUDE_PROBATION_DATEAUTOBONUS_EXCLUDE_PROBATION_DATE((1))
4DF_plEECLASS_AUTOBONUS_PAY_TYPEAUTOBONUS_PAY_TYPE((0))
5DF_plEECLASS_AUTOBONUS_PAY_TYPE_TABLE_DESCAUTOBONUS_PAY_TYPE_TABLE_DESC('')
6DF_plEECLASS_AUTOBONUS_RELEASE_MONTHAUTOBONUS_RELEASE_MONTH((2))
7DF_plEECLASS_AUTOBONUS_START_MONTHAUTOBONUS_START_MONTH((1))
8DF_plEECLASS_EE_CLASS_NAMEEE_CLASS_NAME('')
9DF_plEECLASS_EEVC_SIGNEEVC_SIGN('$')
10DF_plEECLASS_ENABLE_AUTOBONUSENABLE_AUTOBONUS((0))
11DF_plEECLASS_ERVC_SIGNERVC_SIGN('$')
12DF_plEECLASS_HOLIDAY_TYPEHOLIDAY_TYPE('P')
13DF_plEECLASS_HOLIDAYPAY_3_MONTHSHOLIDAYPAY_3_MONTHS((0))
14DF_plEECLASS_NO_PAY_RATE_FORMULANO_PAY_RATE_FORMULA('')
15DF_plEECLASS_OT_TYPEOT_TYPE('')
16DF_plEECLASS_PFUND_EEPFUND_EE((599))
17DF_plEECLASS_PFUND_ERPFUND_ER((599))
18DF_plEECLASS_PFUND_TYPEPFUND_TYPE(N'MPF')
19DF_plEECLASS_SALARY_BYSALARY_BY(N'M')
20DF_plEECLASS_USER16USER16((0))
21DF_plEECLASS_USER17USER17((0))
22DF_plEECLASS_USER18USER18((0))
23DF_plEECLASS_USER19USER19((0))
24DF_plEECLASS_USER20USER20((0))

Triggers
Sr.NameDescription
1Tr_plEECLASS
2Tr_plEEClass_Deleting
3Tr_plEEClass_Validating

Indexes
Sr.NameTypeColumns
1PK_plEECLASSClusteredEE_CLASS




Index
Table:[dbo].[plEECostCentre]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2EE_NONVARCHAR(20)N
3START_DATESMALLDATETIMEY
4COST_CENTRENVARCHAR(60)N
5PERCENTAGEDECIMAL(18,6)N
6CREATE_BYCHAR(10)Y
7CREATE_DATEDATETIMEY
8LAST_UPDATE_BYCHAR(10)Y
9LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plEECostCentreClusteredTS_KEY




Index
Table:[dbo].[plEEPeriod]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PERIOD_TYPECHAR(1)N
2WORK_HR_OR_ROSTERCHAR(1)N
3WORK_HRS_ROSTER_CODENVARCHAR(20)N
4PERIODCHAR(7)N
5PERIOD_FROMDATEY
6PERIOD_TODATEY

Default Constraints
Sr.NameColumnValue
1DF_plEEPeriod_WORK_HR_OR_ROSTERWORK_HR_OR_ROSTER('')

Indexes
Sr.NameTypeColumns
1PK_plEEPeriodClusteredPERIOD_TYPE
WORK_HR_OR_ROSTER
WORK_HRS_ROSTER_CODE
PERIOD
2plEEPeriod_INDEX1NonclusteredPERIOD_TYPE
WORK_HR_OR_ROSTER
WORK_HRS_ROSTER_CODE
PERIOD_TO




Index
Table:[dbo].[plEEUpdate]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2POSTEDBITN
3EE_NONVARCHAR(20)N
4MARITALINTY
5RES_ADDRESSNVARCHAR(180)Y
6AREA_CODENVARCHAR(2)Y
7COR_ADDRESSNVARCHAR(180)Y
8HOME_PHONENVARCHAR(60)Y
9MOBILENVARCHAR(60)Y
10PERSONAL_EMAILVARCHAR(50)Y
11SP_SNAMENVARCHAR(40)Y
12SP_ONAMENVARCHAR(40)Y
13SP_HKIDNCHAR(22)Y
14SP_PASSPTNVARCHAR(80)Y
15EMERGENCY_CONTACT_NAMENVARCHAR(100)Y
16EMERGENCY_CONTACT_RELATIONNVARCHAR(60)Y
17EMERGENCY_CONTACT_PHONENVARCHAR(60)Y
18EMERGENCY_CONTACT_MOBILENVARCHAR(60)Y
19IRD_TAX_FILE_NONVARCHAR(26)Y
20BANK_ACNVARCHAR(40)Y
21PAYEE_NAMENVARCHAR(120)Y
22PHOTOVARBINARYY
23OLD_MARITALINTY
24OLD_RES_ADDRESSNVARCHAR(180)Y
25OLD_AREA_CODENVARCHAR(2)Y
26OLD_COR_ADDRESSNVARCHAR(180)Y
27OLD_HOME_PHONENVARCHAR(60)Y
28OLD_MOBILENVARCHAR(60)Y
29OLD_PERSONAL_EMAILVARCHAR(50)Y
30OLD_SP_SNAMENVARCHAR(40)Y
31OLD_SP_ONAMENVARCHAR(40)Y
32OLD_SP_HKIDNCHAR(22)Y
33OLD_SP_PASSPTNVARCHAR(80)Y
34OLD_EMERGENCY_CONTACT_NAMENVARCHAR(100)Y
35OLD_EMERGENCY_CONTACT_RELATIONNVARCHAR(60)Y
36OLD_EMERGENCY_CONTACT_PHONENVARCHAR(60)Y
37OLD_EMERGENCY_CONTACT_MOBILENVARCHAR(60)Y
38OLD_IRD_TAX_FILE_NONVARCHAR(26)Y
39OLD_PHOTOVARBINARYY
40OLD_BANK_ACNVARCHAR(40)Y
41OLD_PAYEE_NAMENVARCHAR(120)Y
42CREATE_BYNVARCHAR(20)N
43CREATE_DATESMALLDATETIMEN
44APPROVED_STSNVARCHAR(16)Y
45ACTION_BYNVARCHAR(20)Y
46ACTION_DATESMALLDATETIMEY
47ATTACHMENT_NAMENVARCHAR(400)Y
48ATTACHMENT_IMAGEVARBINARYY
49ATTACHMENT_DESCRIPTIONNVARCHAR(510)Y
50IS_UPDATE_QUALI_SKILLBITN
51QUALI_SKILL_TS_KEYINTY
52QUALI_SKILL_UPDATE_ACTIONNVARCHAR(2)Y
53QUALI_SKILL_COURSE_NAMENVARCHAR(200)Y
54QUALI_SKILL_START_DATENVARCHAR(40)Y
55QUALI_SKILL_END_DATENVARCHAR(40)Y
56QUALI_SKILL_QUALIFICATIONNVARCHAR(200)Y
57QUALI_SKILL_INSTITUTIONNVARCHAR(400)Y
58QUALI_SKILL_MEMONVARCHAR(2048)Y
59IS_UPDATE_EMPLOYMENT_HISTORYBITN
60EMPLOYMENT_HISTORY_UPDATE_ACTIONNVARCHAR(2)Y
61EMPLOYMENT_HISTORY_TS_KEYINTY
62EMPLOYMENT_HISTORY_PREVIOUS_EMPLOYERNVARCHAR(100)Y
63EMPLOYMENT_HISTORY_POSITIONNVARCHAR(200)Y
64EMPLOYMENT_HISTORY_PROJECTNVARCHAR(200)Y
65EMPLOYMENT_HISTORY_PROJECT_DESCRIPTIONNVARCHAR(8000)Y
66EMPLOYMENT_HISTORY_ENDING_SALARYDECIMAL(23,2)Y
67EMPLOYMENT_HISTORY_WORKED_PERIODNVARCHAR(100)Y
68EMPLOYMENT_HISTORY_REASON_FOR_LEAVINGNVARCHAR(100)Y
69REPLY_SUBJECTNVARCHAR(1000)Y
70REPLY_CONTENTNVARCHAR(-1)Y

Default Constraints
Sr.NameColumnValue
1DF_plEEUpdate_IS_UPDATE_EMPLOYMENT_HISTORYIS_UPDATE_EMPLOYMENT_HISTORY((0))
2DF_plEEUpdate_IsUpdateQualiSkillIS_UPDATE_QUALI_SKILL((0))
3DF_plEEUpdate_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1plEEUpdate_HandleReseedofIdentity

Indexes
Sr.NameTypeColumns
1PK_plEEUpdateClusteredRowSerial




Index
Table:[dbo].[plEmployee]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2DEPT_CODENVARCHAR(24)N
3DIVISION_CODENVARCHAR(24)Y
4EMPLOYER_CODENVARCHAR(24)N
5BIRTHDATESMALLDATETIMEY
6PAYEE_NAMENVARCHAR(120)Y
7OT_TYPENVARCHAR(20)N
8JOIN_DATESMALLDATETIMEN
9GROUP_JOIN_DATESMALLDATETIMEY
10ENTITLEMENT_CODENVARCHAR(24)N
11WORK_HRS_TYPENVARCHAR(20)Y
12ROSTER_CODENVARCHAR(20)Y
13BADGE_NONVARCHAR(40)Y
14CERT_NONVARCHAR(20)Yobsoleted
15CHI_NAMENVARCHAR(20)Y
16SURNAMENVARCHAR(40)N
17OTHERNAMENVARCHAR(110)N
18CALL_NAMENVARCHAR(60)Y
19SALUTATIONNVARCHAR(20)Y
20HKIDNCHAR(22)Y
21PASSPORTNVARCHAR(80)Y
22SEXCHAR(1)N
23MARITALINTN
24PHONENVARCHAR(60)Y
25EMAILNVARCHAR(100)Y
26PERSONAL_EMAILNVARCHAR(100)Y
27MOBILENVARCHAR(60)Y
28POSITIONNVARCHAR(200)Y
29EE_CLASSNVARCHAR(24)Y
30AUTOPAY_CLASSNVARCHAR(24)Y
31SP_SNAMENVARCHAR(40)Y
32SP_ONAMENVARCHAR(40)Y
33SP_HKIDNCHAR(22)Y
34NATIONALITYNVARCHAR(60)Y
35SP_PASSPTNVARCHAR(80)Y
36RES_ADDRESSNVARCHAR(180)Y
37AREA_CODENVARCHAR(2)Y
38COR_ADDRESSNVARCHAR(180)Y
39HOME_PHONENVARCHAR(60)Y
40OT_TYPE2NVARCHAR(20)Y
41OT_TYPE3NVARCHAR(20)Y
42OT_TYPE4NVARCHAR(20)Y
43OT_TYPE5NVARCHAR(20)Y
44OT_TYPE6NVARCHAR(20)Y
45OT_TYPE7NVARCHAR(20)Y
46OT_TYPE8NVARCHAR(20)Y
47DEDUCTION_TYPENVARCHAR(20)Y
48COST_CENTRENVARCHAR(60)Y
49PF_DATESMALLDATETIMEY
50PROBATION_END_DATESMALLDATETIMEY
51CONTRACT_END_DATESMALLDATETIMEY
52TERMN_DATESMALLDATETIMEY
53REASON_CODENVARCHAR(6)Y
54TERMN_REASONNVARCHAR(160)Y
55RESIGNATION_DATESMALLDATETIMEY
56LAST_APPRAISAL_DATESMALLDATETIMEY
57NEXT_APPRAISAL_DATESMALLDATETIMEY
58WORK_LOCATIONNVARCHAR(20)Y
59REPORT_TONVARCHAR(20)Y
60EMERGENCY_CONTACT_NAMENVARCHAR(100)Y
61EMERGENCY_CONTACT_RELATIONNVARCHAR(60)Y
62EMERGENCY_CONTACT_PHONENVARCHAR(60)Y
63EMERGENCY_CONTACT_MOBILENVARCHAR(60)Y
64PRINT_IR56ENCHAR(2)Y
65PRINT_IR56FGNCHAR(2)Y
66AUTOPAYNCHAR(2)Y
67BANK_CODECHAR(5)Y
68BANK_ACNVARCHAR(40)Y
69MPF_SP_CODENVARCHAR(20)Y
70SALARY_BYNCHAR(2)Y
71BASIC_SALDECIMAL(23,9)Y
72ALLOWANCEDECIMAL(23,9)Y
73ALLOWANCE2DECIMAL(23,9)Y
74BONUSDECIMAL(23,9)Y
75PAY_TYPE1_AMT_FORMULANVARCHAR(400)N
76PAY_TYPE2_AMT_FORMULANVARCHAR(400)N
77PAY_TYPE3_AMT_FORMULANVARCHAR(400)N
78PAY_TYPE4_AMT_FORMULANVARCHAR(400)N
79PAY_TYPE5_AMT_FORMULANVARCHAR(400)N
80PAY_TYPE6_AMT_FORMULANVARCHAR(400)N
81PAY_TYPE7_AMT_FORMULANVARCHAR(400)N
82PAY_TYPE8_AMT_FORMULANVARCHAR(400)N
83PAY_TYPE9_AMT_FORMULANVARCHAR(400)N
84PAY_TYPE10_AMT_FORMULANVARCHAR(400)N
85PAY_TYPE11_AMT_FORMULANVARCHAR(400)N
86PAY_TYPE12_AMT_FORMULANVARCHAR(400)N
87PAY_TYPE13_AMT_FORMULANVARCHAR(400)N
88PAY_TYPE14_AMT_FORMULANVARCHAR(400)N
89PAY_TYPE15_AMT_FORMULANVARCHAR(400)N
90PAY_TYPE1_DESCNVARCHAR(100)Y
91PAY_TYPE2_DESCNVARCHAR(100)Y
92PAY_TYPE3_DESCNVARCHAR(100)Y
93PAY_TYPE4_DESCNVARCHAR(100)Y
94PAY_TYPE5_DESCNVARCHAR(100)Y
95PAY_TYPE6_DESCNVARCHAR(100)Y
96PAY_TYPE7_DESCNVARCHAR(100)Y
97PAY_TYPE8_DESCNVARCHAR(100)Y
98PAY_TYPE9_DESCNVARCHAR(100)Y
99PAY_TYPE10_DESCNVARCHAR(100)Y
100PAY_TYPE11_DESCNVARCHAR(100)Y
101PAY_TYPE12_DESCNVARCHAR(100)Y
102PAY_TYPE13_DESCNVARCHAR(100)Y
103PAY_TYPE14_DESCNVARCHAR(100)Y
104PAY_TYPE15_DESCNVARCHAR(100)Y
105HOURLY_RATE1DECIMAL(23,9)Y
106HOURLY_RATE2DECIMAL(23,9)Y
107HOURLY_RATE3DECIMAL(23,9)Y
108HOURLY_RATE4DECIMAL(23,9)Y
109HOURLY_RATE5DECIMAL(23,9)Y
110HOURLY_RATE6DECIMAL(23,9)Y
111SICK_RATEINTY
112SICK_RATE2INTY
113MATERNITYLEAVE_RATEINTY
114PFUND_TYPENVARCHAR(20)N
115PFUND_EEDECIMAL(23,9)Y
116PFUND_ERDECIMAL(23,9)Y
117Voluntary_EEDECIMAL(23,9)Y
118Voluntary_ERDECIMAL(23,9)Y
119EEVC_SIGNCHAR(1)Y
120ERVC_SIGNCHAR(1)Y
121PF_PLAN_NONVARCHAR(40)Y
122PF_BENEFIT_PLAN_NONVARCHAR(12)Y
123PF_CERT_NONVARCHAR(40)Y
124IRD_TAX_FILE_NONVARCHAR(26)Y
125IRD_REMARKSNVARCHAR(120)Y
126MAIN_ERNVARCHAR(60)Y
127QUARTERNCHAR(2)Y
128QUAR_ADDRESSNVARCHAR(220)Y
129QUAR_NATNVARCHAR(38)Y
130QUAR_FMSMALLDATETIMEY
131QUAR_TOSMALLDATETIMEY
132QUAR_RENT1DECIMAL(18,2)Y
133QUAR_RENT2DECIMAL(18,2)Y
134QUAR_RENT3DECIMAL(18,2)Y
135QUAR_RENT4DECIMAL(18,2)Y
136Q2_ADDRESSNVARCHAR(220)Y
137Q2_NATNVARCHAR(38)Y
138Q2_FMSMALLDATETIMEY
139Q2_TOSMALLDATETIMEY
140Q2_RENT1DECIMAL(18,2)Y
141Q2_RENT2DECIMAL(18,2)Y
142Q2_RENT3DECIMAL(18,2)Y
143Q2_RENT4DECIMAL(18,2)Y
144PREVIOUS_EMPLOYERNVARCHAR(320)Y
145OSEA_PAIDBYNCHAR(2)Y
146OSEA_NAMENVARCHAR(120)Y
147OSEA_ADDNVARCHAR(120)Y
148OSEA_AMTNVARCHAR(40)Y
149SHARE_OPTIONINTY
150IS_NON_EMPLOYEE_IR56MBITN
151IR56M_COMPANY_NAMENVARCHAR(140)N
152IR56M_COMPANY_CHINESE_NAMENVARCHAR(70)N
153IR56M_BR_NONVARCHAR(16)N
154INS_PLANNVARCHAR(24)Y
155INS_GRADENVARCHAR(24)Y
156HOLIDAY_TYPENVARCHAR(6)N
157PHOTOVARBINARYY
158MEMONVARCHAR(4000)Y
159USER01NVARCHAR(100)Y
160USER02NVARCHAR(100)Y
161USER03NVARCHAR(100)Y
162USER04NVARCHAR(100)Y
163USER05NVARCHAR(100)Y
164USER06NUMERICY
165USER07NUMERICY
166USER08NUMERICY
167USER09NUMERICY
168USER10NUMERICY
169USER11DATETIMEY
170USER12DATETIMEY
171USER13DATETIMEY
172USER14DATETIMEY
173USER15DATETIMEY
174USER16BITN
175USER17BITN
176USER18BITN
177USER19BITN
178USER20BITN
179USER21NVARCHAR(100)Y
180USER22NVARCHAR(100)Y
181USER23NVARCHAR(100)Y
182USER24NVARCHAR(100)Y
183USER25NVARCHAR(100)Y
184EP_PASSWORDVARCHAR(120)Y
185EP_APPROVER_NO1NVARCHAR(20)Y
186EP_APPROVER_NO2NVARCHAR(20)Y
187EP_APPROVER_NO3NVARCHAR(20)Y
188EP_DELEGATED_TONVARCHAR(20)Y
189EP_DELEGATED_START_DATESMALLDATETIMEY
190EP_DELEGATED_END_DATESMALLDATETIMEY
191EP_LOGINBITN
192EP_NOTICEBOARD_ADMINBITN
193EP_NOTICEBOARD_ADMIN_OWN_DEPT_ONLYBITN
194EP_SHOW_ON_PHONE_LISTBITN
195EP_SHOW_MOBILE_PHONEBITN
196EP_SHOW_COMPANY_CALENDARBITN
197EP_COMPANY_CALENDAR_OWN_DEPT_ONLYBITN
198EP_COMPANY_CALENDAR_OWN_DIVISION_ONLYBITN
199EP_SHOW_UPDATE_ROSTERBITN
200EP_SHOW_SUBORDINATE_PROFILEBITN
201EP_ENABLE_CL_ENTITLEMENT_APPLICATIONBITN
202EP_DISABLE_SALARY_HISTORYBITN
203EP_ALLOW_ON_BEHALF_APPPLICATIONBITN
204EP_ALLOW_ON_BEHALF_APPPLICATION_OWN_DEPT_ONLYBITN
205EP_SHOW_DIRECTORYBITN
206EP_DIRECTORY_OWN_DEPT_ONLYBITN
207EP_ENABLE_WEBLEAVEBITN
208EP_ENABLE_LEAVE_APPLICATIONBITN
209EP_ENABLE_EXPENSE_CLAIMS_APPLICATIONBITN
210EP_ALLOW_MASS_APPROVALBITN
211EP_SUPPRESS_APPROVER_EMAIL_NOTIFICATIONBITN
212EP_CALENDAR_SHOW_BIRTHDAYBITN
213EP_DISALLOW_VIEW_SALARY_IN_SUBORDINATE_PROFILEBITN
214EP_APPROVED_EMAIL_CC_LISTNVARCHAR(1000)N
215EP_IS_LOGOUT_RETURN_HOME_PAGEBITN
216HK_INCOME_TAXBITN
217EMAIL_PAYSLIPBITN
218NO_PREPAID_PAYROLLBITN
219USE_PERSONAL_EMAIL_FOR_PAYSLIPBITN
220USE_PERSONAL_EMAIL_FOR_IR_FORMS_REPORTSBITN
221NON_CONTINUOUS_CONTRACT_EEBITN
222PART_TIME_EMPLOYEEBITN
223CASUAL_EMPLOYEEBITN
224CASUAL_EMPLOYEE_UNDER_MASTER_TRUST_SCHEMEBITN
225OVERSEAS_EMPLOYEEBITN
226VISA_START_DATESMALLDATETIMEY
227ENABLE_ATTENDANCE_RECORDBITN
228WEBLEAVE_SHOW_ATTENDANCEBITN
229WEBLEAVE_SHOW_LEAVE_BALANCEBITN
230EA02007_EXCEMPTIONBITN
231ENABLE_SHIFT_DIFFERENTIAL_PAYBITN
232ENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFOBITN
233INTRODUCE_BYNVARCHAR(20)N
234IS_NEW_STAFF_REFERRAL_BONUS_PAIDBITN
235IS_INTRODUCER_REFERRAL_BONUS_PAIDBITN
236REFERRAL_BONUS_BATCH_NONCHAR(24)N
237CREATE_BYCHAR(10)N
238CREATE_DATEDATETIMEN
239LAST_UPDATE_BYCHAR(10)Y
240LAST_UPDATE_DATEDATETIMEY
241PAY_TYPE1_AMTDECIMAL(23,9)Yobsoleted
242PAY_TYPE2_AMTDECIMAL(23,9)Yobsoleted
243PAY_TYPE3_AMTDECIMAL(23,9)Yobsoleted
244PAY_TYPE4_AMTDECIMAL(23,9)Yobsoleted
245PAY_TYPE5_AMTDECIMAL(23,9)Yobsoleted
246PAY_TYPE6_AMTDECIMAL(23,9)Yobsoleted
247PAY_TYPE7_AMTDECIMAL(23,9)Yobsoleted
248PAY_TYPE8_AMTDECIMAL(23,9)Yobsoleted
249PAY_TYPE9_AMTDECIMAL(23,9)Yobsoleted
250PAY_TYPE10_AMTDECIMAL(23,9)Yobsoleted
251PAY_TYPE11_AMTDECIMAL(23,9)Yobsoleted
252PAY_TYPE12_AMTDECIMAL(23,9)Yobsoleted
253PAY_TYPE13_AMTDECIMAL(23,9)Yobsoleted
254PAY_TYPE14_AMTDECIMAL(23,9)Yobsoleted
255PAY_TYPE15_AMTDECIMAL(23,9)Yobsoleted

Default Constraints
Sr.NameColumnValue
1DF_plEmployee_AREA_CODEAREA_CODE(N'H')
2DF_plEmployee_AUTOPAYAUTOPAY(N'Y')
3DF_plEmployee_CASUAL_EMPLOYEECASUAL_EMPLOYEE((0))
4DF_plEmployee_CASUAL_EMPLOYEE_UNDER_MASTER_TRUST_SCHEMECASUAL_EMPLOYEE_UNDER_MASTER_TRUST_SCHEME((0))
5DF_plEmployee_DIVISION_CODEDIVISION_CODE('')
6DF_plEmployee_EA02007_EXCEMPTIONEA02007_EXCEMPTION((0))
7DF_plEmployee_EEVC_SIGNEEVC_SIGN('$')
8DF_plEmployee_EMAIL_PAYSLIPEMAIL_PAYSLIP((1))
9DF_plEmployee_ENABLE_ATTENDANCE_RECORDENABLE_ATTENDANCE_RECORD((1))
10DF_plEmployee_ENABLE_SHIFT_DIFFERENTIAL_PAYENABLE_SHIFT_DIFFERENTIAL_PAY((0))
11DF_plEmployee_ENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFOENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFO((0))
12DF_plEmployee_ENTITY_CODEEMPLOYER_CODE('')
13DF_plEmployee_EP_ALLOW_MASS_APPROVALEP_ALLOW_MASS_APPROVAL((0))
14DF_plEmployee_EP_ALLOW_ON_BEHALF_APPPLICATIONEP_ALLOW_ON_BEHALF_APPPLICATION((0))
15DF_plEmployee_EP_ALLOW_ON_BEHALF_APPPLICATION_OWN_DEPT_ONLYEP_ALLOW_ON_BEHALF_APPPLICATION_OWN_DEPT_ONLY((0))
16DF_plEmployee_EP_APPROVAL_CC_LISTEP_APPROVED_EMAIL_CC_LIST('')
17DF_plEmployee_EP_CALENDAR_SHOW_BIRTHDAYEP_CALENDAR_SHOW_BIRTHDAY((0))
18DF_plEmployee_EP_COMPANY_CALENDAR_OWN_DEPT_ONLYEP_COMPANY_CALENDAR_OWN_DEPT_ONLY((0))
19DF_plEmployee_EP_COMPANY_CALENDAR_OWN_DIVSION_ONLYEP_COMPANY_CALENDAR_OWN_DIVISION_ONLY((0))
20DF_plEmployee_EP_DIRECTORY_OWN_DEPT_ONLYEP_DIRECTORY_OWN_DEPT_ONLY((0))
21DF_plEmployee_EP_DISABLE_SALARY_HISTORYEP_DISABLE_SALARY_HISTORY((0))
22DF_plEmployee_EP_DISALLOW_VIEW_SALARY_IN_SUBORDINATE_PROFILEEP_DISALLOW_VIEW_SALARY_IN_SUBORDINATE_PROFILE((0))
23DF_plEmployee_EP_ENABLE_CL_ENTITLEMENT_APPLICATIONEP_ENABLE_CL_ENTITLEMENT_APPLICATION((0))
24DF_plEmployee_EP_ENABLE_EXPENSE_CLAIMS_APPLICATIONEP_ENABLE_EXPENSE_CLAIMS_APPLICATION((1))
25DF_plEmployee_EP_ENABLE_LEAVE_APPLICATIONEP_ENABLE_LEAVE_APPLICATION((1))
26DF_plEmployee_EP_ENABLE_WEBLEAVEEP_ENABLE_WEBLEAVE((1))
27DF_plEmployee_EP_IS_LOGOUT_RETURN_HOME_PAGEEP_IS_LOGOUT_RETURN_HOME_PAGE((0))
28DF_plEmployee_EP_LOGINEP_LOGIN((1))
29DF_plEmployee_EP_NOTICEBOARD_ADMINEP_NOTICEBOARD_ADMIN((0))
30DF_plEmployee_EP_NOTICEBOARD_ADMIN_OWN_DEPT_ONLYEP_NOTICEBOARD_ADMIN_OWN_DEPT_ONLY((0))
31DF_plEmployee_EP_SHOW_COMPANY_CALENDAREP_SHOW_COMPANY_CALENDAR((0))
32DF_plEmployee_EP_SHOW_DIRECTORYEP_SHOW_DIRECTORY((1))
33DF_plEmployee_EP_SHOW_MOBILE_PHONEEP_SHOW_MOBILE_PHONE((0))
34DF_plEmployee_EP_SHOW_ON_PHONE_LISTEP_SHOW_ON_PHONE_LIST((1))
35DF_plEmployee_EP_SHOW_SUBORDINATE_PROFILEEP_SHOW_SUBORDINATE_PROFILE((0))
36DF_plEmployee_EP_SHOW_UPDATE_ROSTEREP_SHOW_UPDATE_ROSTER((0))
37DF_plEmployee_EP_SUPPRESS_APPROVER_EMAIL_NOTIFICATIONEP_SUPPRESS_APPROVER_EMAIL_NOTIFICATION((0))
38DF_plEmployee_ERVC_SIGNERVC_SIGN('$')
39DF_plEmployee_HK_INCOME_TAXHK_INCOME_TAX((1))
40DF_plEmployee_HOLIDAY_TYPEHOLIDAY_TYPE('P')
41DF_plEmployee_INTRODUCE_BYINTRODUCE_BY('')
42DF_plEmployee_IR56M_BR_NOIR56M_BR_NO('')
43DF_plEmployee_IR56M_COMPANY_CHINESE_NAMEIR56M_COMPANY_CHINESE_NAME('')
44DF_plEmployee_IR56M_COMPANY_NAMEIR56M_COMPANY_NAME('')
45DF_plEmployee_IS_INTRODUCER_REFERRAL_BONUS_PAIDIS_INTRODUCER_REFERRAL_BONUS_PAID((0))
46DF_plEmployee_IS_NON_EMPLOYEE_IR56MIS_NON_EMPLOYEE_IR56M((0))
47DF_plEmployee_IS_REFERRAL_BONUS_PAIDIS_NEW_STAFF_REFERRAL_BONUS_PAID((0))
48DF_plEmployee_MARITALMARITAL((1))
49DF_plEmployee_NO_PREPAID_PAYROLLNO_PREPAID_PAYROLL((0))
50DF_plEmployee_NON_CONTINUOUS_CONTRACT_EENON_CONTINUOUS_CONTRACT_EE((0))
51DF_plEmployee_OSEA_PAIDBYOSEA_PAIDBY(N'N')
52DF_plEmployee_OVERSEAS_EMPLOYEEOVERSEAS_EMPLOYEE((0))
53DF_plEmployee_PART_TIME_EMPLOYEEPART_TIME_EMPLOYEE((0))
54DF_plEmployee_PAY_TYPE1_AMT_FORMULAPAY_TYPE1_AMT_FORMULA('')
55DF_plEmployee_PAY_TYPE10_AMT_FORMULAPAY_TYPE10_AMT_FORMULA('')
56DF_plEmployee_PAY_TYPE11_AMT_FORMULAPAY_TYPE11_AMT_FORMULA('')
57DF_plEmployee_PAY_TYPE12_AMT_FORMULAPAY_TYPE12_AMT_FORMULA('')
58DF_plEmployee_PAY_TYPE13_AMT_FORMULAPAY_TYPE13_AMT_FORMULA('')
59DF_plEmployee_PAY_TYPE14_AMT_FORMULAPAY_TYPE14_AMT_FORMULA('')
60DF_plEmployee_PAY_TYPE15_AMT_FORMULAPAY_TYPE15_AMT_FORMULA('')
61DF_plEmployee_PAY_TYPE2_AMT_FORMULAPAY_TYPE2_AMT_FORMULA('')
62DF_plEmployee_PAY_TYPE3_AMT_FORMULAPAY_TYPE3_AMT_FORMULA('')
63DF_plEmployee_PAY_TYPE4_AMT_FORMULAPAY_TYPE4_AMT_FORMULA('')
64DF_plEmployee_PAY_TYPE5_AMT_FORMULAPAY_TYPE5_AMT_FORMULA('')
65DF_plEmployee_PAY_TYPE6_AMT_FORMULAPAY_TYPE6_AMT_FORMULA('')
66DF_plEmployee_PAY_TYPE7_AMT_FORMULAPAY_TYPE7_AMT_FORMULA('')
67DF_plEmployee_PAY_TYPE8_AMT_FORMULAPAY_TYPE8_AMT_FORMULA('')
68DF_plEmployee_PAY_TYPE9_AMT_FORMULAPAY_TYPE9_AMT_FORMULA('')
69DF_plEmployee_PFUND_EEPFUND_EE((599))
70DF_plEmployee_PFUND_ERPFUND_ER((599))
71DF_plEmployee_PFUND_TYPEPFUND_TYPE(N'MPF')
72DF_plEmployee_PRINT_IR56EPRINT_IR56E(N'N')
73DF_plEmployee_PRINT_IR56FGPRINT_IR56FG(N'N')
74DF_plEmployee_QUARTERQUARTER(N'N')
75DF_plEmployee_REFERRAL_BONUS_BATCH_NOREFERRAL_BONUS_BATCH_NO('')
76DF_plEmployee_SALARY_BYSALARY_BY(N'M')
77DF_plEmployee_SICK_RATESICK_RATE((100))
78DF_plEmployee_SICK_RATE2SICK_RATE2((100))
79DF_plEmployee_USE_PERSONAL_EMAIL_FOR_IR_FORMS_REPORTSUSE_PERSONAL_EMAIL_FOR_IR_FORMS_REPORTS((0))
80DF_plEmployee_USE_PERSONAL_EMAIL_FOR_PAYSLIPUSE_PERSONAL_EMAIL_FOR_PAYSLIP((0))
81DF_plEmployee_USER16USER16((0))
82DF_plEmployee_USER17USER17((0))
83DF_plEmployee_USER18USER18((0))
84DF_plEmployee_USER19USER19((0))
85DF_plEmployee_USER20USER20((0))
86DF_plEmployee_WEBLEAVE_SHOW_ATTENDANCEWEBLEAVE_SHOW_ATTENDANCE((1))
87DF_plEmployee_WEBLEAVE_SHOW_LEAVE_BALANCEWEBLEAVE_SHOW_LEAVE_BALANCE((1))

Triggers
Sr.NameDescription
1Tr_EEChangeLog
2Tr_plEmployee
3Tr_plEmployee_Deleting
4Tr_plEmployee_Validating

Indexes
Sr.NameTypeColumns
1PK_plEmployeeClusteredEE_NO
2plEmployee_Index1NonclusteredJOIN_DATE
3plEmployee_Index10NonclusteredCASUAL_EMPLOYEE
4plEmployee_Index11NonclusteredREPORT_TO
5plEmployee_Index12NonclusteredPROBATION_END_DATE
6plEmployee_Index13NonclusteredCONTRACT_END_DATE
7plEmployee_Index14NonclusteredWORK_LOCATION
8plEmployee_Index16NonclusteredHK_INCOME_TAX
9plEmployee_Index18NonclusteredOT_TYPE
10plEmployee_Index19NonclusteredDIVISION_CODE
11plEmployee_Index2NonclusteredWORK_HRS_TYPE
12plEmployee_Index3NonclusteredROSTER_CODE
13plEmployee_Index4NonclusteredTERMN_DATE
14plEmployee_Index5NonclusteredEE_CLASS
15plEmployee_Index6NonclusteredENTITLEMENT_CODE
16plEmployee_Index7NonclusteredDEPT_CODE
17plEmployee_Index8NonclusteredENABLE_ATTENDANCE_RECORD
18plEmployee_Index9NonclusteredSALARY_BY




Index
Table:[dbo].[plEmployer]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EMPLOYER_CODENVARCHAR(24)N
2TAX_EMPLOYER_NAMENVARCHAR(140)Y
3ER_TAX_NONVARCHAR(24)Y
4TAX_SNAMENVARCHAR(60)Y
5TAX_DESIGNATIONNVARCHAR(50)Y
6TAX_ADDRESSNVARCHAR(510)Y
7CREATE_BYCHAR(10)N
8CREATE_DATEDATETIMEN
9LAST_UPDATE_BYCHAR(10)Y
10LAST_UPDATE_DATEDATETIMEY

Triggers
Sr.NameDescription
1Tr_plEmployer
2Tr_plEmployer_Deleting

Indexes
Sr.NameTypeColumns
1PK_plEmployerClusteredEMPLOYER_CODE




Index
Table:[dbo].[plEmploymentHistory]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2EE_NONVARCHAR(20)N
3PREVIOUS_EMPLOYERNVARCHAR(100)N
4POSITIONNVARCHAR(200)N
5PROJECTNVARCHAR(200)Y
6PROJECT_DESCRIPTIONNVARCHAR(8000)Y
7ENDING_SALARYDECIMAL(23,9)N
8WORKED_PERIODNVARCHAR(100)N
9REASON_FOR_LEAVINGNVARCHAR(100)N
10CREATE_BYCHAR(10)Y
11CREATE_DATEDATETIMEY
12LAST_UPDATE_BYCHAR(10)Y
13LAST_UPDATE_DATEDATETIMEY

Triggers
Sr.NameDescription
1Tr_plEmploymentHistory_Validating

Indexes
Sr.NameTypeColumns
1PK_plEmploymentHistoryClusteredTS_KEY




Index
Table:[dbo].[plExpense]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3EXPENSE_DATEDATEN
4EXPENSE_CODENVARCHAR(24)N
5REMARKSNVARCHAR(8000)N
6APPLY_AMOUNTDECIMAL(18,2)N
7AMOUNTDECIMAL(18,2)N
8APPROVED_BYCHAR(10)Y
9APPROVED_DATEDATETIMEY
10REFERENCENVARCHAR(60)Y
11COMMENTSNVARCHAR(8000)Y
12EC_USER01NVARCHAR(100)N
13EC_USER02NVARCHAR(100)N
14EC_USER03NVARCHAR(100)N
15EC_USER04NVARCHAR(100)N
16EC_USER05NVARCHAR(100)N
17EC_USER06NUMERICN
18EC_USER07NUMERICN
19EC_USER08NUMERICN
20EC_USER09NUMERICN
21EC_USER10NUMERICN
22EC_USER11DATEY
23EC_USER12DATEY
24EC_USER13DATEY
25EC_USER14DATEY
26EC_USER15DATEY
27EC_USER16BITN
28EC_USER17BITN
29EC_USER18BITN
30EC_USER19BITN
31EC_USER20BITN
32LeaveApply_RowSerialDECIMAL(18,0)Y
33MISSING_ATTACHMENTBITN
34ATTACHMENT_NAMENVARCHAR(400)Y
35ATTACHMENT_IMAGEVARBINARYY
36CREATE_BYCHAR(10)N
37CREATE_DATEDATETIMEN
38LAST_UPDATE_BYCHAR(10)N
39LAST_UPDATE_DATEDATETIMEN
40OldRowSerialDECIMAL(18,0)Y

Default Constraints
Sr.NameColumnValue
1DF_plExpense_AMOUNTAMOUNT((0))
2DF_plExpense_APPLY_AMOUNTAPPLY_AMOUNT((0))
3DF_plExpense_EC_USER01EC_USER01('')
4DF_plExpense_EC_USER02EC_USER02('')
5DF_plExpense_EC_USER03EC_USER03('')
6DF_plExpense_EC_USER04EC_USER04('')
7DF_plExpense_EC_USER05EC_USER05('')
8DF_plExpense_EC_USER06EC_USER06((0))
9DF_plExpense_EC_USER061EC_USER07((0))
10DF_plExpense_EC_USER08EC_USER08((0))
11DF_plExpense_EC_USER09EC_USER09((0))
12DF_plExpense_EC_USER10EC_USER10((0))
13DF_plExpense_EC_USER16EC_USER16((0))
14DF_plExpense_EC_USER17EC_USER17((0))
15DF_plExpense_EC_USER18EC_USER18((0))
16DF_plExpense_EC_USER19EC_USER19((0))
17DF_plExpense_EC_USER20EC_USER20((0))
18DF_plExpense_MISSING_ATTACHMENTMISSING_ATTACHMENT((0))
19DF_plExpense_REMARKSREMARKS('')

Triggers
Sr.NameDescription
1plExpense_Delete
2plExpense_HandleReseedofIdentity
3Tr_plExpense
4Tr_plExpense_Validating

Indexes
Sr.NameTypeColumns
1PK_plExpenseClusteredRowSerial
2plExpense_Index1NonclusteredLeaveApply_RowSerial
3plExpense_Index2NonclusteredEXPENSE_CODE
4plExpense_Index3NonclusteredEE_NO




Index
Table:[dbo].[plExpenseDeleted]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2plExpense_RowSerialDECIMAL(18,0)N
3EE_NONVARCHAR(20)N
4EXPENSE_DATEDATEN
5EXPENSE_CODENVARCHAR(24)N
6REMARKSNVARCHAR(8000)N
7APPLY_AMOUNTDECIMAL(18,2)N
8AMOUNTDECIMAL(18,2)N
9APPROVED_BYCHAR(10)Y
10APPROVED_DATEDATETIMEY
11REFERENCENVARCHAR(60)Y
12COMMENTSNVARCHAR(8000)Y
13EC_USER01NVARCHAR(100)N
14EC_USER02NVARCHAR(100)N
15EC_USER03NVARCHAR(100)N
16EC_USER04NVARCHAR(100)N
17EC_USER05NVARCHAR(100)N
18EC_USER06NUMERICN
19EC_USER07NUMERICN
20EC_USER08NUMERICN
21EC_USER09NUMERICN
22EC_USER10NUMERICN
23EC_USER11DATEY
24EC_USER12DATEY
25EC_USER13DATEY
26EC_USER14DATEY
27EC_USER15DATEY
28EC_USER16BITN
29EC_USER17BITN
30EC_USER18BITN
31EC_USER19BITN
32EC_USER20BITN
33LeaveApply_RowSerialDECIMAL(18,0)Y
34MISSING_ATTACHMENTBITN
35ATTACHMENT_NAMENVARCHAR(400)Y
36ATTACHMENT_IMAGEVARBINARYY
37CREATE_BYCHAR(10)N
38CREATE_DATEDATETIMEN
39LAST_UPDATE_BYCHAR(10)N
40LAST_UPDATE_DATEDATETIMEN
41OldRowSerialDECIMAL(18,0)Y
42DELETE_BYCHAR(10)N
43DELETE_DATEDATETIMEN

Indexes
Sr.NameTypeColumns
1PK_plExpenseDeletedClusteredRowSerial




Index
Table:[dbo].[plExpensePeriod]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMDATEY
3PERIOD_TODATEY
4CREATE_BYCHAR(10)N
5CREATE_DATEDATETIMEN
6LAST_UPDATE_BYCHAR(10)Y
7LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plExpensePeriod_1ClusteredPERIOD




Index
Table:[dbo].[plHoliday]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2REGIONNVARCHAR(6)N
3Holiday_DateSMALLDATETIMEN
4Holiday_DescNVARCHAR(200)N
5PUBLICBITN
6STATUTORYBITN
7CREATE_BYCHAR(10)N
8CREATE_DATEDATETIMEN
9LAST_UPDATE_BYCHAR(10)Y
10LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plHoliday_Holiday_DescHoliday_Desc('')
2DF_plHoliday_PUBLICPUBLIC((0))
3DF_plHoliday_REGIONREGION('')
4DF_plHoliday_STATUTORYSTATUTORY((0))

Triggers
Sr.NameDescription
1Tr_plHoliday
2Tr_plHoliday_Deleting

Indexes
Sr.NameTypeColumns
1PK_plHoliday_1ClusteredID
2plHoliday_Index1NonclusteredSTATUTORY
3plHoliday_Index2NonclusteredHoliday_Date
4plHoliday_Index3NonclusteredPUBLIC
5plHoliday_Index4NonclusteredREGION
Holiday_Date




Index
Table:[dbo].[plIR56B]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2TAX_YEARNVARCHAR(8)N
3EMPLOYER_CODENVARCHAR(24)N
4SHEET_NOINTY
5POSTEDBITN
6EE_TAX_NONVARCHAR(26)Y
7EE_TITLENVARCHAR(8)Y
8SURNAMENVARCHAR(40)Y
9OTHERNAMENVARCHAR(110)Y
10CHI_NAMENVARCHAR(100)Y
11HKID_NONVARCHAR(18)Y
12SEXNVARCHAR(2)Y
13MARITALINTY
14PASSPORTNVARCHAR(80)Y
15SPOUSE_NAMNVARCHAR(100)Y
16SP_HKIDNVARCHAR(18)Y
17SP_PASSPTNVARCHAR(80)Y
18RES_ADD1NVARCHAR(120)Y
19RES_ADD2NVARCHAR(60)Y
20AREA_CODENVARCHAR(2)Y
21CORR_ADDNVARCHAR(120)Y
22POSITIONNVARCHAR(80)Y
23MAIN_ERNVARCHAR(60)Y
24EMPLOYMENTNVARCHAR(32)Y
25PERIOD_1NVARCHAR(32)Y
26AMOUNT_1INTY
27PERIOD_2NVARCHAR(32)Y
28AMOUNT_2INTY
29PERIOD_3NVARCHAR(32)Y
30AMOUNT_3INTY
31PERIOD_4NVARCHAR(32)Y
32AMOUNT_4INTY
33PERIOD_5NVARCHAR(32)Y
34AMOUNT_5INTY
35PERIOD_6NVARCHAR(32)Y
36AMOUNT_6INTY
37PERIOD_7NVARCHAR(32)Y
38AMOUNT_7INTY
39PERIOD_8NVARCHAR(32)Y
40AMOUNT_8INTY
41PERIOD_9NVARCHAR(32)Y
42AMOUNT_9INTY
43PERIOD_10NVARCHAR(32)Y
44AMOUNT_10INTY
45DESC_11NVARCHAR(70)Y
46PERIOD_11NVARCHAR(32)Y
47AMOUNT_11INTY
48DESC_12NVARCHAR(70)Y
49PERIOD_12NVARCHAR(32)Y
50AMOUNT_12INTY
51DESC_13NVARCHAR(70)Y
52PERIOD_13NVARCHAR(32)Y
53AMOUNT_13INTY
54PERIOD_14NVARCHAR(32)Y
55AMOUNT_14INTY
56QUARTERNVARCHAR(2)Y
57Q1_ADD1NVARCHAR(120)Y
58Q1_ADD2NVARCHAR(100)Y
59Q1_NATNVARCHAR(38)Y
60Q1_PERDNVARCHAR(52)Y
61Q1_RENT1DECIMAL(18,2)Y
62Q1_RENT2DECIMAL(18,2)Y
63Q1_RENT3DECIMAL(18,2)Y
64Q1_RENT4DECIMAL(18,2)Y
65Q2_ADD1NVARCHAR(120)Y
66Q2_ADD2NVARCHAR(100)Y
67Q2_NATNVARCHAR(38)Y
68Q2_PERDNVARCHAR(52)Y
69Q2_RENT1DECIMAL(18,2)Y
70Q2_RENT2DECIMAL(18,2)Y
71Q2_RENT3DECIMAL(18,2)Y
72Q2_RENT4DECIMAL(18,2)Y
73EE_PAIDBYNVARCHAR(2)Y
74OSEA_AMTNVARCHAR(40)Y
75OSEA_NAMENVARCHAR(120)Y
76OSEA_ADDNVARCHAR(120)Y
77REMARKSNVARCHAR(120)Y
78IR56B_DATEDATETIMEY
79TTL_AMOUNTINTY
80CREATE_BYCHAR(10)N
81CREATE_DATEDATETIMEN
82LAST_UPDATE_BYCHAR(10)Y
83LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plIR56B_ENTITY_CODEEMPLOYER_CODE('')
2DF_plIR56B_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1Tr_plIR56B
2Tr_plIR56BChangeLog
3Tr_plIR56BItem_DELETE

Indexes
Sr.NameTypeColumns
1PK_plIR56B_1ClusteredEE_NO
TAX_YEAR
EMPLOYER_CODE
2plIR56B_INDEX1NonclusteredTAX_YEAR
EMPLOYER_CODE
SHEET_NO
3plIR56B_Index2NonclusteredEE_NO




Index
Table:[dbo].[plIR56BBatch]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TAX_YEARNCHAR(8)N
2EMPLOYER_CODENVARCHAR(24)N
3ER_TAX_NONCHAR(24)N
4POSTEDBITN
5PRINT_DATESMALLDATETIMEY
6CREATE_BYCHAR(10)N
7CREATE_DATEDATETIMEN
8LAST_UPDATE_BYCHAR(10)Y
9LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plIR56BBatch_ENTITY_CODEEMPLOYER_CODE('')
2DF_plIR56BBatch_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1tr_plIR56B_DELETE
2Tr_plIR56BBatch

Indexes
Sr.NameTypeColumns
1PK_plIR56BBatch_1ClusteredTAX_YEAR
EMPLOYER_CODE




Index
Table:[dbo].[plIR56F]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2POSTEDBITN
3ER_TAX_NONCHAR(24)Y
4SHEET_NOINTY
5TAX_YEARNCHAR(8)Y
6EE_TAX_NONVARCHAR(26)Y
7EE_TITLENVARCHAR(8)Y
8SURNAMENVARCHAR(40)Y
9OTHERNAMENVARCHAR(110)Y
10CHI_NAMENVARCHAR(100)Y
11HKID_NONVARCHAR(18)Y
12PASSPORTNVARCHAR(80)Y
13SEXNVARCHAR(2)Y
14MARITALINTY
15SPOUSE_NAMNVARCHAR(100)Y
16SP_HKIDNVARCHAR(80)Y
17SP_PASSPTNVARCHAR(80)Y
18RES_ADDRESSNVARCHAR(280)Y
19RES_ADD1NVARCHAR(120)Y
20RES_ADD2NVARCHAR(120)Y
21AREA_CODENCHAR(2)Y
22HOME_PHONENVARCHAR(60)Y
23CORR_ADDNVARCHAR(120)Y
24POSITIONNVARCHAR(80)Y
25MAIN_ERNVARCHAR(60)Y
26LEAVE_DATENVARCHAR(16)Y
27LEAVE_FORNVARCHAR(160)Y
28EMPLOYMENTNVARCHAR(32)Y
29PERIOD_1NVARCHAR(32)Y
30AMOUNT_1INTY
31PERIOD_2NVARCHAR(32)Y
32AMOUNT_2INTY
33PERIOD_3NVARCHAR(32)Y
34AMOUNT_3INTY
35PERIOD_4NVARCHAR(32)Y
36AMOUNT_4INTY
37PERIOD_5NVARCHAR(32)Y
38AMOUNT_5INTY
39PERIOD_6NVARCHAR(32)Y
40AMOUNT_6INTY
41PERIOD_7NVARCHAR(32)Y
42AMOUNT_7INTY
43PERIOD_8NVARCHAR(32)Y
44AMOUNT_8INTY
45NATURE_8NVARCHAR(40)Y
46PERIOD_9NVARCHAR(32)Y
47AMOUNT_9INTY
48NATURE_9NVARCHAR(40)Y
49QUARTERNVARCHAR(2)Y
50QUAR_ADD1NVARCHAR(120)Y
51QUAR_ADD2NVARCHAR(120)Y
52QUAR_NATNVARCHAR(40)Y
53QUAR_PERDNVARCHAR(60)Y
54QUAR_RENT1INTY
55QUAR_RENT2INTY
56QUAR_RENT3INTY
57QUAR_RENT4INTY
58EE_PAIDBYNVARCHAR(2)Y
59OSEA_NAMENVARCHAR(120)Y
60OSEA_ADDNVARCHAR(120)Y
61OSEA_AMTNVARCHAR(40)Y
62NEW_ERNVARCHAR(100)Y
63NEW_EE_ADDNVARCHAR(80)Y
64REMARKSNVARCHAR(120)Y
65IR56F_DATEDATETIMEY
66TTL_AMOUNTINTY
67CREATE_BYCHAR(10)N
68CREATE_DATEDATETIMEN
69LAST_UPDATE_BYCHAR(10)Y
70LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plIR56F_NATURE_9NATURE_9('')
2DF_plIR56F_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1Tr_pl56F_Validating
2Tr_plIR56F
3Tr_plIR56FChangeLog

Indexes
Sr.NameTypeColumns
1PK_plIR56FClusteredEE_NO




Index
Table:[dbo].[plIR56G]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2POSTEDBITN
3ER_TAX_NONCHAR(24)Y
4SHEET_NOINTY
5TAX_YEARNCHAR(8)Y
6EE_TAX_NONVARCHAR(26)Y
7EE_TITLENVARCHAR(8)Y
8SURNAMENVARCHAR(40)Y
9OTHERNAMENVARCHAR(110)Y
10CHI_NAMENVARCHAR(100)Y
11HKID_NONVARCHAR(18)Y
12PASSPORTNVARCHAR(80)Y
13SEXNVARCHAR(2)Y
14MARITALINTY
15SPOUSE_NAMNVARCHAR(100)Y
16SP_HKIDNVARCHAR(80)Y
17SP_PASSPTNVARCHAR(80)Y
18RES_ADDRESSNVARCHAR(280)Y
19RES_ADD1NVARCHAR(120)Y
20RES_ADD2NVARCHAR(120)Y
21AREA_CODENCHAR(2)Y
22HOME_PHONENVARCHAR(60)Y
23LEAVE_HK_DATESMALLDATETIMEY
24CORR_ADDNVARCHAR(120)Y
25POSITIONNVARCHAR(80)Y
26MAIN_ERNVARCHAR(60)Y
27LEAVE_DATENVARCHAR(16)Y
28LEAVE_FORNVARCHAR(80)Y
29EMPLOYMENTNVARCHAR(32)Y
30PERIOD_1NVARCHAR(32)Y
31AMOUNT_1INTY
32PERIOD_2NVARCHAR(32)Y
33AMOUNT_2INTY
34PERIOD_3NVARCHAR(32)Y
35AMOUNT_3INTY
36PERIOD_4NVARCHAR(32)Y
37AMOUNT_4INTY
38PERIOD_5NVARCHAR(32)Y
39AMOUNT_5INTY
40PERIOD_6NVARCHAR(32)Y
41AMOUNT_6INTY
42PERIOD_7NVARCHAR(32)Y
43AMOUNT_7INTY
44PERIOD_8NVARCHAR(32)Y
45AMOUNT_8INTY
46NATURE_8NVARCHAR(40)Y
47PERIOD_9NVARCHAR(32)Y
48AMOUNT_9INTY
49NATURE_9NVARCHAR(40)Y
50QUARTERNVARCHAR(2)Y
51QUAR_ADD1NVARCHAR(120)Y
52QUAR_ADD2NVARCHAR(120)Y
53QUAR_NATNVARCHAR(40)Y
54QUAR_PERDNVARCHAR(60)Y
55QUAR_RENT1INTY
56QUAR_RENT2INTY
57QUAR_RENT3INTY
58QUAR_RENT4INTY
59EE_PAIDBYNVARCHAR(2)Y
60OSEA_NAMENVARCHAR(120)Y
61OSEA_ADDNVARCHAR(120)Y
62OSEA_AMTNVARCHAR(40)Y
63NEW_ERNVARCHAR(100)Y
64NEW_EE_ADDNVARCHAR(80)Y
65REMARKSNVARCHAR(120)Y
66BORNE_BY_ERINTY
67MONEY_HELDINTY
68MONEY_HELD_AMTNVARCHAR(60)Y
69MONEY_HELD_REASONNVARCHAR(100)Y
70DEPARTURE_REASONINTY
71DEPARTURE_RESIDENVARCHAR(140)Y
72DEPARTURE_HOME_COUNTRYNVARCHAR(40)Y
73DEPARTURE_SECONDEDNVARCHAR(40)Y
74DEPARTURE_OTHERNVARCHAR(200)Y
75POSTAL_ADDRESSNVARCHAR(200)Y
76RETURN_TO_HKINTY
77RETURN_DATENVARCHAR(100)Y
78SHARE_OPTIONSINTY
79SHARE_NONVARCHAR(100)Y
80SHARE_DATENVARCHAR(100)Y
81IR56G_DATEDATETIMEY
82TTL_AMOUNTINTY
83CREATE_BYCHAR(10)N
84CREATE_DATEDATETIMEN
85LAST_UPDATE_BYCHAR(10)Y
86LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plIR56G_NATURE_9NATURE_9('')
2DF_plIR56G_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1Tr_pl56G_Validating
2Tr_plIR56G
3Tr_plIR56GChangeLog

Indexes
Sr.NameTypeColumns
1PK_plIR56GClusteredEE_NO




Index
Table:[dbo].[plIR56M]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2TAX_YEARNVARCHAR(8)N
3EMPLOYER_CODENVARCHAR(24)N
4SHEET_NOINTN
5POSTEDBITN
6ComRecNameEngNVARCHAR(140)Y
7ComRecNameChiNVARCHAR(70)Y
8ComRecBRNNVARCHAR(16)Y
9HKIDNVARCHAR(18)Y
10SURNAMENVARCHAR(40)Y
11OTHERNAMENVARCHAR(110)Y
12NameInChineseNVARCHAR(50)Y
13SexNVARCHAR(2)Y
14MaritalStatusINTY
15SpouseNameNVARCHAR(100)Y
16SpouseHKIDNVARCHAR(18)Y
17SpousePpNumNVARCHAR(80)Y
18PosAddrNVARCHAR(180)Y
19AreaCodePosAddrNVARCHAR(2)Y
20PhoneNumNVARCHAR(30)Y
21CapacityNVARCHAR(80)Y
22StartDateOfServiceNVARCHAR(16)N
23EndDateOfServiceNVARCHAR(16)N
24AmtOfType1DECIMAL(18,9)Y
25AmtOfType2DECIMAL(18,9)Y
26AmtOfType3DECIMAL(18,9)Y
27AmtOfArtistFeeDECIMAL(18,9)Y
28AmtOfCopyrightDECIMAL(18,9)Y
29AmtOfConsultFeeDECIMAL(18,9)Y
30NatureOtherInc1NVARCHAR(70)Y
31AmtOfOtherInc1DECIMAL(18,9)Y
32NatureOtherInc2NVARCHAR(70)Y
33AmtOfOtherInc2DECIMAL(18,9)Y
34IndOfSumWithheldNVARCHAR(2)Y
35AmtOfSumWithheldDECIMAL(18,9)Y
36IndOfRemarkNVARCHAR(2)Y
37RemarksNVARCHAR(120)Y
38IR56M_DATEDATETIMEY
39TotalIncomeDECIMAL(18,0)Y
40CREATE_BYCHAR(10)N
41CREATE_DATEDATETIMEN
42LAST_UPDATE_BYCHAR(10)N
43LAST_UPDATE_DATEDATETIMEN

Default Constraints
Sr.NameColumnValue
1DF_plIR56M_ENTITY_CODEEMPLOYER_CODE('')
2DF_plIR56M_IndOfRemarkIndOfRemark('0')
3DF_plIR56M_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1Tr_plIR56M
2Tr_plIR56MChangeLog
3Tr_plIR56MItem_DELETE

Indexes
Sr.NameTypeColumns
1PK_plIR56M_1ClusteredEE_NO
TAX_YEAR
EMPLOYER_CODE




Index
Table:[dbo].[plIR56MBatch]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TAX_YEARNCHAR(8)N
2EMPLOYER_CODENVARCHAR(24)N
3ER_TAX_NONCHAR(24)N
4POSTEDBITN
5PRINT_DATESMALLDATETIMEY
6CREATE_BYCHAR(10)N
7CREATE_DATEDATETIMEN
8LAST_UPDATE_BYCHAR(10)Y
9LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plIR56MBatch_ENTITY_CODEEMPLOYER_CODE('')
2DF_plIR56MBatch_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1tr_plIR56M_DELETE
2Tr_plIR56MBatch

Indexes
Sr.NameTypeColumns
1PK_plIR56MBatchClusteredTAX_YEAR
EMPLOYER_CODE




Index
Table:[dbo].[plIRFormChangeLog]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialINTN
2TAX_YEARNVARCHAR(8)N
3EMPLOYER_CODENVARCHAR(24)N
4EE_NONVARCHAR(20)N
5FORMNVARCHAR(20)N
6EventDateTimeDATETIMEN
7UserIDCHAR(10)N
8FieldNVARCHAR(100)Y
9IsSalaryINTY
10OriginalValuesNVARCHAR(8000)Y
11NewValuesNVARCHAR(8000)Y

Default Constraints
Sr.NameColumnValue
1DF_plIRFormChangeLog_ENTITY_CODEEMPLOYER_CODE('')
2DF_plIRFormChangeLog_TAX_YEARTAX_YEAR('')

Indexes
Sr.NameTypeColumns
1PK_plIRFormChangeLogClusteredRowSerial




Index
Table:[dbo].[plLeave]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3LEAVE_FRSMALLDATETIMEY
4LEAVE_TOSMALLDATETIMEY
5DAYSDECIMAL(12,4)Y
6HOURSDECIMAL(12,4)Y
7AMPMNCHAR(2)Y
8LEAVE_CODENVARCHAR(24)N
9FR_TIMECHAR(5)Y
10TO_TIMECHAR(5)Y
11REMARKSNVARCHAR(8000)Y
12AMOUNTDECIMAL(18,2)Y
13APPROVED_BYCHAR(10)Y
14APPROVED_DATEDATETIMEY
15LeaveApply_RowSerialDECIMAL(18,0)Y
16MANUAL_OVERWRITEBITN
17MISSING_ATTACHMENTBITN
18ATTACHMENT_NAMENVARCHAR(400)Y
19ATTACHMENT_IMAGEVARBINARYY
20CREATE_BYCHAR(10)N
21CREATE_DATEDATETIMEN
22LAST_UPDATE_BYCHAR(10)Y
23LAST_UPDATE_DATEDATETIMEY
24OldRowSerialDECIMAL(18,0)Y

Default Constraints
Sr.NameColumnValue
1DF_plLeave_AMOUNTAMOUNT((0))
2DF_plLeave_FR_TIMEFR_TIME('')
3DF_plLeave_MANUAL_OVERWRITEMANUAL_OVERWRITE((0))
4DF_plLeave_MISSING_ATTACHMENTMISSING_ATTACHMENT((0))
5DF_plLeave_REMARKSREMARKS('')
6DF_plLeave_TO_TIMETO_TIME('')

Triggers
Sr.NameDescription
1plLeave_DeleteLeaveDayRecord
2plLeave_HandleReseedofIdentity
3Tr_plLeave
4Tr_plLeave_Validating

Indexes
Sr.NameTypeColumns
1PK_plLeaveClusteredRowSerial
2plLeave_Index0NonclusteredEE_NO
3plLeave_Index1NonclusteredLEAVE_CODE
4plLeave_Index2NonclusteredEE_NO
LEAVE_FR
LEAVE_CODE
5plLeave_Index3NonclusteredLEAVE_FR
6plLeave_Index4NonclusteredEE_NO
LEAVE_FR
AMPM
7plLeave_Index5NonclusteredLeaveApply_RowSerial
8plLeave_Index6NonclusteredLEAVE_FR
LEAVE_TO
MANUAL_OVERWRITE
9plLeave_Index7NonclusteredLEAVE_TO
10plLeave_Index9NonclusteredEE_NO
LEAVE_FR
AMPM




Index
Table:[dbo].[plLeaveAdjustment]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3ADJ_DATESMALLDATETIMEN
4DAYSDECIMAL(12,4)Y
5HOURSDECIMAL(12,4)Y
6NATURENVARCHAR(6)N
7REMARKSNVARCHAR(8000)Y
8OT_DATESMALLDATETIMEY
9LeaveApply_RowSerialDECIMAL(18,0)Y
10CLEntitlementApply_RowSerialDECIMAL(18,0)Y
11IsSystemCreatedBITN
12CREATE_BYCHAR(10)N
13CREATE_DATEDATETIMEN
14LAST_UPDATE_BYCHAR(10)Y
15LAST_UPDATE_DATEDATETIMEY
16OldRowSerialDECIMAL(18,0)Y

Default Constraints
Sr.NameColumnValue
1DF_plLeaveAdjustment_IsSystemCreatedIsSystemCreated((0))
2DF_plLeaveAdjustment_REMARKSREMARKS('')

Triggers
Sr.NameDescription
1plLeaveAdjustment_HandleReseedofIdentity
2Tr_plLeaveAdjustment
3Tr_plLeaveAdjustment_Validating

Indexes
Sr.NameTypeColumns
1PK_plLeaveAdjustmentClusteredRowSerial
2plLeaveAdjustment_INDEX1NonclusteredEE_NO
ADJ_DATE
NATURE
3plLeaveAdjustment_INDEX2NonclusteredLeaveApply_RowSerial
4plLeaveAdjustment_INDEX3NonclusteredNATURE




Index
Table:[dbo].[plLeaveApply]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3LEAVE_FRSMALLDATETIMEY
4LEAVE_TOSMALLDATETIMEY
5DAYSDECIMAL(12,4)Y
6HOURSDECIMAL(12,4)Y
7AMPMNCHAR(2)Y
8LEAVE_CODENVARCHAR(24)N
9FR_TIMECHAR(5)Y
10TO_TIMECHAR(5)Y
11OT_FRSMALLDATETIMEY
12OT_TOSMALLDATETIMEY
13OTFR_TIMECHAR(5)Y
14OTTO_TIMECHAR(5)Y
15OTAMPMNCHAR(2)Y
16REMARKSNVARCHAR(8000)Y
17AMOUNTDECIMAL(18,2)Y
18EC_USER01NVARCHAR(100)N
19EC_USER02NVARCHAR(100)N
20EC_USER03NVARCHAR(100)N
21EC_USER04NVARCHAR(100)N
22EC_USER05NVARCHAR(100)N
23EC_USER06NUMERICN
24EC_USER07NUMERICN
25EC_USER08NUMERICN
26EC_USER09NUMERICN
27EC_USER10NUMERICN
28EC_USER11DATEY
29EC_USER12DATEY
30EC_USER13DATEY
31EC_USER14DATEY
32EC_USER15DATEY
33EC_USER16BITN
34EC_USER17BITN
35EC_USER18BITN
36EC_USER19BITN
37EC_USER20BITN
38APPROVED_STSNVARCHAR(40)N
39PARTIALLY_APPROVED_BYNVARCHAR(40)Y
40PARTIALLY_APPROVED_DATESMALLDATETIMEY
41MAJORITY_APPROVED_BYNVARCHAR(40)Y
42MAJORITY_APPROVED_DATESMALLDATETIMEY
43ACTION_BYNVARCHAR(20)Y
44ACTION_DATESMALLDATETIMEY
45CHOSEN_EMAILNVARCHAR(20)Y
46ATTACHMENT_NAMENVARCHAR(400)Y
47ATTACHMENT_IMAGEVARBINARYY
48CREATE_BYCHAR(10)N
49CREATE_DATEDATETIMEN
50LAST_UPDATE_BYCHAR(10)Y
51LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plLeaveApply_AmountAMOUNT((0))
2DF_plLeaveApply_EC_USER01EC_USER01('')
3DF_plLeaveApply_EC_USER02EC_USER02('')
4DF_plLeaveApply_EC_USER03EC_USER03('')
5DF_plLeaveApply_EC_USER04EC_USER04('')
6DF_plLeaveApply_EC_USER05EC_USER05('')
7DF_plLeaveApply_EC_USER06EC_USER06((0))
8DF_plLeaveApply_EC_USER07EC_USER07((0))
9DF_plLeaveApply_EC_USER08EC_USER08((0))
10DF_plLeaveApply_EC_USER09EC_USER09((0))
11DF_plLeaveApply_EC_USER10EC_USER10((0))
12DF_plLeaveApply_EC_USER16EC_USER16((0))
13DF_plLeaveApply_EC_USER17EC_USER17((0))
14DF_plLeaveApply_EC_USER18EC_USER18((0))
15DF_plLeaveApply_EC_USER19EC_USER19((0))
16DF_plLeaveApply_EC_USER20EC_USER20((0))

Triggers
Sr.NameDescription
1plLeaveApply_HandleReseedofIdentity
2Tr_plLeaveApply

Indexes
Sr.NameTypeColumns
1PK_plLeaveApplyClusteredRowSerial
2plLeaveApply_Index1NonclusteredEE_NO
LEAVE_CODE
APPROVED_STS
3plLeaveApply_Index2NonclusteredLEAVE_CODE
4plLeaveApply_Index3NonclusteredAPPROVED_STS
5plLeaveApply_Index4NonclusteredLEAVE_FR
6plLeaveApply_Index5NonclusteredLEAVE_TO
7plLeaveApply_Index6NonclusteredCREATE_DATE




Index
Table:[dbo].[plLeaveApplyCancel]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialINTN
2plLeaveApply_RowSerialINTY
3EE_NONVARCHAR(20)N
4CANCEL_DATESMALLDATETIMEY
5CANCEL_REMARKSNVARCHAR(8000)Y
6CREATE_BYCHAR(10)N
7CREATE_DATEDATETIMEN
8LAST_UPDATE_BYCHAR(10)Y
9LAST_UPDATE_DATEDATETIMEY
10CANCEL_STSNVARCHAR(40)N
11PARTIALLY_APPROVED_BYNVARCHAR(40)Y
12PARTIALLY_APPROVED_DATESMALLDATETIMEY
13MAJORITY_APPROVED_BYNVARCHAR(40)Y
14MAJORITY_APPROVED_DATESMALLDATETIMEY
15ACTION_BYNVARCHAR(20)Y
16ACTION_DATESMALLDATETIMEY
17CHOSEN_EMAILNVARCHAR(20)Y

Triggers
Sr.NameDescription
1Tr_plLeaveApplyCancel

Indexes
Sr.NameTypeColumns
1PK_plLeaveApplyCancelClusteredRowSerial
2plLeaveApplyCancel_Index1NonclusteredCREATE_DATE
3plLeaveApplyCancel_Index2NonclusteredCANCEL_STS




Index
Table:[dbo].[plLeaveDayRecord]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2plLeave_RowSerialDECIMAL(18,0)Y
3EE_NONVARCHAR(20)N
4LEAVE_DATESMALLDATETIMEY
5DAYSDECIMAL(12,4)Y
6HOURSDECIMAL(12,4)Y
7AMPMNCHAR(2)Y
8LEAVE_CODENVARCHAR(24)Y
9NATURENVARCHAR(6)Y

Triggers
Sr.NameDescription
1plLeaveDayRecord_HandleReseedofIdentity

Indexes
Sr.NameTypeColumns
1plLeaveDayRecord_Index1NonclusteredLEAVE_CODE
2plLeaveDayRecord_Index2NonclusteredEE_NO
LEAVE_DATE
DAYS
NATURE
3plLeaveDayRecord_Index3NonclusteredEE_NO
LEAVE_DATE
AMPM
4plLeaveDayRecord_Index4NonclusteredEE_NO
LEAVE_DATE
DAYS
5plLeaveDayRecord_Index5ClusteredEE_NO
LEAVE_DATE
NATURE
6plLeaveDayRecord_Index6NonclusteredNATURE
7plLeaveDayRecord_Index7NonclusteredLEAVE_DATE
8plLeaveDayRecord_Index8NonclusteredplLeave_RowSerial
DAYS
9plLeaveDayRecord_Index9NonclusteredLEAVE_DATE
DAYS
LEAVE_CODE




Index
Table:[dbo].[plLeaveDeleted]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2plLeave_RowSerialDECIMAL(18,0)N
3EE_NONVARCHAR(20)N
4LEAVE_FRSMALLDATETIMEY
5LEAVE_TOSMALLDATETIMEY
6DAYSDECIMAL(12,4)Y
7HOURSDECIMAL(12,4)Y
8AMPMNCHAR(2)Y
9LEAVE_CODENVARCHAR(24)N
10FR_TIMECHAR(5)Y
11TO_TIMECHAR(5)Y
12REMARKSNVARCHAR(8000)Y
13AMOUNTDECIMAL(18,2)N
14APPROVED_BYCHAR(10)Y
15APPROVED_DATEDATETIMEY
16LeaveApply_RowSerialDECIMAL(18,0)Y
17MANUAL_OVERWRITEINTY
18MISSING_ATTACHMENTBITY
19ATTACHMENT_NAMENVARCHAR(400)Y
20ATTACHMENT_IMAGEVARBINARYY
21CREATE_BYCHAR(10)N
22CREATE_DATEDATETIMEN
23LAST_UPDATE_BYCHAR(10)Y
24LAST_UPDATE_DATEDATETIMEY
25DELETED_BYCHAR(10)N
26DELETED_DATEDATETIMEN

Default Constraints
Sr.NameColumnValue
1DF_plLeaveDeleted_AMOUNTAMOUNT((0))

Indexes
Sr.NameTypeColumns
1PK_plLeaveDeletedClusteredRowSerial




Index
Table:[dbo].[plLeaveEntitlement]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1Entitlement_CodeNVARCHAR(24)N
2DESCRIPTIONNVARCHAR(120)Y
3ENTITLEMENT_YEARCHAR(1)N
4CHECK_AL_BASED_ONCHAR(1)N
5Entitle_over_1DECIMAL(12,4)Y
6Entitle_over_2DECIMAL(12,4)Y
7Entitle_over_3DECIMAL(12,4)Y
8Entitle_over_4DECIMAL(12,4)Y
9Entitle_over_5DECIMAL(12,4)Y
10Entitle_over_6DECIMAL(12,4)Y
11Entitle_over_7DECIMAL(12,4)Y
12Entitle_over_8DECIMAL(12,4)Y
13Entitle_over_9DECIMAL(12,4)Y
14Entitle_over_10DECIMAL(12,4)Y
15Entitle_over_11DECIMAL(12,4)Y
16Entitle_over_12DECIMAL(12,4)Y
17Entitle_over_13DECIMAL(12,4)Y
18Entitle_over_14DECIMAL(12,4)Y
19Entitle_over_15DECIMAL(12,4)Y
20Entitle_over_16DECIMAL(12,4)Y
21Entitle_over_17DECIMAL(12,4)Y
22Entitle_over_18DECIMAL(12,4)Y
23Entitle_over_19DECIMAL(12,4)Y
24Entitle_over_20DECIMAL(12,4)Y
25Entitle_over_AD_1DECIMAL(12,4)Y
26Entitle_over_AD_2DECIMAL(12,4)Y
27Entitle_over_AD_3DECIMAL(12,4)Y
28Entitle_over_AD_4DECIMAL(12,4)Y
29Entitle_over_AD_5DECIMAL(12,4)Y
30Entitle_over_AD_6DECIMAL(12,4)Y
31Entitle_over_AD_7DECIMAL(12,4)Y
32Entitle_over_AD_8DECIMAL(12,4)Y
33Entitle_over_AD_9DECIMAL(12,4)Y
34Entitle_over_AD_10DECIMAL(12,4)Y
35Entitle_over_AD_11DECIMAL(12,4)Y
36Entitle_over_AD_12DECIMAL(12,4)Y
37Entitle_over_AD_13DECIMAL(12,4)Y
38Entitle_over_AD_14DECIMAL(12,4)Y
39Entitle_over_AD_15DECIMAL(12,4)Y
40Entitle_over_AD_16DECIMAL(12,4)Y
41Entitle_over_AD_17DECIMAL(12,4)Y
42Entitle_over_AD_18DECIMAL(12,4)Y
43Entitle_over_AD_19DECIMAL(12,4)Y
44Entitle_over_AD_20DECIMAL(12,4)Y
45IN_ADVANCEBITN
46IN_ADVANCE_ADBITN
47START_MONTHSMALLINTY
48CREATE_BYCHAR(10)Y
49CREATE_DATEDATETIMEY
50LAST_UPDATE_BYCHAR(10)Y
51LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plLeaveEntitlement_CHECK_AL_BASED_ONCHECK_AL_BASED_ON('L')
2DF_plLeaveEntitlement_ENTITLEMENT_YEARENTITLEMENT_YEAR('A')
3DF_plLeaveEntitlement_IN_ADVANCEIN_ADVANCE((0))
4DF_plLeaveEntitlement_IN_ADVANCE_ADIN_ADVANCE_AD((0))

Triggers
Sr.NameDescription
1Tr_plLeaveEntitlement
2Tr_plLeaveEntitlement_Deleting

Indexes
Sr.NameTypeColumns
1PK_plLeaveEntitlementClusteredEntitlement_Code




Index
Table:[dbo].[plLeaveNature]

Description
Leave Nature Table

Table Columns
Sr.NameDatatypeNullableDescription
1NATURENVARCHAR(6)N
2TYPENCHAR(2)Y
3DESCRIPTIONNVARCHAR(120)Y

Indexes
Sr.NameTypeColumns
1PK_plLeaveNatureClusteredNATURE




Index
Table:[dbo].[plLeavePeriod]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMDATEY
3PERIOD_TODATEY
4CREATE_BYCHAR(10)N
5CREATE_DATEDATETIMEN
6LAST_UPDATE_BYCHAR(10)Y
7LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plLeavePeriod_1ClusteredPERIOD
2plLeavePeriod_INDEX1NonclusteredPERIOD_FROM
3plLeavePeriod_INDEX2NonclusteredPERIOD_TO




Index
Table:[dbo].[plLeaveType]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1LEAVE_CODENVARCHAR(24)N
2DESCRIPTIONNVARCHAR(120)N
3NATURENVARCHAR(6)N
4HRPRO_REQUIRED_ATTACHMENTBITN
5WEBLEAVE_DECIMALINTY
6WEBLEAVE_VISIBLEBITN
7WEBLEAVE_CALENDAR_VISIBLEBITN
8WEBLEAVE_ALLOW_BACKDATE_APPLICATIONBITN
9WEBLEAVE_REQUIRE_OT_INFOBITN
10WEBLEAVE_MAX_HRS_PER_YEARDECIMAL(18,2)Y
11WEBLEAVE_MAX_DAYS_PER_YEARDECIMAL(18,4)N
12WEBLEAVE_START_MONTH_FOR_MAX_HRSINTN
13WEBLEAVE_REQUIRED_ATTACHMENTBITN
14WEBLEAVE_REQUIRED_REMARKSBITN
15WEBLEAVE_MINIMUM_DAYSINTN
16WEBLEAVE_MINIMUM_MINUTESINTN
17WEBLEAVE_MAXIMUM_MINUTESINTN
18WEBLEAVE_MAXIMUM_DAYSINTN
19WEBLEAVE_MAXIMUM_DAYS_SHOW_BALANCEBITN
20WEBLEAVE_EXPLANATIONNVARCHAR(500)Y
21WEBLEAVE_DISALLOW_LEAVE_APPLICATION_WHEN_ZERO_BALANCEBITN
22WEBLEAVE_MAXIMUM_NEGATIVE_BALANCEINTN
23WEBLEAVE_WARNING_WHEN_ZERO_BALANCEBITN
24WEBLEAVE_MINIMUM_DAYS_BETWEEN_APPLY_DATE_AND_LEAVE_DATEINTN
25WEBLEAVE_MAXIMUM_DAYS_BETWEEN_LEAVE_DATE_AND_APPLY_DATEINTN
26WEBLEAVE_BY_WHOLEDAYBITN
27WEBLEAVE_BY_AMPMBITN
28WEBLEAVE_BY_TIMEBITN
29WEBLEAVE_ALLOW_TO_APPLY_AFTERINTN
30WEBLEAVE_MAXIMUM_CLAIM_AMOUNTDECIMAL(18,2)N
31WEBLEAVE_ALLOW_TAKE_LEAVE_DURING_THE_MONTH_OF_BIRTHDAY_ONLYBITN
32WEBLEAVE_AUTO_APPROVALBITN
33WEBLEAVE_ENABLE_DRILLDOWN_ON_CALENDARBITN
34WEBLEAVE_LEAVE_HOURS_MULTIPLIERDECIMAL(18,4)N
35WEBLEAVE_ENABLE_1_MIN_INCREMENTSBITN
36WEBLEAVE_APPROVER_NO1_ASINTN
37WEBLEAVE_APPROVER_NO2_ASINTN
38WEBLEAVE_APPROVER_NO3_ASINTN
39WEBLEAVE_APPROVAL_WORKFLOWINTN
40EXPENSE_PAYTYPEINTN
41EXPENSE_PAYTYPE_TABLE_DESCNVARCHAR(100)N
42CREATE_BYCHAR(10)N
43CREATE_DATEDATETIMEN
44LAST_UPDATE_BYCHAR(10)Y
45LAST_UPDATE_DATEDATETIMEY
46WEBLEAVE_FOR_INOUTTIME_OVERWRITE_REQUESTBITN
47WEBLEAVE_DISABLE_LEAVE_BY_TIMEBITNobsoleted
48WEBLEAVE_BY_TIME_ONLYBITNobsoleted

Default Constraints
Sr.NameColumnValue
1DF_plLeaveType_EXPENSE_PAYTYPEEXPENSE_PAYTYPE((0))
2DF_plLeaveType_EXPENSE_PAYTYPE_TABLE_DESCEXPENSE_PAYTYPE_TABLE_DESC('')
3DF_plLeaveType_HRPRO_REQUIRED_ATTACHMENTHRPRO_REQUIRED_ATTACHMENT((0))
4DF_plLeaveType_WEBLEAVE_ALLOW_BACKDATE_APPLICATIONWEBLEAVE_ALLOW_BACKDATE_APPLICATION((0))
5DF_plLeaveType_WEBLEAVE_ALLOW_TAKE_LEAVE_DURING_THE_MONTH_OF_BIRTHDAY_ONLYWEBLEAVE_ALLOW_TAKE_LEAVE_DURING_THE_MONTH_OF_BIRTHDAY_ONLY((0))
6DF_plLeaveType_WEBLEAVE_ALLOW_TO_APPLY_AFTERWEBLEAVE_ALLOW_TO_APPLY_AFTER((0))
7DF_plLeaveType_WEBLEAVE_APPROVAL_WORKFLOWWEBLEAVE_APPROVAL_WORKFLOW((-1))
8DF_plLeaveType_WEBLEAVE_APPROVER_NO1_ASWEBLEAVE_APPROVER_NO1_AS((1))
9DF_plLeaveType_WEBLEAVE_APPROVER_NO2_ASWEBLEAVE_APPROVER_NO2_AS((2))
10DF_plLeaveType_WEBLEAVE_APPROVER_NO3_ASWEBLEAVE_APPROVER_NO3_AS((3))
11DF_plLeaveType_WEBLEAVE_AUTO_APPROVALWEBLEAVE_AUTO_APPROVAL((0))
12DF_plLeaveType_WEBLEAVE_BY_AMPMWEBLEAVE_BY_AMPM((1))
13DF_plLeaveType_WEBLEAVE_BY_TIMEWEBLEAVE_BY_TIME((0))
14DF_plLeaveType_WEBLEAVE_BY_TIME_ONLYWEBLEAVE_BY_TIME_ONLY((0))
15DF_plLeaveType_WEBLEAVE_BY_WHOLEDAYWEBLEAVE_BY_WHOLEDAY((1))
16DF_plLeaveType_WEBLEAVE_CALENDAR_VISIBLEWEBLEAVE_CALENDAR_VISIBLE((0))
17DF_plLeaveType_WEBLEAVE_DISABLE_LEAVE_BY_TIMEWEBLEAVE_DISABLE_LEAVE_BY_TIME((0))
18DF_plLeaveType_WEBLEAVE_DISALLOW_LEAVE_APPLICATION_WHEN_ZERO_BALANCEWEBLEAVE_DISALLOW_LEAVE_APPLICATION_WHEN_ZERO_BALANCE((0))
19DF_plLeaveType_WEBLEAVE_ENABLE_1_MIN_INCREMENTSWEBLEAVE_ENABLE_1_MIN_INCREMENTS((0))
20DF_plLeaveType_WEBLEAVE_ENABLE_DRILLDOWN_ON_CALENDARWEBLEAVE_ENABLE_DRILLDOWN_ON_CALENDAR((0))
21DF_plLeaveType_WEBLEAVE_EXPLANATIONWEBLEAVE_EXPLANATION('')
22DF_plLeaveType_WEBLEAVE_FOR_INOUTTIME_OVERWRITE_REQUESTWEBLEAVE_FOR_INOUTTIME_OVERWRITE_REQUEST((0))
23DF_plLeaveType_WEBLEAVE_LEAVE_HOURS_MULTIPLIERWEBLEAVE_LEAVE_HOURS_MULTIPLIER((0))
24DF_plLeaveType_WEBLEAVE_MAXIMUM_CLAIM_AMOUNTWEBLEAVE_MAXIMUM_CLAIM_AMOUNT((0))
25DF_plLeaveType_WEBLEAVE_MAXIMUM_DAYSWEBLEAVE_MAXIMUM_DAYS((0))
26DF_plLeaveType_WEBLEAVE_MAXIMUM_DAYS_BETWEEN_LEAVE_DATE_AND_APPLY_DATEWEBLEAVE_MAXIMUM_DAYS_BETWEEN_LEAVE_DATE_AND_APPLY_DATE((0))
27DF_plLeaveType_WEBLEAVE_MAXIMUM_DAYS_PER_YEARWEBLEAVE_MAX_DAYS_PER_YEAR((0))
28DF_plLeaveType_WEBLEAVE_MAXIMUM_DAYS_SHOW_BALANCEWEBLEAVE_MAXIMUM_DAYS_SHOW_BALANCE((0))
29DF_plLeaveType_WEBLEAVE_MAXIMUM_MINUTESWEBLEAVE_MAXIMUM_MINUTES((0))
30DF_plLeaveType_WEBLEAVE_MAXIMUM_NEGATIVE_BALANCEWEBLEAVE_MAXIMUM_NEGATIVE_BALANCE((0))
31DF_plLeaveType_WEBLEAVE_MINIMUM_DAYSWEBLEAVE_MINIMUM_DAYS((0))
32DF_plLeaveType_WEBLEAVE_MINIMUM_DAYS_BETWEEN_APPLY_DATE_AND_LEAVE_DATEWEBLEAVE_MINIMUM_DAYS_BETWEEN_APPLY_DATE_AND_LEAVE_DATE((0))
33DF_plLeaveType_WEBLEAVE_MINIMUM_MINUTESWEBLEAVE_MINIMUM_MINUTES((0))
34DF_plLeaveType_WEBLEAVE_REQUIRE_OT_INFOWEBLEAVE_REQUIRE_OT_INFO((0))
35DF_plLeaveType_WEBLEAVE_REQUIRED_ATTACHMENTWEBLEAVE_REQUIRED_ATTACHMENT((0))
36DF_plLeaveType_WEBLEAVE_REQUIRED_REMARKSWEBLEAVE_REQUIRED_REMARKS((0))
37DF_plLeaveType_WEBLEAVE_START_MONTH_FOR_MAX_HRSWEBLEAVE_START_MONTH_FOR_MAX_HRS((1))
38DF_plLeaveType_WEBLEAVE_VISIBLEWEBLEAVE_VISIBLE((0))
39DF_plLeaveType_WEBLEAVE_WARNING_WHEN_ZERO_BALANCEWEBLEAVE_WARNING_WHEN_ZERO_BALANCE((0))

Triggers
Sr.NameDescription
1plLeaveType_UpdateLeaveDayRecord
2Tr_plLeaveType
3Tr_plLeaveType_Deleting

Indexes
Sr.NameTypeColumns
1PK_plLeaveTypeClusteredLEAVE_CODE
2plLeaveType_INDEX1NonclusteredNATURE
3plLeaveType_INDEX2NonclusteredWEBLEAVE_VISIBLE




Index
Table:[dbo].[plMPFRules]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODNVARCHAR(14)N
2MPF_MINIMUMDECIMAL(18,2)Y
3MPF_MAXIMUMDECIMAL(18,2)Y
4MPF_FIXED_AMTDECIMAL(18,2)Y
5MPF_MINIMUM_DAILYDECIMAL(18,2)Y
6MPF_MAXIMUM_DAILYDECIMAL(18,2)Y

Indexes
Sr.NameTypeColumns
1PK_plMPFRulesClusteredPERIOD




Index
Table:[dbo].[plMPFSP]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1MPF_SP_CODENVARCHAR(20)N
2MPF_SP_NAMENVARCHAR(120)Y
3MPF_SP_CHINESE_NAMENVARCHAR(120)Y
4MPF_SP_ADDRESSNVARCHAR(510)Y
5MPF_SP_PHONENVARCHAR(40)Y
6MPF_SP_FAXNVARCHAR(40)Y
7MPF_SP_FORMATNVARCHAR(20)Y
8MPF_SP_IDNVARCHAR(40)Y
9MPF_SP_TRUSTEE_BANK_AC_NONVARCHAR(40)Y
10MPF_SP_STATEMENT_FORMATNCHAR(2)Y
11MPF_EMPLOYER_IDNVARCHAR(40)Y
12MPF_PLAN_NONVARCHAR(40)Y
13MPF_BENEFIT_PLAN_NONVARCHAR(40)Y
14MPF_EMPLOYER_PARTICIPATIONNVARCHAR(100)Y
15MPF_SCHEME_REGISTRATION_NONVARCHAR(200)Y
16MPF_CONTACT_PERSONNVARCHAR(100)Y
17MPF_USE_CERT_NO_AS_EE_NOBITN
18MPF_FORM_NONVARCHAR(20)Y
19MPF_SEQUENCE_NOINTN
20MPF_TEMPLATE_FILE_NAMENVARCHAR(200)Y
21MPF_COMPANY_NAMENVARCHAR(120)N
22CREATE_BYCHAR(10)N
23CREATE_DATEDATETIMEN
24LAST_UPDATE_BYCHAR(10)Y
25LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plMPFSP_MPF_COMPANY_NAMEMPF_COMPANY_NAME('')
2DF_plMPFSP_MPF_SEQUENCE_NOMPF_SEQUENCE_NO((0))
3DF_plMPFSP_MPF_USE_CERT_NO_AS_EE_NOMPF_USE_CERT_NO_AS_EE_NO((0))

Triggers
Sr.NameDescription
1Tr_plMPFSP
2Tr_plMPFSP_Deleting

Indexes
Sr.NameTypeColumns
1PK_plMPFSPClusteredMPF_SP_CODE




Index
Table:[dbo].[plOT]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1OT_TYPENVARCHAR(20)N
2DESCRIPTIONNVARCHAR(100)N
3FORMULANVARCHAR(4000)Y
4OT_UNITNVARCHAR(10)Y
5CREATE_BYCHAR(10)N
6CREATE_DATEDATETIMEN
7LAST_UPDATE_BYCHAR(10)Y
8LAST_UPDATE_DATEDATETIMEY
9OT_BASED_ONSMALLINTYobsoleted
10PAY_TYPEVARCHAR(20)Yobsoleted
11PAY_RATEDECIMAL(18,2)Yobsoleted
12OT_RATE_FACTORDECIMAL(18,10)Yobsoleted

Default Constraints
Sr.NameColumnValue
1DF_plOT_DESCRIPTIONDESCRIPTION('')
2DF_plOT_OT_BASED_ONOT_BASED_ON((5))
3DF_plOT_OT_UNITOT_UNIT(N'hrs')

Triggers
Sr.NameDescription
1Tr_plOT
2Tr_plOT_Deleting
3Tr_plOT_Validating

Indexes
Sr.NameTypeColumns
1PK_plOTClusteredOT_TYPE




Index
Table:[dbo].[plPayroll]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2YEARSMALLINTY
3MONTHSMALLINTY
4PERIODVARCHAR(7)Y
5POSTEDBITN
6EE_NONVARCHAR(20)N
7SALARY_PAY_DATESMALLDATETIMEY
8BADGE_NONVARCHAR(40)Y
9CERT_NONVARCHAR(20)Y
10DEPT_CODENVARCHAR(24)Y
11DIVISION_CODENVARCHAR(24)Y
12EMPLOYER_CODENVARCHAR(24)N
13EE_CLASSNVARCHAR(24)Y
14WORK_LOCATIONNVARCHAR(20)Y
15SALARY_BYNVARCHAR(2)Y
16AUTOPAYNVARCHAR(2)Y
17CHEQUE_NONVARCHAR(100)Y
18BASIC_SAL_REFDECIMAL(23,9)Y
19BASIC_PAYDECIMAL(23,9)Y
20WORK_DAYSDECIMAL(18,4)Y
21BASIC_SALDECIMAL(23,9)Y
22PAY_RATEDECIMAL(23,9)Y
23WORK_TIMEDECIMAL(23,9)Y
24WORK_PAYDECIMAL(23,9)Y
25PAY_RATE_LMDECIMAL(23,9)Y
26WORK_TIME_LMDECIMAL(23,9)Y
27WORK_PAY_LMDECIMAL(23,9)Y
28PAY_RATE2DECIMAL(23,9)Y
29WORK_TIME2DECIMAL(23,9)Y
30WORK_PAY2DECIMAL(23,9)Y
31PAY_RATE3DECIMAL(23,9)Y
32WORK_TIME3DECIMAL(23,9)Y
33WORK_PAY3DECIMAL(23,9)Y
34PAY_RATE4DECIMAL(23,9)Y
35WORK_TIME4DECIMAL(23,9)Y
36WORK_PAY4DECIMAL(23,9)Y
37PAY_RATE5DECIMAL(23,9)Y
38WORK_TIME5DECIMAL(23,9)Y
39WORK_PAY5DECIMAL(23,9)Y
40PAY_RATE6DECIMAL(23,9)Y
41WORK_TIME6DECIMAL(23,9)Y
42WORK_PAY6DECIMAL(23,9)Y
43ALLOWANCE_DAYRATEDECIMAL(23,9)Y
44ALLOWANCEDECIMAL(23,9)Y
45ALLOWANCE2_DAYRATEDECIMAL(23,9)Y
46ALLOWANCE2DECIMAL(23,9)Y
47HDY_DAYRATEDECIMAL(23,9)Y
48HDY_LEAVEDECIMAL(18,4)Y
49HDY_PAYDECIMAL(23,9)Y
50ANN_DAYRATEDECIMAL(23,9)Y
51ANN_LEAVEDECIMAL(18,4)Y
52ANN_PAYDECIMAL(23,9)Y
53SICK_RATESMALLINTY
54SICK_DAYRATEDECIMAL(23,9)Y
55SICK_LEAVEDECIMAL(18,4)Y
56SICK_PAYDECIMAL(23,9)Y
57SICK_DAYRATE_LMDECIMAL(23,9)Y
58SICK_LEAVE_LMDECIMAL(18,4)Y
59SICK_PAY_LMDECIMAL(23,9)Y
60SICK_RATE2SMALLINTY
61SICK_DAYRATE2DECIMAL(23,9)Y
62SICK_LEAVE2DECIMAL(18,4)Y
63SICK_PAY2DECIMAL(23,9)Y
64SICK_DAYRATE2_LMDECIMAL(23,9)Y
65SICK_LEAVE2_LMDECIMAL(18,4)Y
66SICK_PAY2_LMDECIMAL(23,9)Y
67MATERNITYLEAVE_RATESMALLINTY
68MATERNITYLEAVE_DAYRATEDECIMAL(23,9)Y
69MATERNITYLEAVE_DAYDECIMAL(18,4)Y
70MATERNITYLEAVE_PAYDECIMAL(23,9)Y
71MATERNITYLEAVE_DAYRATE_LMDECIMAL(23,9)Y
72MATERNITYLEAVE_DAY_LMDECIMAL(18,4)Y
73MATERNITYLEAVE_PAY_LMDECIMAL(23,9)Y
74OT_RATEDECIMAL(23,9)Y
75OT_HRSDECIMAL(23,9)Y
76OT_PAYDECIMAL(23,9)Y
77OT_RATE2DECIMAL(23,9)Y
78OT_HRS2DECIMAL(23,9)Y
79OT_PAY2DECIMAL(23,9)Y
80OT_RATE3DECIMAL(23,9)Y
81OT_HRS3DECIMAL(23,9)Y
82OT_PAY3DECIMAL(23,9)Y
83OT_RATE4DECIMAL(23,9)Y
84OT_HRS4DECIMAL(23,9)Y
85OT_PAY4DECIMAL(23,9)Y
86OT_RATE5DECIMAL(23,9)Y
87OT_HRS5DECIMAL(23,9)Y
88OT_PAY5DECIMAL(23,9)Y
89OT_RATE6DECIMAL(23,9)Y
90OT_HRS6DECIMAL(23,9)Y
91OT_PAY6DECIMAL(23,9)Y
92OT_RATE7DECIMAL(23,9)Y
93OT_HRS7DECIMAL(23,9)Y
94OT_PAY7DECIMAL(23,9)Y
95OT_RATE8DECIMAL(23,9)Y
96OT_HRS8DECIMAL(23,9)Y
97OT_PAY8DECIMAL(23,9)Y
98DEDUCTION_RATEDECIMAL(23,9)Y
99DEDUCTION_MINSDECIMAL(23,9)Y
100DEDUCTION_AMTDECIMAL(23,9)Y
101DOUBLE_PAYDECIMAL(23,9)Y
102BONUSDECIMAL(23,9)Y
103WAGES_IN_LIEU_DAYRATEDECIMAL(23,9)Y
104WAGES_IN_LIEU_DAYSDECIMAL(18,4)Y
105WAGES_IN_LIEU_PAYDECIMAL(23,9)Y
106WAGES_IN_LIEU_MONTHRATEDECIMAL(23,9)N
107WAGES_IN_LIEU_MONTHSDECIMAL(18,4)N
108WAGES_IN_LIEU_BY_MONTH_PAYDECIMAL(23,9)N
109LSP_SP_PAYDECIMAL(23,9)Y
110NOPAY_RATEDECIMAL(23,9)Y
111NOPAY_HRSDECIMAL(23,9)Y
112NOPAY_PAYDECIMAL(23,9)Y
113NOPAY_RATE_LMDECIMAL(23,9)Y
114NOPAY_HRS_LMDECIMAL(23,9)Y
115NOPAY_PAY_LMDECIMAL(23,9)Y
116NOPAY_PAY_BYCHAR(1)Y
117PAY_TYPE1_DESCNVARCHAR(100)Y
118PAY_TYPE1_AMTDECIMAL(23,9)Y
119PAY_TYPE2_DESCNVARCHAR(100)Y
120PAY_TYPE2_AMTDECIMAL(23,9)Y
121PAY_TYPE3_DESCNVARCHAR(100)Y
122PAY_TYPE3_AMTDECIMAL(23,9)Y
123PAY_TYPE4_DESCNVARCHAR(100)Y
124PAY_TYPE4_AMTDECIMAL(23,9)Y
125PAY_TYPE5_DESCNVARCHAR(100)Y
126PAY_TYPE5_AMTDECIMAL(23,9)Y
127PAY_TYPE6_DESCNVARCHAR(100)Y
128PAY_TYPE6_AMTDECIMAL(23,9)Y
129PAY_TYPE7_DESCNVARCHAR(100)Y
130PAY_TYPE7_AMTDECIMAL(23,9)Y
131PAY_TYPE8_DESCNVARCHAR(100)Y
132PAY_TYPE8_AMTDECIMAL(23,9)Y
133PAY_TYPE9_DESCNVARCHAR(100)Y
134PAY_TYPE9_AMTDECIMAL(23,9)Y
135PAY_TYPE10_DESCNVARCHAR(100)Y
136PAY_TYPE10_AMTDECIMAL(23,9)Y
137PAY_TYPE11_DESCNVARCHAR(100)Y
138PAY_TYPE11_AMTDECIMAL(23,9)Y
139PAY_TYPE12_DESCNVARCHAR(100)Y
140PAY_TYPE12_AMTDECIMAL(23,9)Y
141PAY_TYPE13_DESCNVARCHAR(100)Y
142PAY_TYPE13_AMTDECIMAL(23,9)Y
143PAY_TYPE14_DESCNVARCHAR(100)Y
144PAY_TYPE14_AMTDECIMAL(23,9)Y
145PAY_TYPE15_DESCNVARCHAR(100)Y
146PAY_TYPE15_AMTDECIMAL(23,9)Y
147RESTDAY_PAYDECIMAL(23,9)Y
148LUNCHBREAK_PAYDECIMAL(23,9)Y
149MPF_AUTOCALINTY
150MPF_CPERD1SMALLDATETIMEY
151MPF_CPERD2SMALLDATETIMEY
152PFUND_TYPENVARCHAR(20)Y
153PFUND_EEDECIMAL(23,9)Y
154PFUND_ERDECIMAL(23,9)Y
155PFUND_EE_PAYDECIMAL(23,9)Y
156PFUND_EE_PAY_RETENTIONDECIMAL(23,9)Y
157PFUND_ER_PAYDECIMAL(23,9)Y
158PFUND_ER_PAY_RETENTIONDECIMAL(23,9)Y
159MPF_VLYEEDECIMAL(23,9)Y
160MPF_VLYEE_RETENTIONDECIMAL(23,9)Y
161MPF_VLYERDECIMAL(23,9)Y
162MPF_VLYER_RETENTIONDECIMAL(23,9)Y
163Voluntary_EEDECIMAL(23,9)Y
164Voluntary_ERDECIMAL(23,9)Y
165EEVC_SIGNCHAR(1)Y
166ERVC_SIGNCHAR(1)Y
167MPF_INCOMEDECIMAL(23,9)Y
168MPF_OPTIONAL_INCOMEDECIMAL(23,9)Y
169TOTAL_PAYDECIMAL(23,9)Y
170HOURLY_EE_REGARDED_DAYSDECIMAL(18,2)Y
171WORKED_HRSDECIMAL(18,2)Y
172COST_CENTRENVARCHAR(60)Y
173PF_EE_PERCENTNVARCHAR(40)Y
174PF_ER_PERCENTNVARCHAR(40)Y
175TOTAL_DEDUCTION_MINSDECIMAL(23,9)Y
176LSP_SP_FLAGNCHAR(2)Y
177REMARKNVARCHAR(2048)Y
178REMARKS2NVARCHAR(2048)Y
179CREATE_BYCHAR(10)N
180CREATE_DATEDATETIMEN
181LAST_UPDATE_BYCHAR(10)Y
182LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPayroll_ENTITY_CODEEMPLOYER_CODE('')
2DF_plPayroll_LSP_SP_FLAGLSP_SP_FLAG(N'N')
3DF_plPayroll_LSP_SP_PAYLSP_SP_PAY((0))
4DF_plPayroll_POSTEDPOSTED((0))
5DF_plPayroll_WAGES_IN_LIEU_MONTHRATEWAGES_IN_LIEU_MONTHRATE((0))
6DF_plPayroll_WAGES_IN_LIEU_MONTHSWAGES_IN_LIEU_MONTHS((0))
7DF_plPayroll_WAGES_IN_LIEU_PAY_BY_MONTHWAGES_IN_LIEU_BY_MONTH_PAY((0))

Triggers
Sr.NameDescription
1Tr_plPayroll
2Tr_plPayrollChangeLog
3Tr_plPayrollChangeLog_Delete

Indexes
Sr.NameTypeColumns
1PK_plPayrollClusteredBATCH_NO
EE_NO
2plPayroll_INDEX1NonclusteredDEPT_CODE
3plPayroll_INDEX10NonclusteredBATCH_NO
YEAR
MONTH
EE_NO
DEPT_CODE
4plPayroll_Index11NonclusteredEE_NO
5plPayroll_INDEX12NonclusteredPOSTED
EE_NO
6plPayroll_INDEX13NonclusteredPERIOD
EE_NO
PFUND_TYPE
PFUND_EE_PAY
PFUND_ER_PAY
MPF_VLYEE
MPF_VLYER
PF_EE_PERCENT
7plPayroll_INDEX14NonclusteredBATCH_NO
YEAR
MONTH
PERIOD
EE_NO
SALARY_PAY_DATE
DEPT_CODE
MPF_CPERD1
MPF_CPERD2
PFUND_TYPE
PFUND_EE
PFUND_ER
PFUND_EE_PAY
PFUND_EE_PAY_RETENTION
PFUND_ER_PAY
PFUND_ER_PAY_RETENTION
MPF_VLYEE
MPF_VLYEE_RETENTION
MPF_VLYER
MPF_VLYER_RETENTION
Voluntary_EE
Voluntary_ER
EEVC_SIGN
ERVC_SIGN
MPF_INCOME
MPF_OPTIONAL_INCOME
TOTAL_PAY
PF_EE_PERCENT
8plPayroll_INDEX15NonclusteredSALARY_BY
9plPayroll_INDEX2NonclusteredYEAR
MONTH
POSTED
EE_NO
10plPayroll_INDEX3NonclusteredPOSTED
11plPayroll_INDEX4NonclusteredYEAR
MONTH
EE_NO
12plPayroll_INDEX5NonclusteredBATCH_NO
CREATE_DATE
13plPayroll_INDEX6NonclusteredPERIOD
EE_NO
14plPayroll_INDEX7NonclusteredLAST_UPDATE_DATE
15plPayroll_Index8NonclusteredEE_CLASS
16plPayroll_INDEX9NonclusteredSALARY_PAY_DATE




Index
Table:[dbo].[plPayrollBatch]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2PERIODCHAR(7)Y
3YEARSMALLINTY
4MONTHSMALLINTY
5POSTEDBITN
6SALARY_PAY_DATESMALLDATETIMEY
7MPF_CONTRIBUTION_DATESMALLDATETIMEY
8CREATE_BYCHAR(10)N
9CREATE_DATEDATETIMEN
10LAST_UPDATE_BYCHAR(10)Y
11LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPayrollBatch_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1Tr_plPayrollBatch
2Tr_plPayrollBatchChangeLog

Indexes
Sr.NameTypeColumns
1PK_plPayrollBatchClusteredBATCH_NO
2plPayrollBatch_INDEX1NonclusteredPERIOD




Index
Table:[dbo].[plPayrollChangeLog]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialINTN
2BATCH_NONCHAR(24)Y
3EE_NONVARCHAR(20)Y
4EventDateTimeDATETIMEN
5UserIDCHAR(10)N
6FieldNVARCHAR(100)Y
7OriginalValuesNVARCHAR(8000)Y
8NewValuesNVARCHAR(8000)Y

Indexes
Sr.NameTypeColumns
1PK_plPayrollChangeLogClusteredRowSerial




Index
Table:[dbo].[plPayType]

Description
Pay Type Group Table

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2PAY_TYPENVARCHAR(100)N
3PAY_TYPE_GROUPINTN
4PAY_TYPE_VISIBLEBITN
5PAY_TYPE_WAGEBITN
6PAY_TYPE_TAXBITN
7PAY_TYPE_MPFBITN
8PAY_TYPE_SMWBITN
9PAY_TYPE_CATVARCHAR(2)N
10PAY_TYPE_CATMVARCHAR(2)N
11CREATE_BYCHAR(10)Y
12CREATE_DATEDATETIMEY
13LAST_UPDATE_BYCHAR(10)Y
14LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPayType_PAY_TYPE_CATPAY_TYPE_CAT('A')
2DF_plPayType_PAY_TYPE_CATMPAY_TYPE_CATM('')
3DF_plPayType_PAY_TYPE_GROUPPAY_TYPE_GROUP((0))
4DF_plPayType_PAY_TYPE_MPFPAY_TYPE_MPF((1))
5DF_plPayType_PAY_TYPE_SMWPAY_TYPE_SMW((1))
6DF_plPayType_PAY_TYPE_TAXPAY_TYPE_TAX((1))
7DF_plPayType_PAY_TYPE_VISIBLEPAY_TYPE_VISIBLE((1))
8DF_plPayType_PAY_TYPE_WAGEPAY_TYPE_WAGE((1))

Triggers
Sr.NameDescription
1Tr_plPayType_Deleting

Indexes
Sr.NameTypeColumns
1PK_plPayTypeNonclusteredRowSerial
2plPayType_Index1ClusteredPAY_TYPE
3plPayType_Index2NonclusteredPAY_TYPE
PAY_TYPE_GROUP
4plPayType_Index3NonclusteredPAY_TYPE_GROUP




Index
Table:[dbo].[plPayTypeAccount]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2plPayType_RowSerialDECIMAL(18,0)N
3COST_CENTRENVARCHAR(60)N
4PAY_TYPE_ACCOUNTVARCHAR(10)N
5PAY_TYPE_SUBACCOUNTVARCHAR(12)N

Default Constraints
Sr.NameColumnValue
1DF_plPayTypeAccount_PAY_TYPE_ACCOUNTPAY_TYPE_ACCOUNT('')
2DF_plPayTypeAccount_PAY_TYPE_SUBACCOUNTPAY_TYPE_SUBACCOUNT('')

Indexes
Sr.NameTypeColumns
1PK_plPayTypeAccountClusteredTS_KEY




Index
Table:[dbo].[plPeriod]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMDATEY
3PERIOD_TODATEY
4WORKDAYDECIMAL(18,1)Y
5HOLIDAYSMALLINTY
6CREATE_BYCHAR(10)N
7CREATE_DATEDATETIMEN
8LAST_UPDATE_BYCHAR(10)Y
9LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plPeriodClusteredPERIOD
2plPeriod_Index1NonclusteredPERIOD_TO
3plPeriod_Index2NonclusteredPERIOD_FROM




Index
Table:[dbo].[plPosition]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2POSITIONNVARCHAR(200)N
3DEPT_CODENVARCHAR(24)Y
4JOB_DESCRIPTIONNVARCHAR(-1)Y
5REQUIREMENTSNVARCHAR(-1)Y
6EXPECTED_EMPLOYEESINTY
7CREATE_BYCHAR(10)Y
8CREATE_DATEDATETIMEY
9LAST_UPDATE_BYCHAR(10)Y
10LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPosition_DEPT_CODEDEPT_CODE('')
2DF_plPosition_EXPECTED_EMPLOYEESEXPECTED_EMPLOYEES((0))
3DF_plPosition_JOB_DESCRIPTIONJOB_DESCRIPTION('')
4DF_plPosition_REQUIREMENTSREQUIREMENTS('')

Triggers
Sr.NameDescription
1plPosition_HandleReseedofIdentity
2Tr_plPosition

Indexes
Sr.NameTypeColumns
1PK_plPositionClusteredRowSerial




Index
Table:[dbo].[plPrePaidPayroll]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2YEARSMALLINTY
3MONTHSMALLINTY
4PERIODVARCHAR(7)Y
5POSTEDBITN
6EE_NONVARCHAR(20)N
7SALARY_PAY_DATESMALLDATETIMEY
8BADGE_NONVARCHAR(40)Y
9CERT_NONVARCHAR(20)Y
10DEPT_CODENVARCHAR(24)Y
11DIVISION_CODENVARCHAR(24)Y
12EMPLOYER_CODENVARCHAR(24)N
13EE_CLASSNVARCHAR(24)Y
14WORK_LOCATIONNVARCHAR(20)Y
15SALARY_BYNVARCHAR(2)Y
16AUTOPAYNVARCHAR(2)Y
17CHEQUE_NONVARCHAR(20)Y
18BASIC_SAL_REFDECIMAL(23,9)Y
19BASIC_PAYDECIMAL(23,9)Y
20WORK_DAYSDECIMAL(18,4)Y
21BASIC_SALDECIMAL(23,9)Y
22PAY_RATEDECIMAL(23,9)Y
23WORK_TIMEDECIMAL(23,9)Y
24WORK_PAYDECIMAL(23,9)Y
25PAY_RATE2DECIMAL(23,9)Y
26WORK_TIME2DECIMAL(23,9)Y
27WORK_PAY2DECIMAL(23,9)Y
28PAY_RATE3DECIMAL(23,9)Y
29WORK_TIME3DECIMAL(23,9)Y
30WORK_PAY3DECIMAL(23,9)Y
31PAY_RATE4DECIMAL(23,9)Y
32WORK_TIME4DECIMAL(23,9)Y
33WORK_PAY4DECIMAL(23,9)Y
34PAY_RATE5DECIMAL(23,9)Y
35WORK_TIME5DECIMAL(23,9)Y
36WORK_PAY5DECIMAL(23,9)Y
37PAY_RATE6DECIMAL(23,9)Y
38WORK_TIME6DECIMAL(23,9)Y
39WORK_PAY6DECIMAL(23,9)Y
40ALLOWANCE_DAYRATEDECIMAL(23,9)Y
41ALLOWANCEDECIMAL(23,9)Y
42ALLOWANCE2_DAYRATEDECIMAL(23,9)Y
43ALLOWANCE2DECIMAL(23,9)Y
44HDY_DAYRATEDECIMAL(23,9)Y
45HDY_LEAVEDECIMAL(18,4)Y
46HDY_PAYDECIMAL(23,9)Y
47ANN_DAYRATEDECIMAL(23,9)Y
48ANN_LEAVEDECIMAL(18,4)Y
49ANN_PAYDECIMAL(23,9)Y
50SICK_RATESMALLINTY
51SICK_DAYRATEDECIMAL(23,9)Y
52SICK_LEAVEDECIMAL(18,4)Y
53SICK_PAYDECIMAL(23,9)Y
54SICK_RATE2SMALLINTY
55SICK_DAYRATE2DECIMAL(23,9)Y
56SICK_LEAVE2DECIMAL(18,4)Y
57SICK_PAY2DECIMAL(23,9)Y
58MATERNITYLEAVE_RATESMALLINTY
59MATERNITYLEAVE_DAYRATEDECIMAL(23,9)Y
60MATERNITYLEAVE_DAYDECIMAL(18,4)Y
61MATERNITYLEAVE_PAYDECIMAL(23,9)Y
62OT_RATEDECIMAL(23,9)Y
63OT_HRSDECIMAL(23,9)Y
64OT_PAYDECIMAL(23,9)Y
65OT_RATE2DECIMAL(23,9)Y
66OT_HRS2DECIMAL(23,9)Y
67OT_PAY2DECIMAL(23,9)Y
68OT_RATE3DECIMAL(23,9)Y
69OT_HRS3DECIMAL(23,9)Y
70OT_PAY3DECIMAL(23,9)Y
71OT_RATE4DECIMAL(23,9)Y
72OT_HRS4DECIMAL(23,9)Y
73OT_PAY4DECIMAL(23,9)Y
74OT_RATE5DECIMAL(23,9)Y
75OT_HRS5DECIMAL(23,9)Y
76OT_PAY5DECIMAL(23,9)Y
77OT_RATE6DECIMAL(23,9)Y
78OT_HRS6DECIMAL(23,9)Y
79OT_PAY6DECIMAL(23,9)Y
80OT_RATE7DECIMAL(23,9)Y
81OT_HRS7DECIMAL(23,9)Y
82OT_PAY7DECIMAL(23,9)Y
83OT_RATE8DECIMAL(23,9)Y
84OT_HRS8DECIMAL(23,9)Y
85OT_PAY8DECIMAL(23,9)Y
86DEDUCTION_RATEDECIMAL(23,9)Y
87DEDUCTION_MINSDECIMAL(23,9)Y
88DEDUCTION_AMTDECIMAL(23,9)Y
89DOUBLE_PAYDECIMAL(23,9)Y
90BONUSDECIMAL(23,9)Y
91WAGES_IN_LIEU_DAYRATEDECIMAL(23,9)Y
92WAGES_IN_LIEU_DAYSDECIMAL(18,4)Y
93WAGES_IN_LIEU_PAYDECIMAL(23,9)Y
94WAGES_IN_LIEU_MONTHRATEDECIMAL(23,9)N
95WAGES_IN_LIEU_MONTHSDECIMAL(18,4)N
96WAGES_IN_LIEU_BY_MONTH_PAYDECIMAL(23,9)N
97LSP_SP_PAYDECIMAL(23,9)Y
98NOPAY_RATEDECIMAL(23,9)Y
99NOPAY_HRSDECIMAL(23,9)Y
100NOPAY_PAYDECIMAL(23,9)Y
101NOPAY_PAY_BYCHAR(1)Y
102PAY_TYPE1_DESCNVARCHAR(100)Y
103PAY_TYPE1_AMTDECIMAL(23,9)Y
104PAY_TYPE2_DESCNVARCHAR(100)Y
105PAY_TYPE2_AMTDECIMAL(23,9)Y
106PAY_TYPE3_DESCNVARCHAR(100)Y
107PAY_TYPE3_AMTDECIMAL(23,9)Y
108PAY_TYPE4_DESCNVARCHAR(100)Y
109PAY_TYPE4_AMTDECIMAL(23,9)Y
110PAY_TYPE5_DESCNVARCHAR(100)Y
111PAY_TYPE5_AMTDECIMAL(23,9)Y
112PAY_TYPE6_DESCNVARCHAR(100)Y
113PAY_TYPE6_AMTDECIMAL(23,9)Y
114PAY_TYPE7_DESCNVARCHAR(100)Y
115PAY_TYPE7_AMTDECIMAL(23,9)Y
116PAY_TYPE8_DESCNVARCHAR(100)Y
117PAY_TYPE8_AMTDECIMAL(23,9)Y
118PAY_TYPE9_DESCNVARCHAR(100)Y
119PAY_TYPE9_AMTDECIMAL(23,9)Y
120PAY_TYPE10_DESCNVARCHAR(100)Y
121PAY_TYPE10_AMTDECIMAL(23,9)Y
122PAY_TYPE11_DESCNVARCHAR(100)Y
123PAY_TYPE11_AMTDECIMAL(23,9)Y
124PAY_TYPE12_DESCNVARCHAR(100)Y
125PAY_TYPE12_AMTDECIMAL(23,9)Y
126PAY_TYPE13_DESCNVARCHAR(100)Y
127PAY_TYPE13_AMTDECIMAL(23,9)Y
128PAY_TYPE14_DESCNVARCHAR(100)Y
129PAY_TYPE14_AMTDECIMAL(23,9)Y
130PAY_TYPE15_DESCNVARCHAR(100)Y
131PAY_TYPE15_AMTDECIMAL(23,9)Y
132RESTDAY_PAYDECIMAL(23,9)Y
133LUNCHBREAK_PAYDECIMAL(23,9)Y
134MPF_AUTOCALINTY
135MPF_CPERD1SMALLDATETIMEY
136MPF_CPERD2SMALLDATETIMEY
137PFUND_TYPENVARCHAR(20)Y
138PFUND_EEDECIMAL(23,9)Y
139PFUND_ERDECIMAL(23,9)Y
140PFUND_EE_PAYDECIMAL(23,9)Y
141PFUND_EE_PAY_RETENTIONDECIMAL(23,9)Y
142PFUND_ER_PAYDECIMAL(23,9)Y
143PFUND_ER_PAY_RETENTIONDECIMAL(23,9)Y
144MPF_VLYEEDECIMAL(23,9)Y
145MPF_VLYEE_RETENTIONDECIMAL(23,9)Y
146MPF_VLYERDECIMAL(23,9)Y
147MPF_VLYER_RETENTIONDECIMAL(23,9)Y
148PF_EE_PERCENTNVARCHAR(40)Y
149PF_ER_PERCENTNVARCHAR(40)Y
150Voluntary_EEDECIMAL(23,9)Y
151Voluntary_ERDECIMAL(23,9)Y
152EEVC_SIGNCHAR(1)Y
153ERVC_SIGNCHAR(1)Y
154MPF_INCOMEDECIMAL(23,9)Y
155TOTAL_PAYDECIMAL(23,9)Y
156HOURLY_EE_REGARDED_DAYSDECIMAL(18,2)Y
157WORKED_HRSDECIMAL(18,2)Y
158COST_CENTRENVARCHAR(60)Y
159TOTAL_DEDUCTION_MINSDECIMAL(23,9)Y
160LSP_SP_FLAGNCHAR(2)Y
161REMARKNVARCHAR(2048)Y
162REMARKS2NVARCHAR(2048)Y
163CREATE_BYCHAR(10)N
164CREATE_DATEDATETIMEN
165LAST_UPDATE_BYCHAR(10)Y
166LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPrePaidPayroll_ENTITY_CODEEMPLOYER_CODE('')
2DF_plPrePaidPayroll_LSP_SP_FLAGLSP_SP_FLAG(N'N')
3DF_plPrePaidPayroll_LSP_SP_PAYLSP_SP_PAY((0))
4DF_plPrePaidPayroll_POSTEDPOSTED((0))
5DF_plPrePaidPayroll_WAGES_IN_LIEU_BY_MONTH_PAYWAGES_IN_LIEU_BY_MONTH_PAY((0))
6DF_plPrePaidPayroll_WAGES_IN_LIEU_MONTHRATEWAGES_IN_LIEU_MONTHRATE((0))
7DF_plPrePaidPayroll_WAGES_IN_LIEU_MONTHSWAGES_IN_LIEU_MONTHS((0))

Triggers
Sr.NameDescription
1Tr_plPrePaidPayroll_Delete
2Tr_plPrepaidPayrollChangeLog
3Tr_plPrePaidPayrollChangeLog_Delete
4Tr_plPrepaidPayrollPayType

Indexes
Sr.NameTypeColumns
1PK_plPrepaidPayrollClusteredBATCH_NO
EE_NO
2plPrePaidPayroll_Index1NonclusteredMONTH
3plPrePaidPayroll_INDEX2NonclusteredEE_NO
4plPrepaidPayroll_INDEX3NonclusteredYEAR
MONTH
POSTED
EE_NO
5plPrepaidPayroll_INDEX4NonclusteredDEPT_CODE
6plPrePaidPayroll_INDEX5NonclusteredYEAR
7plPrePaidPayroll_INDEX6NonclusteredPOSTED




Index
Table:[dbo].[plPrepaidPayrollBatch]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2PERIODCHAR(7)Y
3YEARSMALLINTY
4MONTHSMALLINTY
5POSTEDBITN
6SALARY_PAY_DATESMALLDATETIMEY
7MPF_CONTRIBUTION_DATESMALLDATETIMEY
8CREATE_BYCHAR(10)N
9CREATE_DATEDATETIMEN
10LAST_UPDATE_BYCHAR(10)Y
11LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPrepaidPayrollBatch_POSTEDPOSTED((0))

Triggers
Sr.NameDescription
1Tr_plPrepaidPayrollBatch
2Tr_plPrepaidPayrollBatch_Delete
3Tr_plPrepaidPayrollBatchChangeLog

Indexes
Sr.NameTypeColumns
1PK_plPrepaidPayrollBatchClusteredBATCH_NO




Index
Table:[dbo].[plPromotion]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2EE_NONVARCHAR(20)N
3START_DATESMALLDATETIMEY
4DIVISION_CODENVARCHAR(24)Y
5DEPT_CODENVARCHAR(24)Y
6POSITIONNVARCHAR(200)Y
7SALARYDECIMAL(23,9)Y
8BONUSDECIMAL(23,9)Y
9ALLOWANCEDECIMAL(23,9)Y
10ALLOWANCE2DECIMAL(23,9)Y
11UNIT_RATE1DECIMAL(23,9)Y
12UNIT_RATE2DECIMAL(23,9)Y
13UNIT_RATE3DECIMAL(23,9)Y
14UNIT_RATE4DECIMAL(23,9)Y
15UNIT_RATE5DECIMAL(23,9)Y
16UNIT_RATE6DECIMAL(23,9)Y
17MEMONVARCHAR(2048)Y
18WORK_LOCATIONNVARCHAR(20)Y
19SALARY_BYNCHAR(2)N
20ENTITLEMENT_CODENVARCHAR(24)N
21WORK_HRS_TYPENVARCHAR(20)Y
22ROSTER_CODENVARCHAR(20)Y
23CREATE_BYCHAR(10)Y
24CREATE_DATEDATETIMEY
25LAST_UPDATE_BYCHAR(10)Y
26LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plPromotion_ENTITLEMENT_CODEENTITLEMENT_CODE('')
2DF_plPromotion_SALARY_BYSALARY_BY('')
3DF_plPromotion_UNIT_RATE1UNIT_RATE1((0))
4DF_plPromotion_UNIT_RATE2UNIT_RATE2((0))
5DF_plPromotion_UNIT_RATE3UNIT_RATE3((0))
6DF_plPromotion_UNIT_RATE4UNIT_RATE4((0))
7DF_plPromotion_UNIT_RATE5UNIT_RATE5((0))
8DF_plPromotion_UNIT_RATE6UNIT_RATE6((0))

Triggers
Sr.NameDescription
1Tr_plPromotion
2Tr_plPromotion_Validating

Indexes
Sr.NameTypeColumns
1PK_plPromotionNonclusteredTS_KEY
2plPromotion_Index1ClusteredEE_NO
START_DATE
3plPromotion_Index2NonclusteredEE_NO




Index
Table:[dbo].[plReminder]

Description
Reminder Table

Table Columns
Sr.NameDatatypeNullableDescription
1REMINDER_NOINTN
2ACTIVEINTN
3DESCRIPTIONNVARCHAR(200)N
4MONTHSINTY

Indexes
Sr.NameTypeColumns
1PK_plReminderClusteredREMINDER_NO




Index
Table:[dbo].[plRoster]

Description
Roster Table Header

Table Columns
Sr.NameDatatypeNullableDescription
1ROSTER_CODENVARCHAR(20)N
2AUTHORIZEDBITN
3DESCRIPTIONNVARCHAR(120)Y
4LEAVE_PERIOD_START_DAYINTN
5LEAVE_PERIOD_OF_MONTHINTN
6LEAVE_PERIOD_OFFSETINTN
7EXPENSE_PERIOD_START_DAYINTN
8EXPENSE_PERIOD_OF_MONTHINTN
9EXPENSE_PERIOD_OFFSETINTN
10ATTENDANCE_PERIOD_START_DAYINTN
11ATTENDANCE_PERIOD_OF_MONTHINTN
12ATTENDANCE_PERIOD_OFFSETINTN
13CREATE_BYCHAR(10)Y
14CREATE_DATEDATETIMEY
15LAST_UPDATE_BYCHAR(10)Y
16LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plRoster_ATTENDANCE_PERIOD_OF_MONTHATTENDANCE_PERIOD_OF_MONTH((0))
2DF_plRoster_ATTENDANCE_PERIOD_OFFSETATTENDANCE_PERIOD_OFFSET((0))
3DF_plRoster_ATTENDANCE_PERIOD_START_DAYATTENDANCE_PERIOD_START_DAY((0))
4DF_plRoster_AUTHORIZEDAUTHORIZED((0))
5DF_plRoster_EXPENSE_PERIOD_OF_MONTHEXPENSE_PERIOD_OF_MONTH((0))
6DF_plRoster_EXPENSE_PERIOD_OFFSETEXPENSE_PERIOD_OFFSET((0))
7DF_plRoster_EXPENSE_PERIOD_START_DAYEXPENSE_PERIOD_START_DAY((0))
8DF_plRoster_LEAVE_PERIOD_OF_MONTHLEAVE_PERIOD_OF_MONTH((0))
9DF_plRoster_LEAVE_PERIOD_OFFSETLEAVE_PERIOD_OFFSET((0))
10DF_plRoster_LEAVE_PERIOD_START_DAYLEAVE_PERIOD_START_DAY((0))

Triggers
Sr.NameDescription
1Tr_plRoster
2Tr_plRoster_Deleting

Indexes
Sr.NameTypeColumns
1PK_plRosterClusteredROSTER_CODE




Index
Table:[dbo].[plRosterD]

Description
Roster Table Details

Table Columns
Sr.NameDatatypeNullableDescription
1ROSTER_CODENVARCHAR(20)N
2ROSTER_DATESMALLDATETIMEN
3SHIFT_CODENVARCHAR(20)N
4CREATE_BYCHAR(10)Y
5CREATE_DATEDATETIMEY
6LAST_UPDATE_BYCHAR(10)Y
7LAST_UPDATE_DATEDATETIMEY

Triggers
Sr.NameDescription
1plRosterD_Update_plATTD
2Tr_plROSTERD_Validating

Indexes
Sr.NameTypeColumns
1PK_plRosterDClusteredROSTER_CODE
ROSTER_DATE
2plRosterD_Index1NonclusteredSHIFT_CODE
3plRosterD_Index2NonclusteredROSTER_DATE
4plRosterD_Index3NonclusteredROSTER_CODE
ROSTER_DATE
SHIFT_CODE
5plRosterD_Index4NonclusteredLAST_UPDATE_DATE
6plRosterD_Index5NonclusteredLAST_UPDATE_BY




Index
Table:[dbo].[plSetup]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2ER_TAX_NONVARCHAR(24)Y
3TAX_SNAMENVARCHAR(60)Y
4TAX_DESIGNATIONNVARCHAR(50)Y
5TAX_IR56B_CHINESE_NAME_BLANKBITN
6AUTOPAY_FILE_FORMATINTY
7BANK_CODENVARCHAR(10)Y
8HSBC_ACCOUNT_CODENVARCHAR(24)Y
9HSBC_APC_NONVARCHAR(6)Y
10CITI_PCODENVARCHAR(6)Y
11CITI_ACNONVARCHAR(20)Y
12CITI_CLIDNVARCHAR(16)Y
13CITI_CLNAMNVARCHAR(70)Y
14DBS_BATNONVARCHAR(10)Y
15DBS_ACNONVARCHAR(30)Y
16DBS_ACNAMNVARCHAR(40)Y
17DBS_BATNAMNVARCHAR(50)Y
18SC_ACCOUNT_NONVARCHAR(28)Y
19BASIC_SALARY_ACCOUNT_NOCHAR(10)Y
20BANK_AUTOPAY_FILE_FORMATCHAR(1)Y
21AUTOPAY_ACCOUNT_NO1NVARCHAR(40)Y
22AUTOPAY_ACCOUNT_NO2NVARCHAR(40)Y
23AUTOPAY_ACCOUNT_NAMENVARCHAR(100)Y
24MPF_SP_CODENVARCHAR(20)Y
25MPF_EMPLOYER_IDNVARCHAR(40)Y
26MPF_PLAN_NONVARCHAR(40)Y
27MPF_BENEFIT_PLAN_NONVARCHAR(40)Y
28MPF_EMPLOYER_PARTICIPATIONNVARCHAR(100)Y
29MPF_SCHEME_REGISTRATION_NONVARCHAR(100)Y
30MPF_CONTACT_PERSONNVARCHAR(100)Y
31MPF_ER_60D_RETENTIONBITN
32MPF_MID_MONTH_CONTRIBUTIONBITN
33MPF_USE_CERT_NO_AS_EE_NOBITN
34BASIC_SAL_TAXBITN
35BASIC_SAL_CATVARCHAR(2)Y
36BASIC_SAL_CATMVARCHAR(2)Y
37OT_VISIBLEBITN
38OT_WAGEBITN
39OT_TAXBITN
40OT_MPFBITN
41OT_SMWBITN
42OT_CATVARCHAR(2)Y
43OT_CATMVARCHAR(2)Y
44OT_PAY_TYPE7_DESCNVARCHAR(100)Y
45OT7_VISIBLEBITN
46OT7_WAGEBITN
47OT7_TAXBITN
48OT7_MPFBITN
49OT7_SMWBITN
50OT7_CATVARCHAR(2)Y
51OT7_CATMVARCHAR(2)Y
52OT_PAY_TYPE8_DESCNVARCHAR(100)Y
53OT8_VISIBLEBITN
54OT8_WAGEBITN
55OT8_TAXBITN
56OT8_MPFBITN
57OT8_SMWBITN
58OT8_CATVARCHAR(2)Y
59OT8_CATMVARCHAR(2)Y
60DEDUCTION_VISIBLEBITN
61DEDUCTION_WAGEBITN
62DEDUCTION_TAXBITN
63DEDUCTION_MPFBITN
64DEDUCTION_SMWBITN
65DEDUCTION_CATVARCHAR(2)Y
66DEDUCTION_CATMVARCHAR(2)Y
67ALLOWANCE_VISIBLEBITN
68ALLOWANCE_WAGEBITN
69ALLOWANCE_TAXBITN
70ALLOWANCE_MPFBITN
71ALLOWANCE_SMWBITN
72ALLOWANCE_CATVARCHAR(2)Y
73ALLOWANCE_CATMVARCHAR(2)Y
74ALLOWANCE_DESCNVARCHAR(100)Y
75ALLOWANCE2_VISIBLEBITN
76ALLOWANCE2_WAGEBITN
77ALLOWANCE2_TAXBITN
78ALLOWANCE2_MPFBITN
79ALLOWANCE2_SMWBITN
80ALLOWANCE2_CATVARCHAR(2)Y
81ALLOWANCE2_CATMVARCHAR(2)Y
82ALLOWANCE2_DESCNVARCHAR(100)Y
83DOUBLEPAY_VISIBLEBITN
84DOUBLEPAY_WAGEBITN
85DOUBLEPAY_TAXBITN
86DOUBLEPAY_MPFBITN
87DOUBLEPAY_SMWBITN
88DOUBLEPAY_CATVARCHAR(2)Y
89DOUBLEPAY_CATMVARCHAR(2)Y
90BONUS_VISIBLEBITN
91BONUS_WAGEBITN
92BONUS_TAXBITN
93BONUS_MPFBITN
94BONUS_SMWBITN
95BONUS_CATVARCHAR(2)Y
96BONUS_CATMVARCHAR(2)Y
97HOLIDAYPAY_VISIBLEBITN
98HOLIDAYPAY_WAGEBITN
99HOLIDAYPAY_TAXBITN
100HOLIDAYPAY_MPFBITN
101HOLIDAYPAY_SMWBITN
102HOLIDAYPAY_CATVARCHAR(2)Y
103HOLIDAYPAY_CATMVARCHAR(2)Y
104ANNUALLEAVEPAY_VISIBLEBITN
105ANNUALLEAVEPAY_WAGEBITN
106ANNUALLEAVEPAY_TAXBITN
107ANNUALLEAVEPAY_MPFBITN
108ANNUALLEAVEPAY_SMWBITN
109ANNUALLEAVEPAY_CATVARCHAR(2)Y
110ANNUALLEAVEPAY_CATMVARCHAR(2)Y
111SICKNESSALLOWANCE_VISIBLEBITN
112SICKNESSALLOWANCE_WAGEBITN
113SICKNESSALLOWANCE_TAXBITN
114SICKNESSALLOWANCE_MPFBITN
115SICKNESSALLOWANCE_SMWBITN
116SICKNESSALLOWANCE_CATVARCHAR(2)Y
117SICKNESSALLOWANCE_CATMVARCHAR(2)Y
118SICKNESSALLOWANCE2_VISIBLEBITN
119SICKNESSALLOWANCE2_WAGEBITN
120SICKNESSALLOWANCE2_TAXBITN
121SICKNESSALLOWANCE2_MPFBITN
122SICKNESSALLOWANCE2_SMWBITN
123SICKNESSALLOWANCE2_CATVARCHAR(2)Y
124SICKNESSALLOWANCE2_CATMVARCHAR(2)Y
125MATERNITYLEAVEPAY_VISIBLEBITN
126MATERNITYLEAVEPAY_WAGEBITN
127MATERNITYLEAVEPAY_TAXBITN
128MATERNITYLEAVEPAY_MPFBITN
129MATERNITYLEAVEPAY_SMWBITN
130MATERNITYLEAVEPAY_CATVARCHAR(2)Y
131MATERNITYLEAVEPAY_CATMVARCHAR(2)Y
132WAGES_IN_LIEU_VISIBLEBITN
133WAGES_IN_LIEU_TAXBITN
134WAGES_IN_LIEU_CATVARCHAR(2)Y
135WAGES_IN_LIEU_CATMVARCHAR(2)Y
136WAGES_IN_LIEU_BY_MONTH_VISIBLEBITN
137WAGES_IN_LIEU_BY_MONTH_TAXBITN
138WAGES_IN_LIEU_BY_MONTH_CATVARCHAR(2)Y
139WAGES_IN_LIEU_BY_MONTH_CATMVARCHAR(2)Y
140LSP_SP_VISIBLEBITN
141LSP_SP_TAXBITN
142LSP_SP_CATVARCHAR(2)Y
143LSP_SP_CATMVARCHAR(2)Y
144PAY_TYPE1_VISIBLEBITN
145PAY_TYPE1_DESCNVARCHAR(100)Y
146PAY_TYPE1_WAGEBITN
147PAY_TYPE1_TAXBITN
148PAY_TYPE1_MPFBITN
149PAY_TYPE1_SMWBITN
150PAY_TYPE1_CATVARCHAR(2)Y
151PAY_TYPE1_CATMVARCHAR(2)Y
152PAY_TYPE2_VISIBLEBITN
153PAY_TYPE2_DESCNVARCHAR(100)Y
154PAY_TYPE2_WAGEBITN
155PAY_TYPE2_TAXBITN
156PAY_TYPE2_MPFBITN
157PAY_TYPE2_SMWBITN
158PAY_TYPE2_CATVARCHAR(2)Y
159PAY_TYPE2_CATMVARCHAR(2)Y
160PAY_TYPE3_VISIBLEBITN
161PAY_TYPE3_DESCNVARCHAR(100)Y
162PAY_TYPE3_WAGEBITN
163PAY_TYPE3_TAXBITN
164PAY_TYPE3_MPFBITN
165PAY_TYPE3_SMWBITN
166PAY_TYPE3_CATVARCHAR(2)Y
167PAY_TYPE3_CATMVARCHAR(2)Y
168PAY_TYPE4_VISIBLEBITN
169PAY_TYPE4_DESCNVARCHAR(100)Y
170PAY_TYPE4_WAGEBITN
171PAY_TYPE4_TAXBITN
172PAY_TYPE4_MPFBITN
173PAY_TYPE4_SMWBITN
174PAY_TYPE4_CATVARCHAR(2)Y
175PAY_TYPE4_CATMVARCHAR(2)Y
176PAY_TYPE5_VISIBLEBITN
177PAY_TYPE5_DESCNVARCHAR(100)Y
178PAY_TYPE5_WAGEBITN
179PAY_TYPE5_TAXBITN
180PAY_TYPE5_MPFBITN
181PAY_TYPE5_SMWBITN
182PAY_TYPE5_CATVARCHAR(2)Y
183PAY_TYPE5_CATMVARCHAR(2)Y
184PAY_TYPE6_VISIBLEBITN
185PAY_TYPE6_DESCNVARCHAR(100)Y
186PAY_TYPE6_WAGEBITN
187PAY_TYPE6_TAXBITN
188PAY_TYPE6_MPFBITN
189PAY_TYPE6_SMWBITN
190PAY_TYPE6_CATVARCHAR(2)Y
191PAY_TYPE6_CATMVARCHAR(2)Y
192PAY_TYPE7_VISIBLEBITN
193PAY_TYPE7_DESCNVARCHAR(100)Y
194PAY_TYPE7_WAGEBITN
195PAY_TYPE7_TAXBITN
196PAY_TYPE7_MPFBITN
197PAY_TYPE7_SMWBITN
198PAY_TYPE7_CATVARCHAR(2)Y
199PAY_TYPE7_CATMVARCHAR(2)Y
200PAY_TYPE8_VISIBLEBITN
201PAY_TYPE8_DESCNVARCHAR(100)Y
202PAY_TYPE8_WAGEBITN
203PAY_TYPE8_TAXBITN
204PAY_TYPE8_MPFBITN
205PAY_TYPE8_SMWBITN
206PAY_TYPE8_CATVARCHAR(2)Y
207PAY_TYPE8_CATMVARCHAR(2)Y
208PAY_TYPE9_VISIBLEBITN
209PAY_TYPE9_DESCNVARCHAR(100)Y
210PAY_TYPE9_WAGEBITN
211PAY_TYPE9_TAXBITN
212PAY_TYPE9_MPFBITN
213PAY_TYPE9_SMWBITN
214PAY_TYPE9_CATVARCHAR(2)Y
215PAY_TYPE9_CATMVARCHAR(2)Y
216PAY_TYPE10_VISIBLEBITN
217PAY_TYPE10_DESCNVARCHAR(100)Y
218PAY_TYPE10_WAGEBITN
219PAY_TYPE10_TAXBITN
220PAY_TYPE10_MPFBITN
221PAY_TYPE10_SMWBITN
222PAY_TYPE10_CATVARCHAR(2)Y
223PAY_TYPE10_CATMVARCHAR(2)Y
224PAY_TYPE11_VISIBLEBITN
225PAY_TYPE11_DESCNVARCHAR(100)Y
226PAY_TYPE11_WAGEBITN
227PAY_TYPE11_TAXBITN
228PAY_TYPE11_MPFBITN
229PAY_TYPE11_SMWBITN
230PAY_TYPE11_CATVARCHAR(2)Y
231PAY_TYPE11_CATMVARCHAR(2)Y
232PAY_TYPE12_VISIBLEBITN
233PAY_TYPE12_DESCNVARCHAR(100)Y
234PAY_TYPE12_WAGEBITN
235PAY_TYPE12_TAXBITN
236PAY_TYPE12_MPFBITN
237PAY_TYPE12_SMWBITN
238PAY_TYPE12_CATVARCHAR(2)Y
239PAY_TYPE12_CATMVARCHAR(2)Y
240PAY_TYPE13_VISIBLEBITN
241PAY_TYPE13_DESCNVARCHAR(100)Y
242PAY_TYPE13_WAGEBITN
243PAY_TYPE13_TAXBITN
244PAY_TYPE13_MPFBITN
245PAY_TYPE13_SMWBITN
246PAY_TYPE13_CATVARCHAR(2)Y
247PAY_TYPE13_CATMVARCHAR(2)Y
248PAY_TYPE14_VISIBLEBITN
249PAY_TYPE14_DESCNVARCHAR(100)Y
250PAY_TYPE14_WAGEBITN
251PAY_TYPE14_TAXBITN
252PAY_TYPE14_MPFBITN
253PAY_TYPE14_SMWBITN
254PAY_TYPE14_CATVARCHAR(2)Y
255PAY_TYPE14_CATMVARCHAR(2)Y
256PAY_TYPE15_VISIBLEBITN
257PAY_TYPE15_DESCNVARCHAR(100)Y
258PAY_TYPE15_WAGEBITN
259PAY_TYPE15_TAXBITN
260PAY_TYPE15_MPFBITN
261PAY_TYPE15_SMWBITN
262PAY_TYPE15_CATVARCHAR(2)Y
263PAY_TYPE15_CATMVARCHAR(2)Y
264USER01_VISIBLEBITN
265USER01_NAMENVARCHAR(100)Y
266USER02_VISIBLEBITN
267USER02_NAMENVARCHAR(100)Y
268USER03_VISIBLEBITN
269USER03_NAMENVARCHAR(100)Y
270USER04_VISIBLEBITN
271USER04_NAMENVARCHAR(100)Y
272USER05_VISIBLEBITN
273USER05_NAMENVARCHAR(100)Y
274USER06_VISIBLEBITN
275USER06_NAMENVARCHAR(100)Y
276USER07_VISIBLEBITN
277USER07_NAMENVARCHAR(100)Y
278USER08_VISIBLEBITN
279USER08_NAMENVARCHAR(100)Y
280USER09_VISIBLEBITN
281USER09_NAMENVARCHAR(100)Y
282USER10_VISIBLEBITN
283USER10_NAMENVARCHAR(100)Y
284USER11_VISIBLEBITN
285USER11_NAMENVARCHAR(100)Y
286USER12_VISIBLEBITN
287USER12_NAMENVARCHAR(100)Y
288USER13_VISIBLEBITN
289USER13_NAMENVARCHAR(100)Y
290USER14_VISIBLEBITN
291USER14_NAMENVARCHAR(100)Y
292USER15_VISIBLEBITN
293USER15_NAMENVARCHAR(100)Y
294USER16_VISIBLEBITN
295USER16_NAMENVARCHAR(100)Y
296USER17_VISIBLEBITN
297USER17_NAMENVARCHAR(100)Y
298USER18_VISIBLEBITN
299USER18_NAMENVARCHAR(100)Y
300USER19_VISIBLEBITN
301USER19_NAMENVARCHAR(100)Y
302USER20_VISIBLEBITN
303USER20_NAMENVARCHAR(100)Y
304USER21_VISIBLEBITN
305USER21_NAMENVARCHAR(100)Y
306USER22_VISIBLEBITN
307USER22_NAMENVARCHAR(100)Y
308USER23_VISIBLEBITN
309USER23_NAMENVARCHAR(100)Y
310USER24_VISIBLEBITN
311USER24_NAMENVARCHAR(100)Y
312USER25_VISIBLEBITN
313USER25_NAMENVARCHAR(100)Y
314GL_POSTING_BYNCHAR(2)Y
315PRORATED_BYNCHAR(2)Y
316PRORATED_INCLUDE_ALLOWANCE1BITN
317PRORATED_INCLUDE_ALLOWANCE2BITN
318SATURDAYNCHAR(2)Y
319ACCESS_BY_GROUPBITN
320WITH_PMBITN
321WITH_TMBITN
322WITH_LMBITN
323WITH_XMBITN
324WITH_AMBITN
325WITH_WLBITN
326WITH_BABITN
327WITH_MEBITN
328WITH_RDBITN
329WITH_PABITN
330IsWebLeaveSubscriptionServiceBITN
331LEAVE_DECIMALINTY
332DAILY_RATE_DECIMALINTY
333NET_SALARY_DECIMALINTY
334MPF_DECIMALINTY
335ORSO_DECIMALINTY
336ATTENDANCE_HOUR_DECIMALINTY
337ERPRO_DATABASENVARCHAR(100)Y
338ENABLE2007EAOBITN
339USE_CURRENT_MONTH_WAGEBITN
340USE_CURRENT_MONTH_WAGE_HOLIDAYPAYBITN
341USE_CURRENT_MONTH_WAGE_ANNUALLEAVEPAYBITN
342USE_CURRENT_MONTH_WAGE_SICKNESSALLOWANCEBITN
343USE_CURRENT_MONTH_WAGE_SICKNESSALLOWANCE2BITN
344USE_CURRENT_MONTH_WAGE_MATERNITYLEAVEPAYBITN
345CHECK_CALLNAME_DUPLICATIONBITN
346CHECK_HKID_DUPLICATIONBITN
347CHECK_BADGE_DUPLICATIONBITN
348ATTENDANCE_IMPORT_FORMATINTY
349ATTENDANCE_IMPORT_FORMAT2INTN
350ATTENDANCE_IMPORT_DEVELOPER_IDNVARCHAR(200)N
351ATTENDANCE_IMPORT_DEVELOPER_KEYNVARCHAR(200)N
352ATTENDANCE_IMPORT_DAYSBEFOREINTN
353DELETE_EXISTING_PERIOD_ATTENDANCE_RECORD_BEFORE_IMPORTBITN
354ENABLE_OT_CALCBITN
355ENABLE_PREPAID_BATCHBITN
356ZERO_AMOUNT_FOR_MIDMONTH_PAYROLLINTY
357FINALPAY_ADD_ALPAYBITN
358HOLIDAYPAY_3_MONTHSINTY
359NOPAYLEAVEPAY_BYCHAR(1)Y
360PRORATED_SALARY_USE_START_DATEBITN
361USE_LEAVE_PERIOD_IN_EE_CLASSBITN
362OT_OVER_20BITN
363FINAL_PAYMENT_BASED_ON_CURRENT_MONTH_AVERAGE_WAGESINTY
364FINAL_PAYMENT_AL_FORMULANVARCHAR(510)N
365WAGES_IN_LIEU_DAILYRATE_FORMULANVARCHAR(510)N
366WAGES_IN_LIEU_MONTHLYRATE_FORMULANVARCHAR(510)N
367AUTO_ANNUAL_LEAVE_FORFEITUREBITN
368RETAIN_DAYSINTY
369AL_FORFEITURE_GRACE_PERIODINTN
370AUTO_ADD_ANNUAL_LEAVE_FORFEITUREBITN
371AAL_RETAIN_DAYSINTY
372AAL_FORFEITURE_GRACE_PERIODINTN
373IGNORED_IMPORT_PERIOD_CHECKINGBITN
374ENABLE_LUNCH_OUTINBITN
375ENABLE_REST_OUTINBITN
376ENABLE_CALLBACK_INOUTBITN
377ENABLE_ATTD_MINIMUM_WAGE_CALCBITN
378CHECK_AL_BASED_ONCHAR(1)Y
379FULL_PAY_SICK_LEAVE_ENTITLEMENTINTY
380FULL_PAY_SICK_LEAVE_ENTITLEMENT_O1_V1INTY
381FULL_PAY_SICK_LEAVE_ENTITLEMENT_O2_V1INTY
382FULL_PAY_SICK_LEAVE_ENTITLEMENT_O3_V1INTY
383FULL_PAY_SICK_LEAVE_ENTITLEMENT_O5_V1INTY
384FULL_PAY_SICK_LEAVE_DAYS_COUNT_WORKING_DAYS_ONLYBITN
385FULL_PAY_SICK_LEAVE_ENTITLEMENT_START_MONTHINTN
386CASUAL_LEAVE_ENTITLEMENTINTY
387ACTUAL_AL_NEGLECT_3_MTHSBITN
388ACTUAL_AL_NEGLECT_3_MTHS_FOR_1ST_YRBITN
389NOPAY_DAYS_FROM_LEAVE_MODULEBITN
390EE_NAME_INCLUDE_SUROTHERNAMEBITN
391EE_NAME_INCLUDE_CALLNAMEBITN
392EE_NAME_INCLUDE_CHINESENAMEBITN
393FIRST_YR_ROUND_UP_TO_INTBITN
394DEFAULT_PROBATION_PERIODINTY
395DISABLE_CROSS_LEAVE_PERIOD_CHECKINGBITN
396ENABLE_ADDITIONAL_AL_ENTITLEMENTBITN
397NAME_FOR_STANDARD_ALNVARCHAR(40)Y
398NAME_FOR_ADDITIONAL_ALNVARCHAR(40)Y
399ANNUAL_LEAVE_PAY_INCLUDED_ADDITIONAL_AL_BALANCEBITN
400ENABLE_LEAVE_DAYS_OVERWRITEBITN
401ENABLE_LEAVE_TIME_IN_LEAVE_ENTRYBITN
402ENABLE_LEAVE_AMPM_IN_LEAVE_ENTRYBITN
403LEAVE_DAYS_USE_REGULAR_FRACTIONBITN
404USE_REGULAR_HOURS_FOR_IN_OUT_TIMEBITN
405USE_REGULAR_DAYS_FOR_DAILY_EEBITN
406USE_REGULAR_HOURS_FOR_HOURLY_EEBITN
407ENABLE_MULTIPLE_COST_CENTREBITN
408CONSIDER_CHECK_OUT_CUT_OFF_HOURBITN
409CONSIDER_CHECK_IN_CUT_OFF_HOURBITN
410ALLOW_AMEND_SHIFT_CODEBITN
411PAYSLIP_PRINTS_COMPANY_NAMEBITN
412PAYSLIP_PRINTS_CHINESE_NAMEBITN
413PAYSLIP_PRINTS_CALL_NAMEBITN
414PAYSLIP_PRINTS_DEPARTMENTBITN
415PAYSLIP_PRINTS_DEPT_CODE_ON_DEPARTMENTBITN
416PAYSLIP_PRINTS_POSITIONBITN
417PAYSLIP_PRINTS_DAILY_RATESBITN
418PAYSLIP_PRINTS_DAILY_RATES_FOR_NOPAY_LEAVEBITN
419PAYSLIP_PRINTS_ANNUAL_LEAVE_BALANCEBITN
420PAYSLIP_PRINTS_RECEIVED_BY_SECTIONINTY
421PAYSLIP_PRINTS_FULLPAY_SICK_LEAVE_BALANCEBITN
422PAYSLIP_PRINTS_BASIC_SALARY_REFBITN
423PAYSLIP_PRINTS_COM_LEAVE_BALANCEBITN
424PAYSLIP_PRINTS_COM_LEAVE_CURRENT_BALANCEBITN
425PAYSLIP_PRINTS_JOIN_DATEBITN
426PAYSLIP_PRINTS_BIRTHDATEBITN
427PAYSLIP_PRINTS_YTD_MPFBITN
428PAYSLIP_PRINTS_BANK_ACBITN
429PAYSLIP_PRINTS_PRINT_DATEBITN
430PAYSLIP_PRINTS_BADGE_NUMBERBITN
431PAYSLIP_TOP_MARGINDECIMAL(18,4)N
432PAYSLIP_LEFT_MARGINDECIMAL(18,4)N
433ENABLE_MULTIPLE_MIDMONTH_PAYROLLBITN
434KEEP_ATTENDANCE_RAW_DATABITN
435ATTENDANCE_RAW_DATA_RETENTIONINTY
436SHOW_FORFEIT_ACTUAL_BALANCE_BUTTONBITN
437SHOW_FORFEIT_BALANCE_BF_BUTTONBITN
438SHOW_FORFEIT_BALANCE_BF_MINUS_TY_LEAVE_BUTTONBITN
439USE_EXACT_TIME_WHEN_CAL_LEAVEDAYS_FROM_TIMEBITN
440USE_EXACT_TIME_WHEN_CAL_LEAVEDAYS_FROM_AMPMBITN
441RESERVE_MPF_TO_PAYTYPEBITN
442AL_DAYS_ROUND_UP_FOR_FINALPAYBITN
443NO_ACUTAL_AL_ENTITLEMENT_BEFORE_PROBATIONBITN
444NO_ELIGIBLE_AL_ENTITLEMENT_FOR_FIRST_3_MONTHSBITN
445OPTIONAL_MPFCHAR(25)Y
446PREVENT_OVERWRITE_UPDATED_PAYROLL_RECORDBITN
447ALLOW_GENERATE_PAYROLL_FOR_SELECTED_TERMINATED_EMPLOYEEBITN
448DISABLE_OR_IN_REPORT_CONTROLBITN
449MINIMUM_WAGE_HOURLY_RATEDECIMAL(18,2)Y
450SICK_LEAVE_BALANCE_PARTIAL_PAY_CONSIDERS_SICK_LEAVE_FULL_PAY_TAKENBITN
451NO_TERMINATEDEE_AUTOPAY_CHECKINGBITN
452NO_TERMINATEDEE_PAYSLIP_EMAIL_CHECKINGBITN
453NO_BIRTHDATE_CHECKINGBITN
454ATTACHMENT_WITH_PASSWORDBITN
455REST_DAY_ENTITLEMENT_BASED_ON_7_DAYS_PER_1BITN
456REST_DAY_TAKEN_INCLUDES_ROSTER_TABLEBITN
457REST_DAY_TAKEN_INCLUDES_FULL_PAY_REST_DAYBITN
458REST_DAY_TAKEN_INCLUDES_NOT_FULL_PAY_REST_DAYBITN
459SHOW_TERMINATION_REASON_TABLE_IN_MPF_GENERAL_REPORTBITN
460SHOW_AUTHORIZED_SIGNATURE_SECTION_IN_MPF_GENERAL_REPORTBITN
461COM_LEAVE_BASED_ON_HOURSBITN
462LEAVE_PAY_CUTOFF_DATEINTY
463DOUBLE_PAY_BASE_ON_CURRENT_SALARYINTY
464ACCUMLATE_IR56B_BY_HKIDBITN
465ENABLE_AUTO_SALARY_SMALL_AMOUNT_ADJUSTMENTBITN
466ROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_HOLIDAY_TABLEBITN
467ROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_ROSTER_TABLEBITN
468ROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_SH_LEAVEBITN
469PAYSLIP_FOOTERNVARCHAR(2048)Y
470MAXIMUM_PERIODS_TO_DISPLAY_AS_AUTHORZIED_LEAVE_ENTRIESINTY
471MAXIMUM_PERIODS_TO_DISPLAY_AS_AUTHORZIED_ATTENDANCE_RECORDSINTY
472SHOW_CARD_TIMESBITN
473SHOW_STATUS_ROW_IN_ATTENDANCE_RECORDBITN
474PAY_TYPE_DESCRIPTION_ON_PAYROLL_REPORTS_BASED_ON_PAYROLL_RECORDBITN
475COM_LEAVE_ENTITLEMENT_RETENTION_DAYSINTY
476ALWAYS_365BITN
477NO_MINIMUM_LEVEL_FOR_MIDMONTH_MPFBITN
478CONSIDER_CONTRACT_END_DATE_FOR_AL_ENTITLEMENTBITN
479ACTUAL_AL_BALANCE_WITH_FUTURE_CONSIDER_FUTURE_ENTITLEMENTBITN
480MPF_COMMENCE_DATE_CONSIDERS_GROUP_JOIN_DATEBITN
481TREAT_DATE_JOIN_SCHEME_AS_EE_COMMENCE_DATEBITN
482ALLOW_GENERATE_AUTOPAY_MPF_FILE_AFTER_PAYROLL_BATCH_POSTEDBITN
483INCLUDED_AREA_TO_IR_FORM_ADDRESSBITN
484WEBLEAVE_APPLICATION_ACTION_IS_FINALBITN
485TREAT_GROUP_JOIN_DATE_AS_AL_ENTITLEMENT_START_DATEBITN
486ALLOW_TAKE_LEAVE_EVENIF_NO_ROSTERBITN
487PAYROLL_PERIOD_START_DAYINTN
488PAYROLL_PERIOD_OF_MONTHINTN
489LEAVE_PERIOD_START_DAYINTN
490LEAVE_PERIOD_OF_MONTHINTN
491LEAVE_PERIOD_OFFSETINTN
492ATTENDANCE_PERIOD_START_DAYINTN
493ATTENDANCE_PERIOD_OF_MONTHINTN
494ATTENDANCE_PERIOD_OFFSETINTN
495ATTENDANCE_UPDATE_ONLY_FOR_UNPOSTED_PERIODSBITN
496ENABLE_40_WEEKS_CHECKING_FOR_PATERNITY_LEAVEBITN
497ENABLE_IR56MBITN
498IGNORED_IR56M_INCOME_LIMITBITN
499COMPENSATION_LEAVE_STATUS_STARTED_FROM_CURRENT_YEARBITN
500COMPANY_CALENDAR_SHOW_BIRTHDAYBITN
501BA_USER_IDNVARCHAR(100)N
502BA_USER_PASSWORDNVARCHAR(100)N
503HIDE_COLUMNS_WITH_ZERO_TOTALBITN
504GENERATE_MPF_TO_IR56B_REMARKSBITN
505ENABLE_PAY_TYPE_TABLEBITN
506ENABLE_PAY_TYPE_VALIDATIONBITN
507MPF_EXCEL_FILE_GENERAL_ORDER_BY_EMPLOYEE_NAMEBITN
508STATUTORY_SICK_LEAVE_DAYS_COUNT_WORKING_DAYS_ONLYBITN
509PREVENT_OVERWRITE_UPDATED_IR56BM_RECORDBITN
510EXCLUDE_MPF_CONTRIBUTION_VOUCHER_IN_GL_VOUCHERBITN
511STATUTORY_SICK_LEAVE_INCLUDE_SHBITN
512GROUP_SALARY_HOLIDAY_ANNAUL_LEAVE_SICK2_PAY_TO_SALARYBITN
513TREAT_ABSENT_AS_NO_PAY_LEAVEBITN
514ANNUAL_LEAVE_CONSIDERS_APPOINTMENT_HISTORYBITN
515DISALLOW_AMEND_WEBLEAVE_LEAVE_RECORDSBITN
516FULL_PAY_SICK_LEAVE_BALANCE_CANNOT_EXCEED_STATUTORY_SICK_LEAVE_BALANCEBITN
517MAXIMUM_ACCUMULATED_COM_LEAVE_BALANCEDECIMAL(18,4)N
518WORK_HRS_ROSTER_CONSIDERS_APPOINTMENT_HISTORYBITN
519TENTATIVE_DAYS_PER_MONTHDECIMAL(18,2)N
520TENTATIVE_HOURS_PER_DAYDECIMAL(18,2)N
521SHOW_HOLIDAY_ON_ROSTER_TABLEBITN
522AL_PRORATED_ENTITLEMENT_ALWAYS_ROUND_UPBITN
523FULL_PAY_SICK_LEAVE_ENTITLEMENT_ENTITLED_AFTER_PROBATION_END_DATEBITN
524ENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFOBITN
525ERVC_BASED_ONINTN
526ENABLE_REFERRAL_BONUSBITN
527NEW_STAFF_REFERRAL_BONUS_FORMULANVARCHAR(1000)N
528INTRODUCER_REFERRAL_BONUS_FORMULANVARCHAR(1000)N
529REFERRAL_BONUS_PAY_TYPEINTN
530REFERRAL_BONUS_PAY_TYPE_DESCNVARCHAR(100)N
531REFERRAL_BONUS_RELEASE_AFTER_MONTHSINTN
532ENTITLED_VC_AFTER_PROBATION_MONTHBITN
533ENTITLED_VC_AFTER_YEARS_OF_SERVICEINTN
534VC_INCOME_CONSIDERED_MPF_MAXIMUM_INCOMEBITN
535CREATE_BYCHAR(10)Y
536CREATE_DATEDATETIMEY
537LAST_UPDATE_BYCHAR(10)Y
538LAST_UPDATE_DATEDATETIMEY
539ERVC_USE_BASIC_SALARY_ONLYBITN

Default Constraints
Sr.NameColumnValue
1DF_plSETUP_AAL_FORFEITURE_GRACE_PERIODAAL_FORFEITURE_GRACE_PERIOD((0))
2DF_plSETUP_AAL_RETAIN_DAYSAAL_RETAIN_DAYS((0))
3DF_plSETUP_ACCESS_BY_GROUPACCESS_BY_GROUP((0))
4DF_plSETUP_ACCUMLATE_IR56B_BY_HKIDACCUMLATE_IR56B_BY_HKID((0))
5DF_plSETUP_ACTUAL_AL_BALANCE_WITH_FUTURE_CONSIDER_FUTURE_ENTITLEMENTACTUAL_AL_BALANCE_WITH_FUTURE_CONSIDER_FUTURE_ENTITLEMENT((0))
6DF_plSETUP_ACTUAL_AL_NEGLECT_3_MTHSACTUAL_AL_NEGLECT_3_MTHS((0))
7DF_plSetup_ACTUAL_AL_NEGLECT_3_MTHS_FOR_1ST_YRCACTUAL_AL_NEGLECT_3_MTHS_FOR_1ST_YR((0))
8DF_plSETUP_AL_DAYS_ROUND_UP_FOR_FINALPAYAL_DAYS_ROUND_UP_FOR_FINALPAY((0))
9DF_plSETUP_AL_FORFEITURE_GRACE_PERIODAL_FORFEITURE_GRACE_PERIOD((0))
10DF_plSETUP_AL_PRORATED_ENTITLEMENT_ALWAYS_ROUND_UPAL_PRORATED_ENTITLEMENT_ALWAYS_ROUND_UP((1))
11DF_plSETUP_ALLOW_AMEND_SHIFT_CODEALLOW_AMEND_SHIFT_CODE((0))
12DF_plSETUP_ALLOW_GENERATE_AUTOPAY_MPF_FILE_AFTER_PAYROLL_BATCH_POSTEDALLOW_GENERATE_AUTOPAY_MPF_FILE_AFTER_PAYROLL_BATCH_POSTED((0))
13DF_plSETUP_ALLOW_GENERATE_PAYROLL_FOR_SELECTED_TERMINATED_EMPLOYEEALLOW_GENERATE_PAYROLL_FOR_SELECTED_TERMINATED_EMPLOYEE((0))
14DF_plSETUP_ALLOW_TAKE_LEAVE_EVENIF_NO_ROSTERALLOW_TAKE_LEAVE_EVENIF_NO_ROSTER((0))
15DF_plSETUP_ALLOWANCE_MPFALLOWANCE_MPF((0))
16DF_plSETUP_ALLOWANCE_SMWALLOWANCE_SMW((0))
17DF_plSETUP_ALLOWANCE_TAXALLOWANCE_TAX((0))
18DF_plSETUP_ALLOWANCE_VISIBLEALLOWANCE_VISIBLE((0))
19DF_plSETUP_ALLOWANCE_WAGEALLOWANCE_WAGE((0))
20DF_plSETUP_ALLOWANCE2_MPFALLOWANCE2_MPF((0))
21DF_plSETUP_ALLOWANCE2_SMWALLOWANCE2_SMW((0))
22DF_plSETUP_ALLOWANCE2_TAXALLOWANCE2_TAX((0))
23DF_plSETUP_ALLOWANCE2_VISIBLEALLOWANCE2_VISIBLE((0))
24DF_plSETUP_ALLOWANCE2_WAGEALLOWANCE2_WAGE((0))
25DF_plSETUP_ALWAYS_365ALWAYS_365((0))
26DF_plSETUP_ANNUAL_LEAVE_CONSIDERS_APPOINTMENT_HISTORYANNUAL_LEAVE_CONSIDERS_APPOINTMENT_HISTORY((0))
27DF_plSETUP_ANNUAL_LEAVE_PAY_INCLUDED_ADDITIONAL_AL_BALANCEANNUAL_LEAVE_PAY_INCLUDED_ADDITIONAL_AL_BALANCE((0))
28DF_plSETUP_ANNUALLEAVEPAY_MPFANNUALLEAVEPAY_MPF((0))
29DF_plSETUP_ANNUALLEAVEPAY_SMWANNUALLEAVEPAY_SMW((0))
30DF_plSETUP_ANNUALLEAVEPAY_TAXANNUALLEAVEPAY_TAX((0))
31DF_plSETUP_ANNUALLEAVEPAY_VISIBLEANNUALLEAVEPAY_VISIBLE((0))
32DF_plSETUP_ANNUALLEAVEPAY_WAGEANNUALLEAVEPAY_WAGE((0))
33DF_plSETUP_ATTACHMENT_WITH_PASSWORDATTACHMENT_WITH_PASSWORD((1))
34DF_plSETUP_ATTENDANCE_HOUR_DECIMALATTENDANCE_HOUR_DECIMAL((2))
35DF_plSETUP_ATTENDANCE_IMPORT_DAYSBEFOREATTENDANCE_IMPORT_DAYSBEFORE((7))
36DF_plSETUP_ATTENDANCE_IMPORT_DEVELOPER_IDATTENDANCE_IMPORT_DEVELOPER_ID('')
37DF_plSETUP_ATTENDANCE_IMPORT_DEVELOPER_KEYATTENDANCE_IMPORT_DEVELOPER_KEY('')
38DF_plSETUP_ATTENDANCE_IMPORT_FORMAT2ATTENDANCE_IMPORT_FORMAT2((0))
39DF_plSETUP_ATTENDANCE_PERIOD_OF_MONTHATTENDANCE_PERIOD_OF_MONTH((1))
40DF_plSETUP_ATTENDANCE_PERIOD_OFFSETATTENDANCE_PERIOD_OFFSET((0))
41DF_plSETUP_ATTENDANCE_PERIOD_START_DAYATTENDANCE_PERIOD_START_DAY((1))
42DF_plSETUP_ATTENDANCE_UPDATE_ONLY_FOR_UNPOSTED_PERIODSATTENDANCE_UPDATE_ONLY_FOR_UNPOSTED_PERIODS((0))
43DF_plSETUP_AUTO_ADD_ANNUAL_LEAVE_FORFEITUREAUTO_ADD_ANNUAL_LEAVE_FORFEITURE((0))
44DF_plSETUP_AUTO_ANNUAL_LEAVE_FORFEITUREAUTO_ANNUAL_LEAVE_FORFEITURE((0))
45DF_plSETUP_BA_USER_IDBA_USER_ID('')
46DF_plSETUP_BA_USER_PASSWORDBA_USER_PASSWORD('')
47DF_plSETUP_BASIC_SAL_TAXBASIC_SAL_TAX((1))
48DF_plSETUP_BASIC_SALARY_CATBASIC_SAL_CAT('A')
49DF_plSETUP_BONUS_MPFBONUS_MPF((0))
50DF_plSETUP_BONUS_SMWBONUS_SMW((0))
51DF_plSETUP_BONUS_TAXBONUS_TAX((0))
52DF_plSETUP_BONUS_VISIBLEBONUS_VISIBLE((0))
53DF_plSETUP_BONUS_WAGEBONUS_WAGE((0))
54DF_plSETUP_CHECK_BADGE_DUPLICATIONCHECK_BADGE_DUPLICATION((1))
55DF_plSETUP_CHECK_CALLNAME_DUPLICATIONCHECK_CALLNAME_DUPLICATION((0))
56DF_plSETUP_CHECK_HKID_DUPLICATIONCHECK_HKID_DUPLICATION((0))
57DF_plSETUP_COM_LEAVE_BASED_ON_HOURSCOM_LEAVE_BASED_ON_HOURS((0))
58DF_plSETUP_COM_LEAVE_ENTITLEMENT_RETENTION_DAYSCOM_LEAVE_ENTITLEMENT_RETENTION_DAYS((0))
59DF_plSETUP_COMPANY_CALENDAR_SHOW_BIRTHDAYCOMPANY_CALENDAR_SHOW_BIRTHDAY((1))
60DF_plSETUP_COMPENSATION_LEAVE_STATUS_STARTED_FROM_CURRENT_YEARCOMPENSATION_LEAVE_STATUS_STARTED_FROM_CURRENT_YEAR((0))
61DF_plSETUP_CONSIDER_CHECK_IN_CUT_OFF_HOURCONSIDER_CHECK_IN_CUT_OFF_HOUR((0))
62DF_plSETUP_CONSIDER_CHECK_OUT_CUT_OFF_HOURCONSIDER_CHECK_OUT_CUT_OFF_HOUR((0))
63DF_plSETUP_CONSIDER_CONTRACT_END_DATE_FOR_AL_ENTITLEMENTCONSIDER_CONTRACT_END_DATE_FOR_AL_ENTITLEMENT((0))
64DF_plSETUP_DEDUCTION_MPFDEDUCTION_MPF((0))
65DF_plSETUP_DEDUCTION_SMWDEDUCTION_SMW((0))
66DF_plSETUP_DEDUCTION_TAXDEDUCTION_TAX((0))
67DF_plSETUP_DEDUCTION_VISIBLEDEDUCTION_VISIBLE((0))
68DF_plSETUP_DEDUCTION_WAGEDEDUCTION_WAGE((0))
69DF_plSETUP_DELETE_EXISTING_PERIOD_ATTENDANCE_RECORD_BEFORE_IMPORTDELETE_EXISTING_PERIOD_ATTENDANCE_RECORD_BEFORE_IMPORT((0))
70DF_plSETUP_DISABLE_CROSS_LEAVE_PERIOD_CHECKINGDISABLE_CROSS_LEAVE_PERIOD_CHECKING((0))
71DF_plSETUP_DISABLE_OR_IN_REPORT_CONTROLDISABLE_OR_IN_REPORT_CONTROL((1))
72DF_plSETUP_DISALLOW_AMEND_WEBLEAVE_LEAVE_RECORDSDISALLOW_AMEND_WEBLEAVE_LEAVE_RECORDS((0))
73DF_plSETUP_DOUBLE_PAY_BASE_ON_CURRENT_SALARYDOUBLE_PAY_BASE_ON_CURRENT_SALARY((0))
74DF_plSETUP_DOUBLEPAY_MPFDOUBLEPAY_MPF((0))
75DF_plSETUP_DOUBLEPAY_SMWDOUBLEPAY_SMW((0))
76DF_plSETUP_DOUBLEPAY_TAXDOUBLEPAY_TAX((0))
77DF_plSETUP_DOUBLEPAY_VISIBLEDOUBLEPAY_VISIBLE((0))
78DF_plSETUP_DOUBLEPAY_WAGEDOUBLEPAY_WAGE((0))
79DF_plSETUP_EE_NAME_INCLUDE_CALLNAMEEE_NAME_INCLUDE_CALLNAME((0))
80DF_plSETUP_EE_NAME_INCLUDE_CHINESENAMEEE_NAME_INCLUDE_CHINESENAME((0))
81DF_plSETUP_EE_NAME_INCLUDE_SUROTHERNAMEEE_NAME_INCLUDE_SUROTHERNAME((0))
82DF_plSETUP_ENABLE_40_WEEKS_CHECKING_FOR_PATERNITY_LEAVEENABLE_40_WEEKS_CHECKING_FOR_PATERNITY_LEAVE((0))
83DF_plSETUP_ENABLE_ADDITIONAL_AL_ENTITLEMENTENABLE_ADDITIONAL_AL_ENTITLEMENT((0))
84DF_plSETUP_ENABLE_ATTD_MINIMUM_WAGE_CALCENABLE_ATTD_MINIMUM_WAGE_CALC((0))
85DF_plSETUP_ENABLE_AUTO_SALARY_SMALL_AMOUNT_ADJUSTMENTENABLE_AUTO_SALARY_SMALL_AMOUNT_ADJUSTMENT((0))
86DF_plSETUP_ENABLE_CALLBACK_INOUTENABLE_CALLBACK_INOUT((0))
87DF_plSETUP_ENABLE_IR56MENABLE_IR56M((0))
88DF_plSETUP_ENABLE_LEAVE_AMPM_IN_LEAVE_ENTRYENABLE_LEAVE_AMPM_IN_LEAVE_ENTRY((1))
89DF_plSETUP_ENABLE_LEAVE_DAYS_OVERWRITEENABLE_LEAVE_DAYS_OVERWRITE((0))
90DF_plSETUP_ENABLE_LEAVE_TIME_IN_LEAVE_ENTRYENABLE_LEAVE_TIME_IN_LEAVE_ENTRY((0))
91DF_plSETUP_ENABLE_LUNCH_OUTINENABLE_LUNCH_OUTIN((0))
92DF_plSETUP_ENABLE_MULTIPLE_COST_CENTREENABLE_MULTIPLE_COST_CENTRE((0))
93DF_plSETUP_ENABLE_MULTIPLE_MIDMONTH_PAYROLLENABLE_MULTIPLE_MIDMONTH_PAYROLL((0))
94DF_plSETUP_ENABLE_OT_CALCENABLE_OT_CALC((0))
95DF_plSETUP_ENABLE_PAY_TYPE_TABLEENABLE_PAY_TYPE_TABLE((0))
96DF_plSETUP_ENABLE_PAY_TYPE_VALIDATIONENABLE_PAY_TYPE_VALIDATION((0))
97DF_plSETUP_ENABLE_PREPAID_BATCHENABLE_PREPAID_BATCH((0))
98DF_plSETUP_ENABLE_REFERRAL_BONUSENABLE_REFERRAL_BONUS((0))
99DF_plSETUP_ENABLE_REST_OUTINENABLE_REST_OUTIN((0))
100DF_plSETUP_ENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFOENABLE_TIMESHEET_WITHOUT_TIME_CLOCK_INFO((0))
101DF_plSETUP_ENABLE2007EAOENABLE2007EAO((0))
102DF_plSetup_ENTITLED_VC_AFTER_PROBATION_MONTHENTITLED_VC_AFTER_PROBATION_MONTH((0))
103DF_plSetup_ENTITLED_VC_AFTER_YEARS_OF_SERVICEENTITLED_VC_AFTER_YEARS_OF_SERVICE((0))
104DF_plSetup_ERVC_BASED_ONERVC_BASED_ON((0))
105DF_plSETUP_ERVC_USE_BASIC_SALARY_ONLYERVC_USE_BASIC_SALARY_ONLY((0))
106DF_plSETUP_EXCLUDE_MPF_CONTRIBUTION_VOUCHER_IN_GL_VOUCHEREXCLUDE_MPF_CONTRIBUTION_VOUCHER_IN_GL_VOUCHER((0))
107DF_plSETUP_FINAL_PAYMENT_AL_FORMULAFINAL_PAYMENT_AL_FORMULA('[12MthsAverageDailyRate]')
108DF_plSETUP_FINALPAY_ADD_ALPAYFINALPAY_ADD_ALPAY((0))
109DF_plSETUP_FIRST_YR_ROUND_UP_TO_INTFIRST_YR_ROUND_UP_TO_INT((0))
110DF_plSETUP_FULL_PAY_SICK_LEAVE_BALANCE_CANNOT_EXCEED_STATUTORY_SICK_LEAVE_BALANCEFULL_PAY_SICK_LEAVE_BALANCE_CANNOT_EXCEED_STATUTORY_SICK_LEAVE_BALANCE((0))
111DF_plSETUP_FULL_PAY_SICK_LEAVE_DAYS_COUNT_WORKING_DAYS_ONLYFULL_PAY_SICK_LEAVE_DAYS_COUNT_WORKING_DAYS_ONLY((0))
112DF_plSETUP_FULL_PAY_SICK_LEAVE_ENTITLEMENT_ENTITLED_AFTER_PROBATION_END_DATEFULL_PAY_SICK_LEAVE_ENTITLEMENT_ENTITLED_AFTER_PROBATION_END_DATE((0))
113DF_plSETUP_FULL_PAY_SICK_LEAVE_ENTITLEMENT_START_MONTHFULL_PAY_SICK_LEAVE_ENTITLEMENT_START_MONTH((1))
114DF_plSETUP_GENERATE_MPF_TO_IR56B_REMARKSGENERATE_MPF_TO_IR56B_REMARKS((0))
115DF_plSETUP_GROUP_SALARY_HOLIDAY_ANNAUL_LEAVE_SICK2_PAY_TO_SALARYGROUP_SALARY_HOLIDAY_ANNAUL_LEAVE_SICK2_PAY_TO_SALARY((0))
116DF_plSETUP_HIDE_COLUMNS_WITH_ZERO_TOTALHIDE_COLUMNS_WITH_ZERO_TOTAL((1))
117DF_plSETUP_HOLIDAYPAY_MPFHOLIDAYPAY_MPF((0))
118DF_plSETUP_HOLIDAYPAY_SMWHOLIDAYPAY_SMW((0))
119DF_plSETUP_HOLIDAYPAY_TAXHOLIDAYPAY_TAX((0))
120DF_plSETUP_HOLIDAYPAY_VISIBLEHOLIDAYPAY_VISIBLE((0))
121DF_plSETUP_HOLIDAYPAY_WAGEHOLIDAYPAY_WAGE((0))
122DF_plSETUP_IGNORED_IMPORT_PERIOD_CHECKINGIGNORED_IMPORT_PERIOD_CHECKING((0))
123DF_plSETUP_IGNORED_IR56M_INCOME_LIMITIGNORED_IR56M_INCOME_LIMIT((0))
124DF_plSETUP_INCLUDED_AREA_TO_IR_FORM_ADDRESSINCLUDED_AREA_TO_IR_FORM_ADDRESS((1))
125DF_plSETUP_INTRODUCER_BONUSINTRODUCER_REFERRAL_BONUS_FORMULA('')
126DF_plSETUP_IsWebLeaveSubscriptionServiceIsWebLeaveSubscriptionService((0))
127DF_plSETUP_KEEP_ATTENDANCE_RAW_DATAKEEP_ATTENDANCE_RAW_DATA((0))
128DF_plSETUP_LEAVE_DAYS_USE_REGULAR_FRACTIONLEAVE_DAYS_USE_REGULAR_FRACTION((0))
129DF_plSETUP_LEAVE_PERIOD_OF_MONTHLEAVE_PERIOD_OF_MONTH((1))
130DF_plSETUP_LEAVE_PERIOD_OFFSETLEAVE_PERIOD_OFFSET((0))
131DF_plSETUP_LEAVE_PERIOD_START_DAYLEAVE_PERIOD_START_DAY((1))
132DF_plSETUP_LSP_SP_CATLSP_SP_CAT('M')
133DF_plSETUP_LSP_SP_TAXLSP_SP_TAX((0))
134DF_plSETUP_LSP_SP_VISIBLELSP_SP_VISIBLE((0))
135DF_plSETUP_MATERNITYLEAVEPAY_MPFMATERNITYLEAVEPAY_MPF((0))
136DF_plSETUP_MATERNITYLEAVEPAY_SMWMATERNITYLEAVEPAY_SMW((0))
137DF_plSETUP_MATERNITYLEAVEPAY_TAXMATERNITYLEAVEPAY_TAX((0))
138DF_plSETUP_MATERNITYLEAVEPAY_VISIBLEMATERNITYLEAVEPAY_VISIBLE((0))
139DF_plSETUP_MATERNITYLEAVEPAY_WAGEMATERNITYLEAVEPAY_WAGE((0))
140DF_plSETUP_MAXIMUM_ACCUMULATED_COM_LEAVE_BALANCEMAXIMUM_ACCUMULATED_COM_LEAVE_BALANCE((0))
141DF_plSETUP_MPF_COMMENCE_DATE_CONSIDERS_GROUP_JOIN_DATEMPF_COMMENCE_DATE_CONSIDERS_GROUP_JOIN_DATE((0))
142DF_plSETUP_MPF_ER_60D_RETENTIONMPF_ER_60D_RETENTION((0))
143DF_plSETUP_MPF_EXCEL_FILE_GENERAL_ORDER_BY_EMPLOYEE_NAMEMPF_EXCEL_FILE_GENERAL_ORDER_BY_EMPLOYEE_NAME((0))
144DF_plSETUP_MPF_MID_MONTH_CONTRIBUTIONMPF_MID_MONTH_CONTRIBUTION((0))
145DF_plSETUP_MPF_USE_CERT_NO_AS_EE_NOMPF_USE_CERT_NO_AS_EE_NO((0))
146DF_plSETUP_NEW_STAFF_BONUSNEW_STAFF_REFERRAL_BONUS_FORMULA('')
147DF_plSETUP_NO_ACUTAL_AL_ENTITLEMENT_BEFORE_PROBATIONNO_ACUTAL_AL_ENTITLEMENT_BEFORE_PROBATION((1))
148DF_plSETUP_NO_BIRTHDATE_CHECKINGNO_BIRTHDATE_CHECKING((0))
149DF_plSETUP_NO_ELIGIBLE_AL_ENTITLEMENT_FOR_FIRST_3_MONTHSNO_ELIGIBLE_AL_ENTITLEMENT_FOR_FIRST_3_MONTHS((0))
150DF_plSETUP_NO_MINIMUM_LEVEL_FOR_MIDMONTH_MPFNO_MINIMUM_LEVEL_FOR_MIDMONTH_MPF((0))
151DF_plSETUP_NO_TERMINATEDEE_AUTOPAY_CHECKINGNO_TERMINATEDEE_AUTOPAY_CHECKING((0))
152DF_plSETUP_NO_TERMINATEDEE_PAYSLIP_EMAIL_CHECKINGNO_TERMINATEDEE_PAYSLIP_EMAIL_CHECKING((0))
153DF_plSETUP_NOPAY_DAYS_FROM_LEAVE_MODULENOPAY_DAYS_FROM_LEAVE_MODULE((0))
154DF_plSETUP_OT_MPFOT_MPF((0))
155DF_plSETUP_OT_OVER_20OT_OVER_20((0))
156DF_plSETUP_OT_SMWOT_SMW((0))
157DF_plSETUP_OT_TAXOT_TAX((0))
158DF_plSETUP_OT_VISIBLEOT_VISIBLE((0))
159DF_plSETUP_OT_WAGEOT_WAGE((0))
160DF_plSETUP_OT7)TAXOT7_TAX((1))
161DF_plSETUP_OT7_MPFOT7_MPF((1))
162DF_plSETUP_OT7_SMWOT7_SMW((1))
163DF_plSETUP_OT7_VISIBLEOT7_VISIBLE((1))
164DF_plSETUP_OT7_WAGEOT7_WAGE((1))
165DF_plSETUP_OT8_MPFOT8_MPF((1))
166DF_plSETUP_OT8_SMWOT8_SMW((1))
167DF_plSETUP_OT8_TAXOT8_TAX((1))
168DF_plSETUP_OT8_VISIBLEOT8_VISIBLE((1))
169DF_plSETUP_OT8_WAGEOT8_WAGE((1))
170DF_plSETUP_PAY_TYPE_DESCRIPTION_ON_PAYROLL_REPORTS_BASED_ON_PAYROLL_RECORDPAY_TYPE_DESCRIPTION_ON_PAYROLL_REPORTS_BASED_ON_PAYROLL_RECORD((0))
171DF_plSETUP_PAY_TYPE1_MPFPAY_TYPE1_MPF((0))
172DF_plSETUP_PAY_TYPE1_SMWPAY_TYPE1_SMW((0))
173DF_plSETUP_PAY_TYPE1_TAXPAY_TYPE1_TAX((0))
174DF_plSETUP_PAY_TYPE1_VISIBLEPAY_TYPE1_VISIBLE((0))
175DF_plSETUP_PAY_TYPE1_WAGEPAY_TYPE1_WAGE((0))
176DF_plSETUP_PAY_TYPE10_MPFPAY_TYPE10_MPF((0))
177DF_plSETUP_PAY_TYPE10_SMWPAY_TYPE10_SMW((0))
178DF_plSETUP_PAY_TYPE10_TAXPAY_TYPE10_TAX((0))
179DF_plSETUP_PAY_TYPE10_VISIBLEPAY_TYPE10_VISIBLE((0))
180DF_plSETUP_PAY_TYPE10_WAGEPAY_TYPE10_WAGE((0))
181DF_plSETUP_PAY_TYPE11_MPFPAY_TYPE11_MPF((0))
182DF_plSETUP_PAY_TYPE11_SMWPAY_TYPE11_SMW((0))
183DF_plSETUP_PAY_TYPE11_TAXPAY_TYPE11_TAX((0))
184DF_plSETUP_PAY_TYPE11_VISIBLEPAY_TYPE11_VISIBLE((0))
185DF_plSETUP_PAY_TYPE11_WAGEPAY_TYPE11_WAGE((0))
186DF_plSETUP_PAY_TYPE12_MPFPAY_TYPE12_MPF((0))
187DF_plSETUP_PAY_TYPE12_SMWPAY_TYPE12_SMW((0))
188DF_plSETUP_PAY_TYPE12_TAXPAY_TYPE12_TAX((0))
189DF_plSETUP_PAY_TYPE12_VISIBLEPAY_TYPE12_VISIBLE((0))
190DF_plSETUP_PAY_TYPE12_WAGEPAY_TYPE12_WAGE((0))
191DF_plSETUP_PAY_TYPE13_MPFPAY_TYPE13_MPF((0))
192DF_plSETUP_PAY_TYPE13_SMWPAY_TYPE13_SMW((0))
193DF_plSETUP_PAY_TYPE13_TAXPAY_TYPE13_TAX((0))
194DF_plSETUP_PAY_TYPE13_VISIBLEPAY_TYPE13_VISIBLE((0))
195DF_plSETUP_PAY_TYPE13_WAGEPAY_TYPE13_WAGE((0))
196DF_plSETUP_PAY_TYPE14_MPFPAY_TYPE14_MPF((0))
197DF_plSETUP_PAY_TYPE14_SMWPAY_TYPE14_SMW((0))
198DF_plSETUP_PAY_TYPE14_TAXPAY_TYPE14_TAX((0))
199DF_plSETUP_PAY_TYPE14_VISIBLEPAY_TYPE14_VISIBLE((0))
200DF_plSETUP_PAY_TYPE14_WAGEPAY_TYPE14_WAGE((0))
201DF_plSETUP_PAY_TYPE15_MPFPAY_TYPE15_MPF((0))
202DF_plSETUP_PAY_TYPE15_SMWPAY_TYPE15_SMW((0))
203DF_plSETUP_PAY_TYPE15_TAXPAY_TYPE15_TAX((0))
204DF_plSETUP_PAY_TYPE15_VISIBLEPAY_TYPE15_VISIBLE((0))
205DF_plSETUP_PAY_TYPE15_WAGEPAY_TYPE15_WAGE((0))
206DF_plSETUP_PAY_TYPE2_MPFPAY_TYPE2_MPF((0))
207DF_plSETUP_PAY_TYPE2_SMWPAY_TYPE2_SMW((0))
208DF_plSETUP_PAY_TYPE2_TAXPAY_TYPE2_TAX((0))
209DF_plSETUP_PAY_TYPE2_VISIBLEPAY_TYPE2_VISIBLE((0))
210DF_plSETUP_PAY_TYPE2_WAGEPAY_TYPE2_WAGE((0))
211DF_plSETUP_PAY_TYPE3_MPFPAY_TYPE3_MPF((0))
212DF_plSETUP_PAY_TYPE3_SMWPAY_TYPE3_SMW((0))
213DF_plSETUP_PAY_TYPE3_TAXPAY_TYPE3_TAX((0))
214DF_plSETUP_PAY_TYPE3_VISIBLEPAY_TYPE3_VISIBLE((0))
215DF_plSETUP_PAY_TYPE3_WAGEPAY_TYPE3_WAGE((0))
216DF_plSETUP_PAY_TYPE4_MPFPAY_TYPE4_MPF((0))
217DF_plSETUP_PAY_TYPE4_SMWPAY_TYPE4_SMW((0))
218DF_plSETUP_PAY_TYPE4_TAXPAY_TYPE4_TAX((0))
219DF_plSETUP_PAY_TYPE4_VISIBLEPAY_TYPE4_VISIBLE((0))
220DF_plSETUP_PAY_TYPE4_WAGEPAY_TYPE4_WAGE((0))
221DF_plSETUP_PAY_TYPE5_MPFPAY_TYPE5_MPF((0))
222DF_plSETUP_PAY_TYPE5_SMWPAY_TYPE5_SMW((0))
223DF_plSETUP_PAY_TYPE5_TAXPAY_TYPE5_TAX((0))
224DF_plSETUP_PAY_TYPE5_VISIBLEPAY_TYPE5_VISIBLE((0))
225DF_plSETUP_PAY_TYPE5_WAGEPAY_TYPE5_WAGE((0))
226DF_plSETUP_PAY_TYPE6_MPFPAY_TYPE6_MPF((0))
227DF_plSETUP_PAY_TYPE6_SMWPAY_TYPE6_SMW((0))
228DF_plSETUP_PAY_TYPE6_TAXPAY_TYPE6_TAX((0))
229DF_plSETUP_PAY_TYPE6_VISIBLEPAY_TYPE6_VISIBLE((0))
230DF_plSETUP_PAY_TYPE6_WAGEPAY_TYPE6_WAGE((0))
231DF_plSETUP_PAY_TYPE7_MPFPAY_TYPE7_MPF((0))
232DF_plSETUP_PAY_TYPE7_SMWPAY_TYPE7_SMW((0))
233DF_plSETUP_PAY_TYPE7_TAXPAY_TYPE7_TAX((0))
234DF_plSETUP_PAY_TYPE7_VISIBLEPAY_TYPE7_VISIBLE((0))
235DF_plSETUP_PAY_TYPE7_WAGEPAY_TYPE7_WAGE((0))
236DF_plSETUP_PAY_TYPE8_MPFPAY_TYPE8_MPF((0))
237DF_plSETUP_PAY_TYPE8_SMWPAY_TYPE8_SMW((0))
238DF_plSETUP_PAY_TYPE8_TAXPAY_TYPE8_TAX((0))
239DF_plSETUP_PAY_TYPE8_VISIBLEPAY_TYPE8_VISIBLE((0))
240DF_plSETUP_PAY_TYPE8_WAGEPAY_TYPE8_WAGE((0))
241DF_plSETUP_PAY_TYPE9_MPFPAY_TYPE9_MPF((0))
242DF_plSETUP_PAY_TYPE9_SMWPAY_TYPE9_SMW((0))
243DF_plSETUP_PAY_TYPE9_TAXPAY_TYPE9_TAX((0))
244DF_plSETUP_PAY_TYPE9_VISIBLEPAY_TYPE9_VISIBLE((0))
245DF_plSETUP_PAY_TYPE9_WAGEPAY_TYPE9_WAGE((0))
246DF_plSETUP_PAYROLL_PERIOD_OF_MONTHPAYROLL_PERIOD_OF_MONTH((1))
247DF_plSETUP_PAYROLL_PERIOD_START_DAYPAYROLL_PERIOD_START_DAY((1))
248DF_plSETUP_PAYSLIP_LEFT_MARGINPAYSLIP_LEFT_MARGIN((1.5))
249DF_plSETUP_PAYSLIP_PRINTS_ANNUAL_LEAVE_BALANCEPAYSLIP_PRINTS_ANNUAL_LEAVE_BALANCE((0))
250DF_plSETUP_PAYSLIP_PRINTS_BADGE_NUMBERPAYSLIP_PRINTS_BADGE_NUMBER((0))
251DF_plSETUP_PAYSLIP_PRINTS_BANK_ACPAYSLIP_PRINTS_BANK_AC((0))
252DF_plSETUP_PAYSLIP_PRINTS_BASIC_SALARY_REFPAYSLIP_PRINTS_BASIC_SALARY_REF((0))
253DF_plSETUP_PAYSLIP_PRINTS_BIRTHDATEPAYSLIP_PRINTS_BIRTHDATE((0))
254DF_plSETUP_PAYSLIP_PRINTS_CALL_NAMEPAYSLIP_PRINTS_CALL_NAME((1))
255DF_plSETUP_PAYSLIP_PRINTS_CHINESE_NAMEPAYSLIP_PRINTS_CHINESE_NAME((1))
256DF_plSETUP_PAYSLIP_PRINTS_COM_LEAVE_BALANCEPAYSLIP_PRINTS_COM_LEAVE_BALANCE((0))
257DF_plSETUP_PAYSLIP_PRINTS_COM_LEAVE_CURRENT_BALANCEPAYSLIP_PRINTS_COM_LEAVE_CURRENT_BALANCE((0))
258DF_plSETUP_PAYSLIP_PRINTS_COMPANY_NAMEPAYSLIP_PRINTS_COMPANY_NAME((0))
259DF_plSETUP_PAYSLIP_PRINTS_DAILY_RATESPAYSLIP_PRINTS_DAILY_RATES((0))
260DF_plSetup_PAYSLIP_PRINTS_DAILY_RATES_FOR_NOPAY_LEAVEPAYSLIP_PRINTS_DAILY_RATES_FOR_NOPAY_LEAVE((0))
261DF_plSETUP_PAYSLIP_PRINTS_DEPARTMENTPAYSLIP_PRINTS_DEPARTMENT((1))
262DF_plSETUP_PAYSLIP_PRINTS_DEPT_CODE_ON_DEPARTMENTPAYSLIP_PRINTS_DEPT_CODE_ON_DEPARTMENT((1))
263DF_plSETUP_PAYSLIP_PRINTS_FULLPAY_SICK_LEAVE_BALANCEPAYSLIP_PRINTS_FULLPAY_SICK_LEAVE_BALANCE((0))
264DF_plSETUP_PAYSLIP_PRINTS_JOIN_DATEPAYSLIP_PRINTS_JOIN_DATE((0))
265DF_plSETUP_PAYSLIP_PRINTS_POSITIONPAYSLIP_PRINTS_POSITION((1))
266DF_plSETUP_PAYSLIP_PRINTS_PRINT_DATEPAYSLIP_PRINTS_PRINT_DATE((1))
267DF_plSETUP_PAYSLIP_PRINTS_YTD_MPFPAYSLIP_PRINTS_YTD_MPF((0))
268DF_plSETUP_PAYSLIP_TOP_MARGINPAYSLIP_TOP_MARGIN((0))
269DF_plSETUP_PREVENT_OVERWRITE_UPDATED_IR56BM_RECORDPREVENT_OVERWRITE_UPDATED_IR56BM_RECORD((0))
270DF_plSETUP_PREVENT_OVERWRITE_UPDATED_PAYROLL_RECORDPREVENT_OVERWRITE_UPDATED_PAYROLL_RECORD((1))
271DF_plSETUP_PRORATED_INCLUDE_ALLOWANCE1PRORATED_INCLUDE_ALLOWANCE1((0))
272DF_plSETUP_PRORATED_INCLUDE_ALLOWANCE2PRORATED_INCLUDE_ALLOWANCE2((0))
273DF_plSETUP_PRORATED_SALARY_USE_START_DATEPRORATED_SALARY_USE_START_DATE((0))
274DF_plSETUP_REFERRAL_BONUS_PAY_TYPEREFERRAL_BONUS_PAY_TYPE((0))
275DF_plSETUP_REFERRAL_BONUS_PAY_TYPE_DESCREFERRAL_BONUS_PAY_TYPE_DESC('')
276DF_plSETUP_REFERRAL_BONUS_RELEASE_AFTER_MONTHSREFERRAL_BONUS_RELEASE_AFTER_MONTHS((0))
277DF_plSETUP_RESERVE_MPF_TO_PAYTYPERESERVE_MPF_TO_PAYTYPE((0))
278DF_plSETUP_REST_DAY_ENTITLEMENT_BASED_ON_7_DAYS_PER_1REST_DAY_ENTITLEMENT_BASED_ON_7_DAYS_PER_1((0))
279DF_plSETUP_REST_DAY_TAKEN_INCLUDES_FULL_PAY_REST_DAYREST_DAY_TAKEN_INCLUDES_FULL_PAY_REST_DAY((1))
280DF_plSETUP_REST_DAY_TAKEN_INCLUDES_NOT_FULL_PAY_REST_DAYREST_DAY_TAKEN_INCLUDES_NOT_FULL_PAY_REST_DAY((0))
281DF_plSETUP_REST_DAY_TAKEN_INCLUDES_ROSTER_TABLEREST_DAY_TAKEN_INCLUDES_ROSTER_TABLE((0))
282DF_plSETUP_RETAIN_DAYSRETAIN_DAYS((0))
283DF_plSETUP_ROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_HOLIDAY_TABLEROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_HOLIDAY_TABLE((0))
284DF_plSETUP_ROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_ROSTER_TABLEROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_ROSTER_TABLE((0))
285DF_plSETUP_ROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_SH_LEAVEROSTER_EMPLOYEE_HOLIDAY_PAY_BASED_ON_SH_LEAVE((0))
286DF_plSETUP_SHOW_AUTHORIZED_SIGNATURE_SECTION_IN_MPF_GENERAL_REPORTSHOW_AUTHORIZED_SIGNATURE_SECTION_IN_MPF_GENERAL_REPORT((0))
287DF_plSETUP_SHOW_CARD_TIMESSHOW_CARD_TIMES((1))
288DF_plSETUP_SHOW_FORFEIT_ACTUAL_BALANCE_BUTTONSHOW_FORFEIT_ACTUAL_BALANCE_BUTTON((0))
289DF_plSETUP_SHOW_FORFEIT_BALANCE_BF_BUTTONSHOW_FORFEIT_BALANCE_BF_BUTTON((0))
290DF_plSETUP_SHOW_FORFEIT_BALANCE_BF_MINUS_TY_LEAVE_BUTTONSHOW_FORFEIT_BALANCE_BF_MINUS_TY_LEAVE_BUTTON((0))
291DF_plSETUP_SHOW_HOLIDAY_ON_ROSTER_TABLESHOW_HOLIDAY_ON_ROSTER_TABLE((1))
292DF_plSETUP_SHOW_STATUS_ROW_IN_ATTENDANCE_RECORDSHOW_STATUS_ROW_IN_ATTENDANCE_RECORD((1))
293DF_plSETUP_SHOW_TERMINATION_REASON_TABLE_IN_MPF_GENERAL_REPORTSHOW_TERMINATION_REASON_TABLE_IN_MPF_GENERAL_REPORT((0))
294DF_plSETUP_SICK_LEAVE_BALANCE_PARTIAL_PAY_CONSIDERS_SICK_LEAVE_FULL_PAY_TAKENSICK_LEAVE_BALANCE_PARTIAL_PAY_CONSIDERS_SICK_LEAVE_FULL_PAY_TAKEN((0))
295DF_plSETUP_SICKNESSALLOWANCE_MPFSICKNESSALLOWANCE_MPF((0))
296DF_plSETUP_SICKNESSALLOWANCE_SMWSICKNESSALLOWANCE_SMW((0))
297DF_plSETUP_SICKNESSALLOWANCE_TAXSICKNESSALLOWANCE_TAX((0))
298DF_plSETUP_SICKNESSALLOWANCE_VISIBLESICKNESSALLOWANCE_VISIBLE((0))
299DF_plSETUP_SICKNESSALLOWANCE_WAGESICKNESSALLOWANCE_WAGE((0))
300DF_plSETUP_SICKNESSALLOWANCE2_MPFSICKNESSALLOWANCE2_MPF((0))
301DF_plSETUP_SICKNESSALLOWANCE2_SMWSICKNESSALLOWANCE2_SMW((0))
302DF_plSETUP_SICKNESSALLOWANCE2_TAXSICKNESSALLOWANCE2_TAX((0))
303DF_plSETUP_SICKNESSALLOWANCE2_VISIBLESICKNESSALLOWANCE2_VISIBLE((0))
304DF_plSETUP_SICKNESSALLOWANCE2_WAGESICKNESSALLOWANCE2_WAGE((0))
305DF_plSETUP_STATUTORY_SICK_LEAVE_INCLUDE_SHSTATUTORY_SICK_LEAVE_INCLUDE_SH((0))
306DF_plSETUP_STATUTORY_SICKNESS_DAYS_EXCLUDE_REST_DAYSSTATUTORY_SICK_LEAVE_DAYS_COUNT_WORKING_DAYS_ONLY((0))
307DF_plSETUP_TAX_IR56B_CHINESE_NAME_BLANKTAX_IR56B_CHINESE_NAME_BLANK((0))
308DF_plSETUP_TENTATIVE_DAYS_PER_MONTHTENTATIVE_DAYS_PER_MONTH((0))
309DF_plSETUP_TENTATIVE_HOURS_PER_DAYTENTATIVE_HOURS_PER_DAY((0))
310DF_plSETUP_TREAT_ABSENT_AS_NO_PAY_LEAVETREAT_ABSENT_AS_NO_PAY_LEAVE((0))
311DF_plSETUP_TREAT_DATE_JOIN_SCHEME_AS_EE_COMMENCE_DATETREAT_DATE_JOIN_SCHEME_AS_EE_COMMENCE_DATE((0))
312DF_plSETUP_TREAT_GROUP_JOIN_DATE_AS_AL_ENTITLEMENT_START_DATETREAT_GROUP_JOIN_DATE_AS_AL_ENTITLEMENT_START_DATE((1))
313DF_plSETUP_USE_CURRENT_MONTH_WAGEUSE_CURRENT_MONTH_WAGE((0))
314DF_plSETUP_USE_CURRENT_MONTH_WAGE_ANNUALLEAVEPAYUSE_CURRENT_MONTH_WAGE_ANNUALLEAVEPAY((0))
315DF_plSETUP_USE_CURRENT_MONTH_WAGE_HOLIDAYPAYUSE_CURRENT_MONTH_WAGE_HOLIDAYPAY((0))
316DF_plSETUP_USE_CURRENT_MONTH_WAGE_MATERNITYLEAVEPAYUSE_CURRENT_MONTH_WAGE_MATERNITYLEAVEPAY((0))
317DF_plSETUP_USE_CURRENT_MONTH_WAGE_SICKNESSALLOWANCEUSE_CURRENT_MONTH_WAGE_SICKNESSALLOWANCE((0))
318DF_plSETUP_USE_CURRENT_MONTH_WAGE_SICKNESSALLOWANCE2USE_CURRENT_MONTH_WAGE_SICKNESSALLOWANCE2((0))
319DF_plSETUP_USE_EXACT_TIME_WHEN_CAL_LEAVEDAYS_FROM_AMPMUSE_EXACT_TIME_WHEN_CAL_LEAVEDAYS_FROM_AMPM((0))
320DF_plSETUP_USE_EXACT_TIME_WHEN_CAL_LEAVEDAYS_FROM_TIMEUSE_EXACT_TIME_WHEN_CAL_LEAVEDAYS_FROM_TIME((0))
321DF_plSETUP_USE_LEAVE_PERIOD_IN_EE_CLASSUSE_LEAVE_PERIOD_IN_EE_CLASS((0))
322DF_plSETUP_USE_REGULAR_DAYS_FOR_DAILY_EEUSE_REGULAR_DAYS_FOR_DAILY_EE((0))
323DF_plSETUP_USE_REGULAR_HOURS_FOR_HOURLY_EEUSE_REGULAR_HOURS_FOR_HOURLY_EE((0))
324DF_plSETUP_USE_REGULAR_HOURS_FOR_IN_OUT_TIMEUSE_REGULAR_HOURS_FOR_IN_OUT_TIME((0))
325DF_plSETUP_USER01_VISIBLEUSER01_VISIBLE((0))
326DF_plSETUP_USER02_VISIBLEUSER02_VISIBLE((0))
327DF_plSETUP_USER03_VISIBLEUSER03_VISIBLE((0))
328DF_plSETUP_USER04_VISIBLEUSER04_VISIBLE((0))
329DF_plSETUP_USER05_VISIBLEUSER05_VISIBLE((0))
330DF_plSETUP_USER06_VISIBLEUSER06_VISIBLE((0))
331DF_plSETUP_USER07_VISIBLEUSER07_VISIBLE((0))
332DF_plSETUP_USER08_VISIBLEUSER08_VISIBLE((0))
333DF_plSETUP_USER09_VISIBLEUSER09_VISIBLE((0))
334DF_plSETUP_USER10_VISIBLEUSER10_VISIBLE((0))
335DF_plSETUP_USER11_VISIBLEUSER11_VISIBLE((0))
336DF_plSETUP_USER12_VISIBLEUSER12_VISIBLE((0))
337DF_plSETUP_USER13_VISIBLEUSER13_VISIBLE((0))
338DF_plSETUP_USER14_VISIBLEUSER14_VISIBLE((0))
339DF_plSETUP_USER15_VISIBLEUSER15_VISIBLE((0))
340DF_plSETUP_USER16_VISIBLEUSER16_VISIBLE((0))
341DF_plSETUP_USER17_VISIBLEUSER17_VISIBLE((0))
342DF_plSETUP_USER18_VISIBLEUSER18_VISIBLE((0))
343DF_plSETUP_USER19_VISIBLEUSER19_VISIBLE((0))
344DF_plSETUP_USER20_VISIBLEUSER20_VISIBLE((0))
345DF_plSETUP_USER21_VISIBLEUSER21_VISIBLE((0))
346DF_plSETUP_USER22_VISIBLEUSER22_VISIBLE((0))
347DF_plSETUP_USER23_VISIBLEUSER23_VISIBLE((0))
348DF_plSETUP_USER24_VISIBLEUSER24_VISIBLE((0))
349DF_plSETUP_USER25_VISIBLEUSER25_VISIBLE((0))
350DF_plSetup_VC_INCOME_CONSIDERED_MPF_MAXIMUM_INCOMEVC_INCOME_CONSIDERED_MPF_MAXIMUM_INCOME((0))
351DF_plSetup_WAGES_IN_LIEU_BY_MONTH_TAXWAGES_IN_LIEU_BY_MONTH_TAX((1))
352DF_plSetup_WAGES_IN_LIEU_BY_MONTH_VISIBLEWAGES_IN_LIEU_BY_MONTH_VISIBLE((0))
353DF_plSETUP_WAGES_IN_LIEU_DAILYRATE_FORMULAWAGES_IN_LIEU_DAILYRATE_FORMULA('')
354DF_plSetup_WAGES_IN_LIEU_MONTHRATE_FORMULAWAGES_IN_LIEU_MONTHLYRATE_FORMULA('')
355DF_plSETUP_WAGES_IN_LIEU_TAXWAGES_IN_LIEU_TAX((1))
356DF_plSETUP_WAGES_IN_LIEU_VISIBLEWAGES_IN_LIEU_VISIBLE((0))
357DF_plSETUP_WEBLEAVE_APPLICATION_ACTION_IS_FINALWEBLEAVE_APPLICATION_ACTION_IS_FINAL((1))
358DF_plSETUP_WITH_AMWITH_AM((0))
359DF_plSETUP_WITH_BAWITH_BA((0))
360DF_plSETUP_WITH_LMWITH_LM((0))
361DF_plSETUP_WITH_MEWITH_ME((0))
362DF_plSETUP_WITH_PAWITH_PA((0))
363DF_plSETUP_WITH_PMWITH_PM((0))
364DF_plSETUP_WITH_RDWITH_RD((0))
365DF_plSETUP_WITH_TMWITH_TM((0))
366DF_plSETUP_WITH_WLWITH_WL((0))
367DF_plSetup_WITH_XMWITH_XM((1))
368DF_plSETUP_WORK_HRS_ROSTER_CONSIDERS_APPOINTMENT_HISTORYWORK_HRS_ROSTER_CONSIDERS_APPOINTMENT_HISTORY((0))

Triggers
Sr.NameDescription
1Tr_plSetup_Validating
2Tr_PLSETUPChangeLog

Indexes
Sr.NameTypeColumns
1PK_plSETUPClusteredCOMPANY_CODE




Index
Table:[dbo].[plShift]

Description
Shift Code Table

Table Columns
Sr.NameDatatypeNullableDescription
1SHIFT_CODENVARCHAR(20)N
2AUTHORIZEDBITN
3DESCRIPTIONNVARCHAR(120)Y
4SHIFT_TYPECHAR(1)N
5ENABLE_BOOK_TIMEBITN
6IN_TIMEVARCHAR(5)Y
7IN_TIME_BEFOREINTY
8OUT_TIMEVARCHAR(5)Y
9OUT_TIME_AFTERINTY
10LATE_TOLERANCEINTY
11LT_ONLY_IF_OT_FOR_HRSDECIMAL(18,2)Y
12LATE_TOLERANCE2INTY
13LT2_ONLY_IF_OT_FOR_HRSDECIMAL(18,2)Y
14EARLY_OUT_TOLERANCEINTY
15INCLUDE_LUNCH_HOURBITN
16PAY_LUNCH_BREAKBITN
17ENABLE_LUNCH_TIMEBITN
18LUNCH_OUT_TIMEVARCHAR(5)Y
19LUNCH_OUT_TOLERANCEINTY
20LUNCH_OUT_SCAN_FROMVARCHAR(5)Y
21LUNCH_OUT_SCAN_TOVARCHAR(5)Y
22LUNCH_IN_TIMEVARCHAR(5)Y
23LUNCH_IN_TOLERANCEINTY
24LUNCH_IN_SCAN_FROMVARCHAR(5)Y
25LUNCH_IN_SCAN_TOVARCHAR(5)Y
26OT_MINIMUM_MINSINTY
27OT_MINIMUM_MINS_EARLY_OTINTN
28OT_MINIMUM_MINS_AFTERWORK_OTINTN
29OT_MAXIMUM_HRSINTY
30OT_MEAL_TIME_DEDUCT_WHEN_WORKED_MORE_THAN_HRSDECIMAL(18,2)Y
31OT_ALLOW_EARLYTIMEBITN
32OT_TRUNCATETO_QUARTERINTY
33OT_PAY_INCLUDED_MINIMUM_MINSBITN
34WORK_HRSDECIMAL(18,4)Y
35LUNCH_HRSDECIMAL(18,4)Y
36LATE_DEDUCTIONBITN
37EARLYOUT_DEDUCTIONBITN
38SHORT_DEDUCTIONBITN
39EXCLUDE_EARLIER_THAN_IN_TIMEBITN
40EXCLUDE_LATER_THAN_OUT_TIMEBITN
41OT_HRS_BASE_ON_WORKED_HRSBITN
42LATE_IN_EXCLUDE_LATE_TOLERANCEBITN
43EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCEBITN
44FLEXIBLE_LUNCH_HOURSBITN
45ANNLEAVE_ASNCHAR(2)Y
46ATTENDANCE_ALLOWANCE_FORMULANVARCHAR(4000)Y
47ATTENDANCE_ALLOWANCE_HRS_OVERDECIMAL(18,2)N
48ATTENDANCE_ALLOWANCE_PAYTYPEINTN
49ATTENDANCE_ALLOWANCE_PAYTYPE_TABLE_DESCNVARCHAR(100)N
50CHECK_IN_CUT_OFF_HOURVARCHAR(5)Y
51CUT_OFF_HOURVARCHAR(5)Y
52WORK_LOCATIONNVARCHAR(20)Y
53NO_LATE_IN_CALCULATIONBITN
54NO_EARLY_OUT_CALCULATIONBITN
55NO_SHORT_CALCULATIONBITN
56NO_LUNCH_LATE_IN_CALCULATIONBITN
57NO_LUNCH_EARLY_OUT_CALCULATIONBITN
58NO_LUNCH_SHORT_CALCULATIONBITN
59INCLUDE_REST_HOURBITN
60PAY_REST_BREAKBITN
61ENABLE_REST_TIMEBITN
62REST_OUT_TIMEVARCHAR(5)Y
63REST_OUT_TOLERANCEINTY
64REST_OUT_SCAN_FROMVARCHAR(5)Y
65REST_OUT_SCAN_TOVARCHAR(5)Y
66REST_IN_TIMEVARCHAR(5)Y
67REST_IN_TOLERANCEINTY
68REST_IN_SCAN_FROMVARCHAR(5)Y
69REST_IN_SCAN_TOVARCHAR(5)Y
70REST_HRSDECIMAL(18,4)Y
71FLEXIBLE_REST_HOURSBITN
72NO_REST_LATE_IN_CALCULATIONBITN
73NO_REST_EARLY_OUT_CALCULATIONBITN
74NO_REST_SHORT_CALCULATIONBITN
75COLOR_CODENVARCHAR(40)Y
76NOT_ABSENTBITN
77SESSION1_HOURLY_RATEINTN
78SESSION2_HOURLY_RATEINTN
79SESSION3_HOURLY_RATEINTN
80CREATE_BYCHAR(10)Y
81CREATE_DATEDATETIMEY
82LAST_UPDATE_BYCHAR(10)Y
83LAST_UPDATE_DATEDATETIMEY
84ATTENDANCE_ALLOWANCEDECIMAL(18,2)Yobsoleted

Default Constraints
Sr.NameColumnValue
1DF_plShift_ATTENDANCE_ALLOWANCE_HRS_OVERATTENDANCE_ALLOWANCE_HRS_OVER((0))
2DF_plShift_ATTENDANCE_ALLOWANCE_PAYTYPEATTENDANCE_ALLOWANCE_PAYTYPE((0))
3DF_plShift_ATTENDANCE_ALLOWANCE_PAYTYPE_DESCATTENDANCE_ALLOWANCE_PAYTYPE_TABLE_DESC('')
4DF_plShift_AUTHORIZEDAUTHORIZED((0))
5DF_plShift_CHECK_IN_CUT_OFF_HOURCHECK_IN_CUT_OFF_HOUR('')
6DF_plShift_COLOR_CODECOLOR_CODE('')
7DF_plShift_CUT_OFF_HOURCUT_OFF_HOUR('')
8DF_plShift_EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCEEARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCE((0))
9DF_plShift_EARLYOUT_DEDUCTIONEARLYOUT_DEDUCTION((0))
10DF_plShift_ENABLE_BOOK_TIMEENABLE_BOOK_TIME((0))
11DF_plShift_ENABLE_LUNCH_TIMEENABLE_LUNCH_TIME((0))
12DF_plShift_ENABLE_REST_TIMEENABLE_REST_TIME((0))
13DF_plShift_EXCLUDE_EARLIER_THAN_IN_TIMEEXCLUDE_EARLIER_THAN_IN_TIME((0))
14DF_plShift_EXCLUDE_LATER_THAN_OUT_TIMEEXCLUDE_LATER_THAN_OUT_TIME((0))
15DF_plShift_FLEXIBLE_LUNCH_HOURSFLEXIBLE_LUNCH_HOURS((0))
16DF_plShift_FLEXIBLE_REST_HOURSFLEXIBLE_REST_HOURS((0))
17DF_plShift_INCLUDE_LUNCH_HOURINCLUDE_LUNCH_HOUR((0))
18DF_plShift_INCLUDE_REST_HOURINCLUDE_REST_HOUR((0))
19DF_plShift_LATE_DEDUCTIONLATE_DEDUCTION((0))
20DF_plShift_LATE_IN_EXCLUDE_LATE_TOLERANCELATE_IN_EXCLUDE_LATE_TOLERANCE((0))
21DF_plShift_NO_EARLY_OUT_CALCULATIONNO_EARLY_OUT_CALCULATION((0))
22DF_plShift_NO_LATE_IN_CALCULATIONNO_LATE_IN_CALCULATION((0))
23DF_plShift_NO_LUNCH_EARLY_OUT_CALCULATIONNO_LUNCH_EARLY_OUT_CALCULATION((0))
24DF_plShift_NO_LUNCH_LATE_IN_CALCULATIONNO_LUNCH_LATE_IN_CALCULATION((0))
25DF_plShift_NO_LUNCH_SHORT_CALCULATIONNO_LUNCH_SHORT_CALCULATION((0))
26DF_plShift_NO_REST_EARLY_OUT_CALCULATIONNO_REST_EARLY_OUT_CALCULATION((0))
27DF_plShift_NO_REST_LATE_IN_CALCULATIONNO_REST_LATE_IN_CALCULATION((0))
28DF_plShift_NO_REST_SHORT_CALCULATIONNO_REST_SHORT_CALCULATION((0))
29DF_plShift_NO_SHORT_CALCULATIONNO_SHORT_CALCULATION((0))
30DF_plShift_NOT_ABSENTNOT_ABSENT((0))
31DF_plShift_OT_ALLOW_EARLYTIMEOT_ALLOW_EARLYTIME((0))
32DF_plShift_OT_HRS_BASE_ON_WORKED_HRSOT_HRS_BASE_ON_WORKED_HRS((0))
33DF_plShift_OT_MINIMUM_MINS_AFTERWORK_OTOT_MINIMUM_MINS_AFTERWORK_OT((0))
34DF_plShift_OT_MINIMUM_MINS_EARLY_OTOT_MINIMUM_MINS_EARLY_OT((0))
35DF_plShift_OT_PAY_INCLUDED_MINIMUM_MINSOT_PAY_INCLUDED_MINIMUM_MINS((0))
36DF_plShift_PAY_LUNCH_BREAKPAY_LUNCH_BREAK((0))
37DF_plShift_PAY_REST_BREAKPAY_REST_BREAK((0))
38DF_plShift_SESSION1_HOURLY_RATESESSION1_HOURLY_RATE((1))
39DF_plShift_SESSION2_HOURLY_RATESESSION2_HOURLY_RATE((2))
40DF_plShift_SESSION3_HOURLY_RATESESSION3_HOURLY_RATE((3))
41DF_plShift_SHIFT_TYPESHIFT_TYPE('N')
42DF_plShift_SHORT_DEDUCTIONSHORT_DEDUCTION((0))

Triggers
Sr.NameDescription
1plShift_InsertUpdate
2Tr_plShift
3Tr_plShift_Deleting
4Tr_plShift_Validating

Indexes
Sr.NameTypeColumns
1PK_plShiftClusteredSHIFT_CODE
2plShift_Index1NonclusteredSHIFT_TYPE
3plShift_Index2NonclusteredAUTHORIZED




Index
Table:[dbo].[plSkillQuali]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2QUALIFICATIONNVARCHAR(200)N
3QUALI_TYPENVARCHAR(200)N
4CREATE_BYCHAR(10)N
5CREATE_DATEDATETIMEN
6LAST_UPDATE_BYCHAR(10)N
7LAST_UPDATE_DATEDATETIMEN

Default Constraints
Sr.NameColumnValue
1DF_plSkillQuali_QUALI_TYPEQUALI_TYPE('')

Triggers
Sr.NameDescription
1Tr_plSkillQuali

Indexes
Sr.NameTypeColumns
1PK_plSkillQualiClusteredID
2plSkillQuali_Index1NonclusteredQUALIFICATION




Index
Table:[dbo].[plTermnReason]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1REASON_CODENVARCHAR(6)N
2TERMN_REASONNVARCHAR(160)Y
3CREATE_BYCHAR(10)N
4CREATE_DATEDATETIMEN
5LAST_UPDATE_BYCHAR(10)Y
6LAST_UPDATE_DATEDATETIMEY

Triggers
Sr.NameDescription
1Tr_plTermnReason
2Tr_plTermnReason_Deleting

Indexes
Sr.NameTypeColumns
1PK_PLTermReasonClusteredREASON_CODE




Index
Table:[dbo].[plTraining]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYINTN
2EE_NONVARCHAR(20)N
3QUALIFICATIONNVARCHAR(200)Y
4START_DATENVARCHAR(40)Y
5END_DATENVARCHAR(40)Y
6COURSE_NAMENVARCHAR(200)Y
7INSTITUTIONNVARCHAR(400)Y
8MEMONVARCHAR(2048)Y
9PATHNVARCHAR(400)Y
10CREDITSINTY
11CREATE_BYCHAR(10)Y
12CREATE_DATEDATETIMEY
13LAST_UPDATE_BYCHAR(10)Y
14LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plTraining_CREDITCREDITS((0))

Triggers
Sr.NameDescription
1Tr_plTraining_Validating

Indexes
Sr.NameTypeColumns
1PK_plTrainingClusteredTS_KEY




Index
Table:[dbo].[plUser]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1USERIDCHAR(10)N
2ALL_EEBITN
3CREATE_BYCHAR(10)N
4CREATE_DATEDATETIMEN
5LAST_UPDATE_BYCHAR(10)Y
6LAST_UPDATE_DATEDATETIMEY

Default Constraints
Sr.NameColumnValue
1DF_plUser_ALL_EEALL_EE((0))

Triggers
Sr.NameDescription
1Tr_plUser

Indexes
Sr.NameTypeColumns
1PK_plUserClusteredUSERID
2plUser_INDEX1NonclusteredALL_EE
3plUser_INDEX2NonclusteredUSERID
ALL_EE




Index
Table:[dbo].[plUserQuery]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2DESCRIPTIONNVARCHAR(160)N
3QUERYNVARCHAR(-1)N
4CREATE_BYVARCHAR(10)N
5CREATE_DATEDATETIMEN
6LAST_UPDATE_BYVARCHAR(10)N
7LAST_UPDATE_DATEDATETIMEN

Indexes
Sr.NameTypeColumns
1PK_plAdhocQueryClusteredID




Index
Table:[dbo].[plUserRight]

Description
Security by Employee Group User Rights Table

Table Columns
Sr.NameDatatypeNullableDescription
1USERIDCHAR(10)N
2EE_NONVARCHAR(20)N

Indexes
Sr.NameTypeColumns
1PK_plUserRightClusteredUSERID
EE_NO
2plUserRight_INDEX1NonclusteredEE_NO




Index
Table:[dbo].[plUserRightDeptCode]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1USERIDCHAR(10)N
2DEPT_CODENVARCHAR(24)N

Indexes
Sr.NameTypeColumns
1PK_plUserRightDeptCodeClusteredUSERID
DEPT_CODE




Index
Table:[dbo].[plUserRightDivisionCode]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1USERIDCHAR(10)N
2DIVISION_CODENVARCHAR(24)N

Indexes
Sr.NameTypeColumns
1PK_plUserRightDivisionCodeClusteredUSERID
DIVISION_CODE




Index
Table:[dbo].[plUserRightEEClass]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1USERIDCHAR(10)N
2EE_CLASSNVARCHAR(24)N

Indexes
Sr.NameTypeColumns
1PK_plUserRightEEClassClusteredUSERID
EE_CLASS




Index
Table:[dbo].[plWorkHrs]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1WORK_HRS_TYPENVARCHAR(20)N
2DESCRIPTIONNVARCHAR(100)Y
3IN_TIMEVARCHAR(5)N
4IN_TIME_BEFORESMALLINTY
5OUT_TIMEVARCHAR(5)N
6SAT_OUT_TIMEVARCHAR(5)Y
7OUT_TIME_AFTERSMALLINTY
8LATE_TOLERANCESMALLINTY
9LT_ONLY_IF_OT_FOR_HRSDECIMAL(18,2)Y
10LATE_TOLERANCE2SMALLINTY
11LT2_ONLY_IF_OT_FOR_HRSDECIMAL(18,2)Y
12EARLY_OUT_TOLERANCESMALLINTY
13INCLUDE_LUNCH_HOURBITN
14PAY_LUNCH_BREAKBITN
15ENABLE_LUNCH_TIMEBITN
16LUNCH_OUT_TIMEVARCHAR(5)Y
17LUNCH_OUT_TOLERANCESMALLINTY
18LUNCH_OUT_SCAN_FROMVARCHAR(5)Y
19LUNCH_OUT_SCAN_TOVARCHAR(5)Y
20LUNCH_IN_TIMEVARCHAR(5)Y
21LUNCH_IN_TOLERANCESMALLINTY
22LUNCH_IN_SCAN_FROMVARCHAR(5)Y
23LUNCH_IN_SCAN_TOVARCHAR(5)Y
24OT_MINIMUM_MINSSMALLINTY
25OT_MINIMUM_MINS_EARLY_OTINTN
26OT_MINIMUM_MINS_AFTERWORK_OTINTN
27OT_MAXIMUM_HRSSMALLINTY
28OT1_MEAL_TIME_DEDUCT_WHEN_WORKED_MORE_THAN_HRSDECIMAL(18,2)Y
29OT_MEAL_TIME_DEDUCT_WHEN_WORKED_MORE_THAN_HRSDECIMAL(18,2)Y
30OT_ALLOW_EARLYTIMEBITN
31OT_TRUNCATETO_QUARTERINTY
32OT_PAY_INCLUDED_MINIMUM_MINSBITN
33WORK_HRSDECIMAL(18,4)Y
34LUNCH_HRSDECIMAL(18,4)Y
35SAT_HRSDECIMAL(18,4)Y
36SATURDAY_OFFINTY
37LATE_DEDUCTIONBITN
38EARLYOUT_DEDUCTIONBITN
39SHORT_DEDUCTIONBITN
40SATURDAYNCHAR(2)Y
41EXCLUDE_EARLIER_THAN_IN_TIMEBITN
42EXCLUDE_LATER_THAN_OUT_TIMEBITN
43OT_HRS_BASE_ON_WORKED_HRSBITN
44LATE_IN_EXCLUDE_LATE_TOLERANCEBITN
45EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCEBITN
46FLEXIBLE_LUNCH_HOURSBITN
47ATTENDANCE_ALLOWANCE_FORMULANVARCHAR(4000)Y
48ATTENDANCE_ALLOWANCE_HRS_OVERDECIMAL(18,2)N
49ATTENDANCE_ALLOWANCE_PAYTYPEINTN
50ATTENDANCE_ALLOWANCE_PAYTYPE_TABLE_DESCNVARCHAR(100)N
51CHECK_IN_CUT_OFF_HOURVARCHAR(5)Y
52CUT_OFF_HOURVARCHAR(5)Y
53NO_LATE_IN_CALCULATIONBITN
54NO_EARLY_OUT_CALCULATIONBITN
55NO_SHORT_CALCULATIONBITN
56NO_LUNCH_LATE_IN_CALCULATIONBITN
57NO_LUNCH_EARLY_OUT_CALCULATIONBITN
58NO_LUNCH_SHORT_CALCULATIONBITN
59INCLUDE_REST_HOURBITN
60PAY_REST_BREAKBITN
61ENABLE_REST_TIMEBITN
62REST_OUT_TIMEVARCHAR(5)Y
63REST_OUT_TOLERANCEINTY
64REST_OUT_SCAN_FROMVARCHAR(5)Y
65REST_OUT_SCAN_TOVARCHAR(5)Y
66REST_IN_TIMEVARCHAR(5)Y
67REST_IN_TOLERANCEINTY
68REST_IN_SCAN_FROMVARCHAR(5)Y
69REST_IN_SCAN_TOVARCHAR(5)Y
70REST_HRSDECIMAL(18,4)Y
71FLEXIBLE_REST_HOURSBITN
72NO_REST_LATE_IN_CALCULATIONBITN
73NO_REST_EARLY_OUT_CALCULATIONBITN
74NO_REST_SHORT_CALCULATIONBITN
75NOT_ABSENTBITN
76LEAVE_PERIOD_START_DAYINTN
77LEAVE_PERIOD_OF_MONTHINTN
78LEAVE_PERIOD_OFFSETINTN
79EXPENSE_PERIOD_START_DAYINTN
80EXPENSE_PERIOD_OF_MONTHINTN
81EXPENSE_PERIOD_OFFSETINTN
82ATTENDANCE_PERIOD_START_DAYINTN
83ATTENDANCE_PERIOD_OF_MONTHINTN
84ATTENDANCE_PERIOD_OFFSETINTN
85SESSION1_HOURLY_RATEINTN
86SESSION2_HOURLY_RATEINTN
87SESSION3_HOURLY_RATEINTN
88CREATE_BYCHAR(10)N
89CREATE_DATEDATETIMEN
90LAST_UPDATE_BYCHAR(10)Y
91LAST_UPDATE_DATEDATETIMEY
92ATTENDANCE_ALLOWANCEDECIMAL(18,2)Yobsoleted

Default Constraints
Sr.NameColumnValue
1DF_plWORKHRS_ATTENDANCE_ALLOWANCE_HRS_OVERATTENDANCE_ALLOWANCE_HRS_OVER((0))
2DF_plWORKHRS_ATTENDANCE_ALLOWANCE_PAYTYPEATTENDANCE_ALLOWANCE_PAYTYPE((0))
3DF_plWORKHRS_ATTENDANCE_ALLOWANCE_PAYTYPE_TABLE_DESCATTENDANCE_ALLOWANCE_PAYTYPE_TABLE_DESC('')
4DF_plWORKHRS_ATTENDANCE_PERIOD_OF_MONTHATTENDANCE_PERIOD_OF_MONTH((0))
5DF_plWORKHRS_ATTENDANCE_PERIOD_OFFSETATTENDANCE_PERIOD_OFFSET((0))
6DF_plWORKHRS_ATTENDANCE_PERIOD_START_DAYATTENDANCE_PERIOD_START_DAY((0))
7DF_plWORKHRS_CHECK_IN_CUT_OFF_HOURCHECK_IN_CUT_OFF_HOUR('')
8DF_plWORKHRS_CUT_OFF_HOURCUT_OFF_HOUR('')
9DF_plWORKHRS_EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCEEARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCE((0))
10DF_plWORKHRS_EARLY_OUT_TOLERANCEEARLY_OUT_TOLERANCE((0))
11DF_plWORKHRS_EARLYOUT_DEDUCTIONEARLYOUT_DEDUCTION((0))
12DF_plWORKHRS_ENABLE_LUNCH_TIMEENABLE_LUNCH_TIME((0))
13DF_plWORKHRS_ENABLE_REST_TIMEENABLE_REST_TIME((0))
14DF_plWORKHRS_EXCLUDE_EARLIER_THAN_IN_TIMEEXCLUDE_EARLIER_THAN_IN_TIME((0))
15DF_plWORKHRS_EXCLUDE_LATER_THAN_OUT_TIMEEXCLUDE_LATER_THAN_OUT_TIME((0))
16DF_plWorkHrs_EXPENSE_PERIOD_OF_MONTHEXPENSE_PERIOD_OF_MONTH((0))
17DF_plWorkHrs_EXPENSE_PERIOD_OFFSETEXPENSE_PERIOD_OFFSET((0))
18DF_plWorkHrs_EXPENSE_PERIOD_START_DAYEXPENSE_PERIOD_START_DAY((0))
19DF_plWORKHRS_FLEXIBLE_LUNCH_HOURSFLEXIBLE_LUNCH_HOURS((0))
20DF_plWORKHRS_FLEXIBLE_REST_HOURSFLEXIBLE_REST_HOURS((0))
21DF_plWORKHRS_IN_TIMEIN_TIME('')
22DF_plWORKHRS_IN_TIME_BEFOREIN_TIME_BEFORE((0))
23DF_plWORKHRS_INCLUDE_LUNCH_HOURINCLUDE_LUNCH_HOUR((0))
24DF_plWORKHRS_INCLUDE_REST_HOURINCLUDE_REST_HOUR((0))
25DF_plWORKHRS_LATE_DEDUCTIONLATE_DEDUCTION((0))
26DF_plWORKHRS_LATE_IN_EXCLUDE_LATE_TOLERANCELATE_IN_EXCLUDE_LATE_TOLERANCE((0))
27DF_plWORKHRS_LATE_TOLERANCELATE_TOLERANCE((0))
28DF_plWORKHRS_LATE_TOLERANCE2LATE_TOLERANCE2((0))
29DF_plWORKHRS_LEAVE_PERIOD_OF_MONTHLEAVE_PERIOD_OF_MONTH((0))
30DF_plWORKHRS_LEAVE_PERIOD_OFFSETLEAVE_PERIOD_OFFSET((0))
31DF_plWORKHRS_LEAVE_PERIOD_START_DAYLEAVE_PERIOD_START_DAY((0))
32DF_plWORKHRS_LT_ONLY_IF_OT_FOR_HRSLT_ONLY_IF_OT_FOR_HRS((0))
33DF_plWORKHRS_LT2_ONLY_IF_OT_FOR_HRSLT2_ONLY_IF_OT_FOR_HRS((0))
34DF_plWORKHRS_LUNCH_IN_SCAN_FROMLUNCH_IN_SCAN_FROM('')
35DF_plWORKHRS_LUNCH_IN_SCAN_TOLUNCH_IN_SCAN_TO('')
36DF_plWORKHRS_LUNCH_IN_TIMELUNCH_IN_TIME('')
37DF_plWORKHRS_LUNCH_IN_TOLERANCELUNCH_IN_TOLERANCE((0))
38DF_plWORKHRS_LUNCH_OUT_SCAN_FROMLUNCH_OUT_SCAN_FROM('')
39DF_plWORKHRS_LUNCH_OUT_SCAN_TOLUNCH_OUT_SCAN_TO('')
40DF_plWORKHRS_LUNCH_OUT_TIMELUNCH_OUT_TIME('')
41DF_plWORKHRS_LUNCH_OUT_TOLERANCELUNCH_OUT_TOLERANCE((0))
42DF_plWORKHRS_NO_EARLY_OUT_CALCULATIONNO_EARLY_OUT_CALCULATION((0))
43DF_plWORKHRS_NO_LATE_IN_CALCULATIONNO_LATE_IN_CALCULATION((0))
44DF_plWORKHRS_NO_LUNCH_EARLY_OUT_CALCULATIONNO_LUNCH_EARLY_OUT_CALCULATION((0))
45DF_plWORKHRS_NO_LUNCH_LATE_IN_CALCULATIONNO_LUNCH_LATE_IN_CALCULATION((0))
46DF_plWORKHRS_NO_LUNCH_SHORT_CALCULATIONNO_LUNCH_SHORT_CALCULATION((0))
47DF_plWORKHRS_NO_REST_EARLY_OUT_CALCULATIONNO_REST_EARLY_OUT_CALCULATION((0))
48DF_plWORKHRS_NO_REST_LATE_IN_CALCULATIONNO_REST_LATE_IN_CALCULATION((0))
49DF_plWORKHRS_NO_REST_SHORT_CALCULATIONNO_REST_SHORT_CALCULATION((0))
50DF_plWORKHRS_NO_SHORT_CALCULATIONNO_SHORT_CALCULATION((0))
51DF_plWORKHRS_NOT_ABSENTNOT_ABSENT((0))
52DF_plWORKHRS_OT_ALLOW_EARLYTIMEOT_ALLOW_EARLYTIME((0))
53DF_plWORKHRS_OT_HRS_BASE_ON_WORKED_HRSOT_HRS_BASE_ON_WORKED_HRS((0))
54DF_plWORKHRS_OT_MINIMUM_MINS_AFTERWORK_OTOT_MINIMUM_MINS_AFTERWORK_OT((0))
55DF_plWORKHRS_OT_MINIMUM_MINS_EARLY_OTOT_MINIMUM_MINS_EARLY_OT((0))
56DF_plWORKHRS_OT_PAY_INCLUDED_MINIMUM_MINSOT_PAY_INCLUDED_MINIMUM_MINS((0))
57DF_plWORKHRS_OUT_TIMEOUT_TIME('')
58DF_plWORKHRS_OUT_TIME_AFTEROUT_TIME_AFTER((0))
59DF_plWORKHRS_PAY_LUNCH_BREAKPAY_LUNCH_BREAK((0))
60DF_plWORKHRS_PAY_REST_BREAKPAY_REST_BREAK((0))
61DF_plWORKHRS_SAT_OUT_TIMESAT_OUT_TIME('')
62DF_plWORKHRS_SESSION1_HOURLY_RATESESSION1_HOURLY_RATE((1))
63DF_plWORKHRS_SESSION2_HOURLY_RATESESSION2_HOURLY_RATE((2))
64DF_plWORKHRS_SESSION3_HOURLY_RATESESSION3_HOURLY_RATE((3))
65DF_plWORKHRS_SHORT_DEDUCTIONSHORT_DEDUCTION((0))

Triggers
Sr.NameDescription
1plWorkHrs_InsertUpdate
2Tr_plWorkHrs_DELETE
3Tr_plWorkHrs_Deleting
4Tr_plWORKHRS_Validating

Indexes
Sr.NameTypeColumns
1PK_plWORKHRSClusteredWORK_HRS_TYPE




Index
Table:[dbo].[plWorkHrs_Sat]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2WORK_HRS_TYPENVARCHAR(20)N
3SATURDAYDATETIMEN
4OFFINTY
5IsOffBITN

Default Constraints
Sr.NameColumnValue
1DF_plWORKHRS_SAT_IsOffIsOff((0))

Indexes
Sr.NameTypeColumns
1PK_plWORKHRS_SATClusteredID
2plWORKHRS_SAT_Index1NonclusteredOFF




Index
Table:[dbo].[RptControl]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RptCodeVARCHAR(10)N
2RptNameNVARCHAR(240)N
3RptTableViewNVARCHAR(80)N
4RptExcelCHAR(1)Y
5RptFontNameVARCHAR(20)Y
6RptFontSizeINTY
7RptOrientationNVARCHAR(20)Y
8RptFitWidthCHAR(1)Y
9RptZoomRatioINTY
10RptPaperSizeINTY
11RptCrystalRptNVARCHAR(40)Y
12RptSystemDateFormatCHAR(1)Y
13RptCopiesINTY
14RptGroupbyVARCHAR(10)Y
15RptTotalListVARCHAR(150)Y
16RptPageBreaksCHAR(3)Y
17RptDescriptionNVARCHAR(-1)Y
18RptCRParaName1NVARCHAR(40)Y
19RptCRParaType1CHAR(3)Y
20RptCRParaName2NVARCHAR(40)Y
21RptCRParaType2CHAR(3)Y
22URLNVARCHAR(400)Y
23LAST_UPDATE_DATEDATETIMEY
24AUTO_UPDATECHAR(1)Y
25RptStoredProcNVARCHAR(80)Y
26RptModuleCHAR(2)Y
27LAST_EXECUTION_DATEDATETIMEY
28IsEmailReportBITN
29EmailReportSubjectNVARCHAR(1000)Y
30EmailReportContentNVARCHAR(-1)Y

Default Constraints
Sr.NameColumnValue
1DF_RptControl_AUTO_UPDATEAUTO_UPDATE('Y')
2DF_RptControl_EmailReportContentEmailReportContent('')
3DF_RptControl_EmailReportSubjectEmailReportSubject('')
4DF_RptControl_IsEmailReportIsEmailReport((0))
5DF_RptControl_RptCopiesRptCopies((1))
6DF_RptControl_RptExcelRptExcel('Y')
7DF_RptControl_RptFitWidthRptFitWidth('Y')
8DF_RptControl_RptFontNameRptFontName('Arial Unicode MS')
9DF_RptControl_RptFontSizeRptFontSize((10))
10DF_RptControl_RptOrientationRptOrientation('Landscape')
11DF_RptControl_RptPageBreaksRptPageBreaks('N')
12DF_RptControl_RptPaperSizeRptPaperSize((9))
13DF_RptControl_RptSystemDateFormatRptSystemDateFormat('Y')
14DF_RptControl_RptZoomRatioRptZoomRatio((100))

Indexes
Sr.NameTypeColumns
1PK_RptControlClusteredRptCode




Index
Table:[dbo].[RptControlColumnSelection]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2CREATE_BYCHAR(10)N
3RptCodeVARCHAR(10)N
4NameNVARCHAR(510)N
5ColumnNameNVARCHAR(256)N
6ViewNameNVARCHAR(256)N
7ReportColumnHeaderNVARCHAR(-1)N
8ColumnTypeVARCHAR(1)N
9ColumnOrderSMALLINTN
10SelectedBITN

Indexes
Sr.NameTypeColumns
1PK_RptControlColumnSelectionClusteredId




Index
Table:[dbo].[RptControlCondition]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2UserIDNCHAR(20)N
3RptCodeNCHAR(20)N
4RptColumnHeaderNVARCHAR(256)N
5OperatorNVARCHAR(40)N
6ValueNVARCHAR(510)Y
7JunctionNVARCHAR(10)Y

Indexes
Sr.NameTypeColumns
1PK_RptControlConditionClusteredId




Index
Table:[dbo].[RptControlOrderBy]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2UserIDNCHAR(20)N
3RptCodeNCHAR(20)Y
4OrderBy1NVARCHAR(256)Y
5AscDesc1NVARCHAR(20)Y
6OrderBy2NVARCHAR(256)Y
7AscDesc2NVARCHAR(20)Y
8Enable_Excel_AutoFilterINTN
9IsSummaryReportINTN
10ShowGridLinesINTN
11OutputToNVARCHAR(100)Y

Default Constraints
Sr.NameColumnValue
1DF_RptControlOrderBy_ShowGridLinesShowGridLines((0))

Indexes
Sr.NameTypeColumns
1PK_RptControlOrderByClusteredId




Index
Table:[dbo].[RptControlSelectionSettings]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2RptCodeVARCHAR(10)N
3CREATE_BYVARCHAR(10)N
4CREATE_DATEDATETIMEY
5NameNVARCHAR(510)N
6SettingsXMLXMLN

Indexes
Sr.NameTypeColumns
1PK_RptControlSelectionSettingsClusteredId




Index
Table:[dbo].[smCONTROL]

Description
System Manager Control Table

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialINTN
2IDINTY
3DESCRIPTIONNVARCHAR(200)N
4VALIDATE_QUERYNVARCHAR(2048)Y
5FIX_QUERYNVARCHAR(2048)Y
6AUTHORIZEDINTN

Indexes
Sr.NameTypeColumns
1PK_smCONTROL_1ClusteredRowSerial




Index
Table:[dbo].[UDFTable]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2UDFIndexINTN
3UDFDescriptionNVARCHAR(100)N

Indexes
Sr.NameTypeColumns
1PK_UDFTableClusteredID




Index
Table:[dbo].[wrkAnnualLeaveForfeiture]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1CREATE_BYCHAR(10)N
2EE_NONVARCHAR(20)N
3BADGE_NONVARCHAR(40)Y
4SUR_NAMENVARCHAR(40)Y
5OTHERNAMENVARCHAR(110)Y
6CALL_NAMENVARCHAR(60)Y
7CHI_NAMENVARCHAR(20)Y
8POSITIONNVARCHAR(200)Y
9DEPT_CODENVARCHAR(24)Y
10DIVISION_CODENVARCHAR(24)Y
11ENTITLEMENT_CODENVARCHAR(24)Y
12JOIN_DATEDATETIMEY
13ENTITLEMENT_DATEDATETIMEY
14YEAR_OF_ENTITLEMENTINTY
15ENTITLE_BALANCEDECIMAL(18,4)Y
16ACTUAL_BALANCEDECIMAL(18,4)Y
17BALANCE_BROUGHT_FORWARDDECIMAL(18,4)Y
18BALANCE_BROUGHT_FORWARD_REMAININGDECIMAL(18,4)Y
19RETAIN_DAYSDECIMAL(18,4)Y
20FORFEITED_DAYSDECIMAL(18,4)Y
21SELECTEDBITY
22EE_NAMENVARCHAR(150)Y

Indexes
Sr.NameTypeColumns
1PK_wrkAnnualLeaveForfeitureClusteredCREATE_BY
EE_NO




Index
Table:[dbo].[wrkColumnSelection]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1CREATE_BYCHAR(10)N
2RptCodeVARCHAR(10)N
3ColumnNameNVARCHAR(256)N
4ViewNameNVARCHAR(256)N
5ReportColumnHeaderNVARCHAR(-1)N
6ColumnTypeVARCHAR(1)N
7ColumnOrderSMALLINTN
8SelectedBITN

Indexes
Sr.NameTypeColumns
1PK_wrkColumnSelection_1ClusteredCREATE_BY
RptCode
ColumnName




Index
Table:[dbo].[wrkEPMenuByUserID]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2USER_IDNVARCHAR(20)N
3LINE_NOINTN
4LEVELINTY
5DESCRIPTIONNVARCHAR(1000)Y
6DESCRIPTION_TCNVARCHAR(1000)Y
7DESCRIPTION_SCNVARCHAR(1000)Y
8HREFNVARCHAR(160)Y

Indexes
Sr.NameTypeColumns
1PK_wrkEPMenuByUserIDClusteredID
2wrkEPMenuByUserID_INDEX1NonclusteredUSER_ID
LINE_NO




Index
Table:[dbo].[wrkExcelColumns]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2FUNCTION_IDNCHAR(20)N
3CREATE_BYCHAR(10)N
4CREATE_DATEDATETIMEN
5EXCEL_FILE_NAMENVARCHAR(510)N
6SHEET_NOINTN
7COLUMN_NOINTN
8COLUMN_NAMENVARCHAR(510)N

Indexes
Sr.NameTypeColumns
1PK_wcWrkExcelColumnsClusteredId




Index
Table:[dbo].[wrkExcelSheetNo]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2FUNCTION_IDNCHAR(20)N
3CREATE_BYCHAR(10)N
4CREATE_DATEDATETIMEN
5EXCEL_FILE_NAMENVARCHAR(510)N
6SHEET_NOINTN
7SHEET_NAMENVARCHAR(510)N

Indexes
Sr.NameTypeColumns
1PK_wcWrkExcelSheetNoClusteredId




Index
Table:[dbo].[wrkFileUpload]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2FileNameNVARCHAR(510)N
3DataVARBINARYY

Indexes
Sr.NameTypeColumns
1PK_WrkFileUploadClusteredId




Index
Table:[dbo].[wrkHRProMenuByUserID]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2USER_IDNVARCHAR(20)N
3LINE_NOINTN
4MENU_LEVELINTN
5FUNCTION_NAMENVARCHAR(240)N
6FUNCTION_NAME_TCNVARCHAR(240)N
7FUNCTION_NAME_SCNVARCHAR(240)N
8FUNCTION_ACTIONNVARCHAR(240)N
9FUNCTION_IDNVARCHAR(20)N
10FUNCTION_TYPENCHAR(2)N
11MODULECHAR(2)N
12IS_WEBCLIENT_VISIBLEBITN
13IS_DESKTOP_VISIBLEBITN
14AUTO_UPDATECHAR(1)N
15IS_PARENTBITN
16PARENT_LINE_NOINTN

Indexes
Sr.NameTypeColumns
1PK_wrkHRProMenuByUserIDClusteredID
2wrkHRProMenuByUserID_INDEX1NonclusteredUSER_ID
FUNCTION_ID
3wrkHRProMenuByUserID_INDEX2NonclusteredUSER_ID
4wrkHRProMenuByUserID_INDEX3NonclusteredUSER_ID
MODULE




Index
Table:[dbo].[wrkHRProReminderByUserID]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2USER_IDNVARCHAR(20)N
3REMINDER_NOINTN
4DESCRIPTIONNVARCHAR(4000)N
5DESCRIPTION_TCNVARCHAR(4000)N
6DESCRIPTION_SCNVARCHAR(4000)N
7DETAIL_LINENVARCHAR(4000)N
8DETAIL_LINE_TCNVARCHAR(4000)N
9DETAIL_LINE_SCNVARCHAR(4000)N
10DETAIL_HTMLNVARCHAR(4000)N
11DETAIL_HTML_TCNVARCHAR(4000)N
12DETAIL_HTML_SCNVARCHAR(4000)N
13READBITN

Default Constraints
Sr.NameColumnValue
1DF_wrkHRProReminderByUserID_READREAD((0))

Indexes
Sr.NameTypeColumns
1PK_wrkHRProReminderByUserIDClusteredID
2wrkHRProReminderByUserID_Index1NonclusteredUSER_ID




Index
Table:[dbo].[wrkIR56FG]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3EE_NONVARCHAR(20)N
4SELECTEDBITN
5EE_NAMENVARCHAR(150)Y
6POSITIONNVARCHAR(200)Y
7DEPT_CODENVARCHAR(24)Y
8DIVISION_CODENVARCHAR(24)Y
9EE_CLASSNVARCHAR(24)Y
10TERMN_DATEDATEY
11LAST_PAYROLL_PERIODNCHAR(14)Y

Indexes
Sr.NameTypeColumns
1PK_wrkIR56FClusteredID




Index
Table:[dbo].[wrkLeaveEntryByGroup]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3EE_NONVARCHAR(20)N
4SELECTEDBITN
5EE_NAMENVARCHAR(150)Y
6POSITIONNVARCHAR(200)Y
7DEPT_CODENVARCHAR(24)Y
8EE_CLASSNVARCHAR(24)Y
9Entitlement_CodeNVARCHAR(24)Y

Indexes
Sr.NameTypeColumns
1PK_wrkLeaveEntryByGroupClusteredID




Index
Table:[dbo].[wrkManageEmployeeByGroup]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USER_IDVARCHAR(10)Y
4EE_NONVARCHAR(20)N
5EE_NAMENVARCHAR(200)Y
6DEPT_CODENVARCHAR(24)Y
7POSITIONNVARCHAR(200)Y
8EE_CLASSNVARCHAR(24)Y
9AUTHORIZEDBITY
10SELECTEDBITY

Indexes
Sr.NameTypeColumns
1PK_wrkManageEmployeeByGroupClusteredID




Index
Table:[dbo].[wrkManageEmployeeByGroupDeptCode]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USER_IDVARCHAR(10)Y
4DEPT_CODENVARCHAR(24)Y
5DEPT_NAMENVARCHAR(120)Y
6SELECTEDBITY

Indexes
Sr.NameTypeColumns
1PK_wrkManageEmployeeByGroupDeptCodeClusteredID




Index
Table:[dbo].[wrkManageEmployeeByGroupDivisionCode]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USER_IDVARCHAR(10)Y
4DIVISION_CODENVARCHAR(24)Y
5DIVISION_NAMENVARCHAR(120)Y
6SELECTEDBITY

Indexes
Sr.NameTypeColumns
1PK_wrkManageEmployeeByGroupDivisionCodeClusteredID




Index
Table:[dbo].[wrkManageEmployeeByGroupEEClass]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USER_IDVARCHAR(10)Y
4EE_CLASSNVARCHAR(24)Y
5EE_CLASS_NAMENVARCHAR(120)Y
6SELECTEDBITY

Indexes
Sr.NameTypeColumns
1PK_wrkManageEmployeeByGroupEEClassClusteredID




Index
Table:[dbo].[wrkOutputToEmail]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2CREATE_BYCHAR(10)N
3CREATE_DATEDATETIMEY
4RptCodeNVARCHAR(510)N
5EE_NONVARCHAR(20)N
6EE_NAMENVARCHAR(200)Y
7EMAILNVARCHAR(510)Y
8PERIODNVARCHAR(510)Y
9DataVARBINARYY
10PDFDataVARBINARYY
11ZipDataVARBINARYY
12ErrorMessageNVARCHAR(8000)Y
13ReturnTextNVARCHAR(510)Y

Indexes
Sr.NameTypeColumns
1PK_wcWrkOutputToEmailClusteredId




Index
Table:[dbo].[wrkPayTypeSetup]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2USERIDVARCHAR(12)N
3LINEINTN
4PAY_KEYVARCHAR(18)N
5PAY_TYPE_NOINTN
6PAY_TYPENVARCHAR(100)N
7IS_TABLEBITN
8IS_EDITABLEBITN
9VISIBLEBITN
10FULL_PAY_WAGEBITN
11TAXABLEBITN
12MPF_CONTRIBUTEBITN
13WAGES_PAYABLE_SMWBITN
14IRD_CATVARCHAR(2)N
15IRD_CAT_DESCRIPTIONNVARCHAR(510)N
16IRD_CATMVARCHAR(2)N
17IRD_CATM_DESCRIPTIONNVARCHAR(510)N

Default Constraints
Sr.NameColumnValue
1DF_wrkPayTypeSetup_IRD_CATMIRD_CATM('')
2DF_wrkPayTypeSetup_IRD_CATM_DESCRIPTIONIRD_CATM_DESCRIPTION('')
3DF_wrkPayTypeSetup_IS_EDITABLEIS_EDITABLE((0))

Indexes
Sr.NameTypeColumns
1PK_wrkPayTypeSetupClusteredID
2wrkPayTypeSetup_Index1NonclusteredUSERID
LINE




Index
Table:[dbo].[wrkRptControlColumnValue]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IdINTN
2UserIDNCHAR(20)N
3RptCodeNCHAR(20)N
4RptColumnHeaderNVARCHAR(256)N
5RptColumnNameNVARCHAR(256)N
6RptColumnValueNVARCHAR(2048)N

Indexes
Sr.NameTypeColumns
1PK_wrkRptControlColumnValueClusteredId




Index
Table:[dbo].[wrkSMControl]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialINTN
2IDINTN
3DESCRIPTIONNVARCHAR(200)N
4VALIDATE_QUERYNVARCHAR(2048)Y
5FIX_QUERYNVARCHAR(2048)Y
6CREATE_BYCHAR(10)N
7SELECTEDBITY

Default Constraints
Sr.NameColumnValue
1DF_wrkSMControl_IDID((0))

Indexes
Sr.NameTypeColumns
1PK_wrkSMControlClusteredRowSerial




Index
Table:[dbo].[wrkSubordinates]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2EE_NONVARCHAR(20)Y
3SEQINTY
4SUBORDINATE_NONVARCHAR(20)Y
5DEPT_CODENVARCHAR(24)Y
6DIVISION_CODENVARCHAR(24)Y

Default Constraints
Sr.NameColumnValue
1DF_wrkSubordinates_DIVISION_CODEDIVISION_CODE('')

Indexes
Sr.NameTypeColumns
1PK_wrkSubordinatesClusteredID
2wrkSubordinates_INDEX1NonclusteredEE_NO




Index
Table:[dbo].[wrkUserCompany]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USERIDCHAR(10)N
4IS_GROUPBITN
5COMPANY_CODECHAR(10)N
6COMPANY_NAMENVARCHAR(200)N
7SELECTEDBITN

Indexes
Sr.NameTypeColumns
1PK_wrkUserCompanyClusteredID




Index
Table:[dbo].[wrkUserGroup]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USERIDCHAR(10)N
4GROUPIDCHAR(10)N
5SELECTEDBITN

Indexes
Sr.NameTypeColumns
1PK_wrkUserGroupClusteredID




Index
Table:[dbo].[wrkUserRight]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3USERIDCHAR(10)N
4FUNCTION_IDCHAR(10)N
5MODULENVARCHAR(100)N
6MODULE_ORDERINTN
7FUNCTION_NAMENVARCHAR(240)N
8FUNCTION_TYPENVARCHAR(100)N
9FUNCTION_TYPE_ORDERINTN
10IS_GROUPBITY
11SELECTEDBITN

Indexes
Sr.NameTypeColumns
1PK_wrkUserRightClusteredID




Index
Table:[dbo].[wrkWriteEmployeeLetter]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1IDINTN
2CREATE_BYCHAR(10)N
3EE_NONVARCHAR(20)N
4SELECTEDBITN
5EE_NAMENVARCHAR(150)Y
6POSITIONNVARCHAR(200)Y
7DEPT_CODENVARCHAR(24)Y
8EE_CLASSNVARCHAR(24)Y
9EMAILNVARCHAR(100)Y

Indexes
Sr.NameTypeColumns
1PK_wrkWriteEmployeeLetterClusteredID