Support‎ > ‎

HRPro Data Dictionary

HRPro Data Dictionary
Index
SrObjectType
1[dbo].[Attachment]Table
2[dbo].[BAJOBS]Table
3[dbo].[CUSTOM]Table
4[dbo].[Dictionary]Table
5[dbo].[EventLog]Table
6[dbo].[GBANTL]Table
7[dbo].[GBBANK]Table
8[dbo].[GBCOMP]Table
9[dbo].[GBDCNO]Table
10[dbo].[GBLOCN]Table
11[dbo].[GBPARM]Table
12[dbo].[GBQKTX]Table
13[dbo].[NoticeBoard]Table
14[dbo].[PeriodTable]Table
15[dbo].[plATTD]Table
16[dbo].[plATTLog]Table
17[dbo].[plATTPeriod]Table
18[dbo].[PLCSCR]Table
19[dbo].[plDate]Table
20[dbo].[plDeduction]Table
21[dbo].[plDept]Table
22[dbo].[plEECLASS]Table
23[dbo].[plEECostCentre]Table
24[dbo].[plEEUpdate]Table
25[dbo].[plEmployee]Table
26[dbo].[plEmploymentHistory]Table
27[dbo].[plHoliday]Table
28[dbo].[plIR56B]Table
29[dbo].[plIR56BBatch]Table
30[dbo].[plIR56F]Table
31[dbo].[plIR56G]Table
32[dbo].[plLeave]Table
33[dbo].[plLeaveAdjustment]Table
34[dbo].[plLeaveApply]Table
35[dbo].[plLeaveDayRecord]Table
36[dbo].[plLeaveEntitlement]Table
37[dbo].[plLeaveNature]Table
38[dbo].[plLeavePeriod]Table
39[dbo].[plLeaveType]Table
40[dbo].[plMPFSP]Table
41[dbo].[plOT]Table
42[dbo].[plPayroll]Table
43[dbo].[plPayrollBatch]Table
44[dbo].[plPayType]Table
45[dbo].[plPeriod]Table
46[dbo].[plPosition]Table
47[dbo].[plPrePaidPayroll]Table
48[dbo].[plPrepaidPayrollBatch]Table
49[dbo].[plPromotion]Table
50[dbo].[plReminder]Table
51[dbo].[plRoster]Table
52[dbo].[plRosterD]Table
53[dbo].[plSETUP]Table
54[dbo].[plShift]Table
55[dbo].[plTermnReason]Table
56[dbo].[plTraining]Table
57[dbo].[plUser]Table
58[dbo].[plUserRight]Table
59[dbo].[plWORKHRS]Table
60[dbo].[RptControl]Table
61[dbo].[smCONTROL]Table




Index
Table:[dbo].[Attachment]

Description
Attachment Table

Table Columns
Sr.NameDatatypeNullableDescription
1AttachmentIDNUMERICNAttachment ID
2ScreenNVARCHAR(40)YScreen ID
3KeyNoNCHAR(24)NKey
4PathNVARCHAR(400)NPath
5DescriptionNVARCHAR(510)YDescription
6Create_byCHAR(12)NCreated By
7Create_DateDATETIMENCreation Date

Indexes
Sr.NameTypeColumns
1PK_AttachmentClusteredAttachmentID




Index
Table:[dbo].[BAJOBS]

Description
Business Alerts Job Table

Table Columns
Sr.NameDatatypeNullableDescription
1job_noDECIMAL(18,0)N
2nameNVARCHAR(256)N
3enabledTINYINTN
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_statusNCHAR(80)Y
15notify_emailINTY
16emailNVARCHAR(512)Y
17ccNVARCHAR(512)Y
18SubjectNVARCHAR(512)Y
19MessageNVARCHAR(1024)Y
20PriorityINTY
21notify_faxINTY
22faxNVARCHAR(100)Y
23database_nameSYSNAMEN
24commandNVARCHAR(8000)Y
25additional_parametersNTEXTY
26CREATE_BYNCHAR(20)Y
27CREATE_DATEUDT_DATESTAMPY
28LAST_UPDATE_BYNCHAR(20)Y
29LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_BAJOBSClusteredjob_no




Index
Table:[dbo].[CUSTOM]

Description
Customization Table

Table Columns
Sr.NameDatatypeNullableDescription
1ACTIVEINTY
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-TW')

Indexes
Sr.NameTypeColumns
1IX_DictionaryNonclusteredLANGUAGE
2PK_Dictionary_1ClusteredLANGUAGE
ENGLISH




Index
Table:[dbo].[EventLog]

Description
Event Log Table

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EventTypeCHAR(1)Y
3EventDateDATETIMEN
4EventTimeDATETIMEN
5ComputerNameNVARCHAR(100)N
6UserIDCHAR(10)N
7SourceNVARCHAR(40)Y
8CategoryNVARCHAR(40)Y
9EventNVARCHAR(8000)N

Indexes
Sr.NameTypeColumns
1_dta_index_EventLog_7_1950734102__K4DNonclusteredEventTime
2EVENTLOG_INDEX1NonclusteredComputerName
3PK_EventLogClusteredRowSerial




Index
Table:[dbo].[GBANTL]

Description
Chart of Account Analysis Codes Table

Table Columns
Sr.NameDatatypeNullableDescription
1CATEGORY_CODEUDT_CATEGORYN
2DESCRIPTIONNVARCHAR(100)N
3SHORT_DESCCHAR(10)N
4CREATE_BYUDT_USERIDN
5CREATE_DATEUDT_DATESTAMPN
6LAST_UPDATE_BYUDT_USERIDY
7LAST_UPDATE_DATEUDT_DATESTAMPY

Check Constraints
Sr.NameColumnDefinition
1CK__GBANTL__SHORT_DE__1B172222SHORT_DESC([SHORT_DESC]<>' ')

Indexes
Sr.NameTypeColumns
1PK_GBANTLClusteredCATEGORY_CODE




Index
Table:[dbo].[GBBANK]

Description
Bank Table

Table Columns
Sr.NameDatatypeNullableDescription
1BANK_CODECHAR(5)N
2BANK_NAMENVARCHAR(120)N
3ALTERNATE_NAMENVARCHAR(120)Y
4CREATE_BYUDT_USERIDY
5CREATE_DATEUDT_DATESTAMPY
6LAST_UPDATE_BYUDT_USERIDY
7LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_GBBANKClusteredBANK_CODE




Index
Table:[dbo].[GBCOMP]

Description
Company Table

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2LOGOIMAGEY
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].[GBDCNO]

Description
Document Number Table

Table Columns
Sr.NameDatatypeNullableDescription
1DOC_TYPEUDT_DOC_TYPEN
2NO_SETUDT_NO_SETN
3DESCRIPTIONNVARCHAR(100)N
4NO_PREFIXVARCHAR(50)N
5NEXT_NOINTN
6ALLOW_UPDATESMALLINTY
7CREATE_BYUDT_USERIDY
8CREATE_DATEUDT_DATESTAMPY
9LAST_UPDATE_BYUDT_USERIDY
10LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_GBDCNOClusteredDOC_TYPE
NO_SET




Index
Table:[dbo].[GBLOCN]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1LOCATIONNCHAR(20)N
2LOCATION_NAMENVARCHAR(120)N
3LOCATION_ADDRESSNVARCHAR(510)N
4AREANVARCHAR(40)N
5PHONENVARCHAR(40)N
6FAXNVARCHAR(40)N
7EMAILNVARCHAR(120)N
8CONTACT_PERSONNVARCHAR(60)N
9CREATE_BYUDT_USERIDN
10CREATE_DATEUDT_DATESTAMPN
11LAST_UPDATE_BYUDT_USERIDN
12LAST_UPDATE_DATEUDT_DATESTAMPN

Indexes
Sr.NameTypeColumns
1PK_GBLOCNClusteredLOCATION




Index
Table:[dbo].[GBPARM]

Description
Database Parameters Table

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2ENGLISH_NAMECHAR(50)Y
3ALTERNATE_NAMENVARCHAR(100)Y
4ENGLISH_ADDRESSUDT_TEXTY
5ALTERNATE_ADDRESSUDT_TEXTY
6TEL_NOCHAR(20)Y
7FAX_NOCHAR(20)Y
8E_MAILVARCHAR(40)Y
9CREATE_BYUDT_USERIDY
10CREATE_DATEUDT_DATEN
11LAST_UPDATE_BYUDT_USERIDY
12LAST_UPDATE_DATEUDT_DATEN
13LAST_UPDATE_BY_PMUDT_USERIDY
14LAST_UPDATE_DATE_PMUDT_DATESTAMPY
15LAST_UPDATE_BY_TMUDT_USERIDY
16LAST_UPDATE_DATE_TMUDT_DATESTAMPY
17LAST_UPDATE_BY_AMUDT_USERIDY
18LAST_UPDATE_DATE_AMUDT_DATESTAMPY
19LAST_UPDATE_BY_LMUDT_USERIDY
20LAST_UPDATE_DATE_LMUDT_DATESTAMPY
21LAST_UPDATE_BY_UFUDT_USERIDY
22LAST_UPDATE_DATE_UFUDT_DATESTAMPY
23LAST_UPDATE_BY_RSUDT_USERIDY
24LAST_UPDATE_DATE_RSUDT_DATESTAMPY
25LAST_UPDATE_BY_EPUDT_USERIDY
26LAST_UPDATE_DATE_EPUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_GBPARMClusteredCOMPANY_CODE




Index
Table:[dbo].[GBQKTX]

Description
Quick Text Table

Table Columns
Sr.NameDatatypeNullableDescription
1QT_KEYINTN
2QT_TEXTUDT_MEMON
3CREATE_BYUDT_USERIDY
4CREATE_DATEUDT_DATESTAMPY
5LAST_UPDATE_BYUDT_USERIDY
6LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_GBQKTXClusteredQT_KEY




Index
Table:[dbo].[NoticeBoard]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1NB_IDNUMERICN
2NB_DATEDATETIMEN
3NB_SUBJECTNVARCHAR(510)N
4NB_BODYNTEXTN
5LAST_UPDATE_BYCHAR(12)N
6LAST_UPDATE_DATEDATETIMEN
7Create_byCHAR(12)N
8Create_DateDATETIMEN

Indexes
Sr.NameTypeColumns
1PK_NoticeBoardClusteredNB_ID




Index
Table:[dbo].[PeriodTable]

Description
Period Conversion Table

Table Columns
Sr.NameDatatypeNullableDescription
1PeriodCHAR(7)N
2PeriodNbrINTY
3YearINTY
4MonthINTY
5MonthEndingDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_PeriodTableClusteredPeriod




Index
Table:[dbo].[plATTD]

Description
Attendance Record Details

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2PERIODCHAR(7)N
3WORK_DATESMALLDATETIMEN
4POSTEDBITY
5DEVICEVARCHAR(20)Y
6IN_TIME1NCHAR(10)Y
7OUT_TIME1NCHAR(10)Y
8IN_TIME2NCHAR(10)Y
9OUT_TIME2NCHAR(10)Y
10CARD_IN_TIME1NCHAR(10)Y
11CARD_OUT_TIME1NCHAR(10)Y
12CARD_IN_TIME2NCHAR(10)Y
13CARD_OUT_TIME2NCHAR(10)Y
14WORK_HRSDECIMAL(18,2)Y
15REGULAR_HRSDECIMAL(18,2)Y
16OT_HRSDECIMAL(18,2)Y
17OT_HRS2DECIMAL(18,2)Y
18OT_DAYSINTY
19OT_DAYS2INTY
20SHORTDECIMAL(18,2)Y
21LATE_INDECIMAL(18,2)Y
22LUNCH_EARLY_OUTDECIMAL(18,2)Y
23LUNCH_LATE_INDECIMAL(18,2)Y
24EARLY_OUTDECIMAL(18,2)Y
25SHIFT_CODENCHAR(20)Y
26REMARKSNVARCHAR(510)Y
27IS_ABSENTSMALLINTY
28CREATE_BYCHAR(10)Y
29CREATE_DATEDATETIMEY
30LAST_UPDATE_BYCHAR(10)Y
31LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1IX_plATTDNonclusteredEE_NO
PERIOD
2PK_plATTDClusteredEE_NO
WORK_DATE
3plATTD_INDEX1NonclusteredPERIOD
4plATTD_INDEX10NonclusteredLATE_IN
5plATTD_INDEX11NonclusteredEARLY_OUT
6plATTD_INDEX12NonclusteredOT_HRS2
7plATTD_INDEX2NonclusteredPERIOD
IN_TIME1
8plATTD_INDEX3NonclusteredIN_TIME1
9plATTD_INDEX4NonclusteredWORK_DATE
10plATTD_INDEX5NonclusteredOUT_TIME1
11plATTD_INDEX6NonclusteredIN_TIME2
12plATTD_INDEX7NonclusteredOUT_TIME2
13plATTD_INDEX8NonclusteredOT_HRS
14plATTD_INDEX9NonclusteredSHORT




Index
Table:[dbo].[plATTLog]

Description
Attendance Raw Data Table

Table Columns
Sr.NameDatatypeNullableDescription
1TerminalSMALLINTY
2DeviceVARCHAR(20)Y
3EnrollNoINTY
4EE_NONVARCHAR(20)N
5chkYearSMALLINTN
6chkMonthSMALLINTN
7chkDaySMALLINTN
8chkHourSMALLINTN
9chkMinuteSMALLINTN
10chkSecondSMALLINTY
11VerifyModeSMALLINTY
12InOutModeSMALLINTN
13WorkCodeSMALLINTY
14RemarksNVARCHAR(510)Y
15POSTEDBITY
16CREATE_BYCHAR(10)Y
17CREATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plATTLogClusteredEE_NO
chkYear
chkMonth
chkDay
chkHour
chkMinute
InOutMode




Index
Table:[dbo].[plATTPeriod]

Description
Attendance Period Table

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMSMALLDATETIMEY
3PERIOD_TOSMALLDATETIMEY
4CREATE_BYUDT_USERIDN
5CREATE_DATEUDT_DATESTAMPN
6LAST_UPDATE_BYUDT_USERIDY
7LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plATTPeriodClusteredPERIOD
2plATTPeriod_INDEX1NonclusteredPERIOD_FROM
3plATTPeriod_INDEX2NonclusteredPERIOD_TO




Index
Table:[dbo].[PLCSCR]

Description
Payroll Cost Centre

Table Columns
Sr.NameDatatypeNullableDescription
1COST_CENTRENCHAR(60)N
2AUTHORIZEDBITY
3DESCRIPTIONNVARCHAR(120)N
4REMARKSNVARCHAR(510)Y
5AUTOPAY_BANK_ACCOUNTCHAR(10)Y
6CHEQUE_BANK_ACCOUNTCHAR(10)Y
7SALARY_ACCOUNTCHAR(10)Y
8OT_ACCOUNTCHAR(10)Y
9ALLOWANCE_ACCOUNTCHAR(10)Y
10DOUBLE_PAY_ACCOUNTCHAR(10)Y
11BONUS_ACCOUNTCHAR(10)Y
12NOPAY_ACCOUNTCHAR(10)Y
13WAGES_IN_LIEU_ACCOUNTCHAR(10)Y
14PAY_TYPE1_ACCOUNTCHAR(10)Y
15PAY_TYPE2_ACCOUNTCHAR(10)Y
16PAY_TYPE3_ACCOUNTCHAR(10)Y
17PAY_TYPE4_ACCOUNTCHAR(10)Y
18PAY_TYPE5_ACCOUNTCHAR(10)Y
19PAY_TYPE6_ACCOUNTCHAR(10)Y
20PAY_TYPE7_ACCOUNTCHAR(10)Y
21PAY_TYPE8_ACCOUNTCHAR(10)Y
22PAY_TYPE9_ACCOUNTCHAR(10)Y
23EEC_ACCOUNTCHAR(10)Y
24ERC_ACCOUNTCHAR(10)Y
25CREATE_BYUDT_USERIDN
26CREATE_DATEUDT_DATESTAMPN
27LAST_UPDATE_BYUDT_USERIDY
28LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_PLCSCRClusteredCOST_CENTRE




Index
Table:[dbo].[plDate]

Description
Date Sequence Table

Table Columns
Sr.NameDatatypeNullableDescription
1HR_DateSMALLDATETIMEN

Indexes
Sr.NameTypeColumns
1PK_plDateClusteredHR_Date




Index
Table:[dbo].[plDeduction]

Description
Deduction Rate Table

Table Columns
Sr.NameDatatypeNullableDescription
1DEDUCTION_TYPENVARCHAR(4)N
2DESCRIPTIONNVARCHAR(100)Y
3BASE_ONVARCHAR(20)N
4FACTORDECIMAL(18,10)Y
5FIXED_AMOUNTDECIMAL(18,2)Y
6TOLERANCESMALLINTY
7CREATE_BYUDT_USERIDN
8CREATE_DATEUDT_DATESTAMPN
9LAST_UPDATE_BYUDT_USERIDY
10LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plDeductionClusteredDEDUCTION_TYPE




Index
Table:[dbo].[plDept]

Description
Department Table

Table Columns
Sr.NameDatatypeNullableDescription
1DEPT_CODENVARCHAR(24)N
2AUTHORIZEDBITY
3DEPT_NAMENVARCHAR(120)Y
4MANAGERNVARCHAR(20)Y
5EXPECTED_EMPLOYEESINTY
6NOTESNVARCHAR(-1)Y
7CREATE_BYUDT_USERIDN
8CREATE_DATEUDT_DATESTAMPN
9LAST_UPDATE_BYUDT_USERIDY
10LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plDEPTClusteredDEPT_CODE




Index
Table:[dbo].[plEECLASS]

Description
Employee Class Table

Table Columns
Sr.NameDatatypeNullableDescription
1EE_CLASSNVARCHAR(24)N
2EE_CLASS_NAMENVARCHAR(120)Y
3SALARY_BYNCHAR(20)Y
4OT_TYPENVARCHAR(4)Y
5OT_TYPE2NVARCHAR(4)Y
6OT_TYPE3NVARCHAR(4)Y
7OT_TYPE4NVARCHAR(4)Y
8OT_TYPE5NVARCHAR(4)Y
9DEDUCTION_TYPENVARCHAR(4)Y
10SICK_RATESMALLINTY
11SICK_RATE2SMALLINTY
12MATERNITYLEAVE_RATESMALLINTY
13WORK_HRS_TYPENVARCHAR(10)Y
14ROSTER_CODENCHAR(20)Y
15COST_CENTRENVARCHAR(60)Y
16ENTITLEMENT_CODENVARCHAR(6)Y
17INS_PLANNCHAR(6)Y
18INS_GRADENCHAR(6)Y
19HOLIDAY_TYPEVARCHAR(3)Y
20MPF_SP_CODENCHAR(20)Y
21PFUND_TYPENVARCHAR(20)Y
22PFUND_EEDECIMAL(18,9)Y
23PFUND_ERDECIMAL(18,9)Y
24Voluntary_EEDECIMAL(18,9)Y
25Voluntary_ERDECIMAL(18,9)Y
26EEVC_SIGNCHAR(1)Y
27ERVC_SIGNCHAR(1)Y
28PF_PLAN_NONCHAR(40)Y
29PF_BENEFIT_PLAN_NONCHAR(12)Y
30PF_CERT_NONCHAR(40)Y
31USER01NVARCHAR(12)Y
32USER02NVARCHAR(24)Y
33USER03NVARCHAR(40)Y
34USER04NVARCHAR(60)Y
35USER05NVARCHAR(100)Y
36USER06NUMERICY
37USER07NUMERICY
38USER08NUMERICY
39USER09NUMERICY
40USER10NUMERICY
41USER11DATETIMEY
42USER12DATETIMEY
43USER13DATETIMEY
44USER14DATETIMEY
45USER15DATETIMEY
46USER16BITY
47USER17BITY
48USER18BITY
49USER19BITY
50USER20BITY
51PRORATED_BYNCHAR(2)Y
52SATURDAYNCHAR(2)Y
53CREATE_BYUDT_USERIDN
54CREATE_DATEUDT_DATESTAMPN
55LAST_UPDATE_BYUDT_USERIDY
56LAST_UPDATE_DATEUDT_DATESTAMPY

Default Constraints
Sr.NameColumnValue
1DF_plEECLASS_HOLIDAY_TYPEHOLIDAY_TYPE('P')

Indexes
Sr.NameTypeColumns
1PK_plEECLASSClusteredEE_CLASS




Index
Table:[dbo].[plEECostCentre]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYTIMESTAMPN
2EE_NONCHAR(20)N
3START_DATESMALLDATETIMEN
4COST_CENTRENCHAR(60)N
5PERCENTAGEDECIMAL(18,2)N

Indexes
Sr.NameTypeColumns
1PK_plEECostCentreClusteredTS_KEY




Index
Table:[dbo].[plEEUpdate]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2POSTEDBITN
3EE_NONVARCHAR(20)N
4MARITALSMALLINTY
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
20OLD_MARITALSMALLINTY
21OLD_RES_ADDRESSNVARCHAR(180)Y
22OLD_AREA_CODENVARCHAR(2)Y
23OLD_COR_ADDRESSNVARCHAR(180)Y
24OLD_HOME_PHONENVARCHAR(60)Y
25OLD_MOBILENVARCHAR(60)Y
26OLD_PERSONAL_EMAILVARCHAR(50)Y
27OLD_SP_SNAMENVARCHAR(40)Y
28OLD_SP_ONAMENVARCHAR(40)Y
29OLD_SP_HKIDNCHAR(22)Y
30OLD_SP_PASSPTNVARCHAR(80)Y
31OLD_EMERGENCY_CONTACT_NAMENVARCHAR(100)Y
32OLD_EMERGENCY_CONTACT_RELATIONNVARCHAR(60)Y
33OLD_EMERGENCY_CONTACT_PHONENVARCHAR(60)Y
34OLD_EMERGENCY_CONTACT_MOBILENVARCHAR(60)Y
35OLD_IRD_TAX_FILE_NONVARCHAR(26)Y
36CREATE_BYNVARCHAR(20)N
37CREATE_DATESMALLDATETIMEN
38APPROVED_STSNVARCHAR(16)Y
39ACTION_BYNVARCHAR(20)Y
40ACTION_DATESMALLDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plEEUpdateClusteredRowSerial




Index
Table:[dbo].[plEmployee]

Description
Employee Table

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)NEmployee No.
2DEPT_CODENVARCHAR(24)YDepartment Code
3BIRTHDATESMALLDATETIMEYDate of Birth
4PAYEE_NAMENVARCHAR(120)YPayee Name
5OT_TYPENVARCHAR(4)YOT Rate Type
6JOIN_DATESMALLDATETIMEYJoin Date
7ENTITLEMENT_CODENVARCHAR(6)YAL Entitlement Class
8WORK_HRS_TYPENVARCHAR(10)YWork Hours Type
9AUTHORIZEDUDT_BOOLEANNIs Active
10BADGE_NONVARCHAR(20)YBadge No.
11CHI_NAMENVARCHAR(20)YChinese Name
12SURNAMENVARCHAR(40)YSurname
13OTHERNAMENVARCHAR(110)YOthername
14CALL_NAMENVARCHAR(60)YCall Name
15SALUTATIONNVARCHAR(20)YSalutation
16HKIDNCHAR(22)YHKID
17PASSPORTNVARCHAR(80)YPassport
18SEXCHAR(10)YSex
19MARITALSMALLINTYMarital Status
20PHONENVARCHAR(60)YPhone No.
21EMAILNVARCHAR(100)YEmail
22PERSONAL_EMAILNVARCHAR(100)Y
23MOBILENVARCHAR(60)YMobile No.
24POSITIONNVARCHAR(80)YPosition
25EE_CLASSNVARCHAR(24)YEmployee Class
26SP_SNAMENVARCHAR(40)YSpouse Surname
27SP_ONAMENVARCHAR(40)YSpouse Othername
28SP_HKIDNCHAR(22)YSpouse HKID
29NATIONALITYNVARCHAR(60)YNationality
30SP_PASSPTNVARCHAR(80)YSpouse Passport
31RES_ADDRESSNVARCHAR(180)YResidental Address
32AREA_CODENVARCHAR(2)YArea Code
33COR_ADDRESSNVARCHAR(180)YCorresponding Address
34HOME_PHONENVARCHAR(60)YHome Phone No.
35OT_TYPE2NVARCHAR(4)YOT Rate Type (Special)
36OT_TYPE3NVARCHAR(4)Y
37OT_TYPE4NVARCHAR(4)Y
38OT_TYPE5NVARCHAR(4)Y
39DEDUCTION_TYPENVARCHAR(4)YDeduction Type
40ROSTER_CODENCHAR(20)YRoster Code
41COST_CENTRENVARCHAR(60)YPayroll Cost Centre
42PF_DATESMALLDATETIMEYP. Fund Start Date
43PROBATION_END_DATESMALLDATETIMEYProbation End Date
44CONTRACT_END_DATESMALLDATETIMEYContract End Date
45TERMN_DATESMALLDATETIMEYTermination Date
46REASON_CODENCHAR(4)YTermination Reason Code
47TERMN_REASONNVARCHAR(160)YTermination Reason
48WORK_LOCATIONNCHAR(20)Y
49LAST_APPRAISAL_DATESMALLDATETIMEYLast Appraisal Date
50NEXT_APPRAISAL_DATESMALLDATETIMEYNext Appraisal Date
51REPORT_TONVARCHAR(20)Y
52EMERGENCY_CONTACT_NAMENVARCHAR(100)YEmergency Contact Name
53EMERGENCY_CONTACT_RELATIONNVARCHAR(60)YEmergency Contact Relation
54EMERGENCY_CONTACT_PHONENVARCHAR(60)YEmergency Contact Phone
55EMERGENCY_CONTACT_MOBILENVARCHAR(60)YEmergency Contact Mobile No.
56PAY_METHODNCHAR(20)Y
57PRINT_IR56ENCHAR(2)YIs IR56E printed
58PRINT_IR56FGNCHAR(2)YIs IR56F/G Printed
59GEN_IR56FNCHAR(20)Y
60BANK_CODECHAR(5)YBank Code
61BANK_ACNVARCHAR(40)YBank Account No.
62MPF_SP_CODENCHAR(20)YMPF Trustee Code
63SALARY_BYNCHAR(20)YSalary By
64AUTOPAYNCHAR(20)YIs Autopay
65AUTOPAYGRPSMALLINTY
66PAY_SCALE1NVARCHAR(8)Y
67PAY_SCALE2SMALLINTY
68PAY_SCALE3NCHAR(20)Y
69PAY_SCALE4NCHAR(20)Y
70BASIC_SALDECIMAL(18,9)YBasic Salary
71ALLOWANCEDECIMAL(18,9)YAllowance 1
72ALLOWANCE2DECIMAL(18,9)YAllowance 2
73BONUSDECIMAL(18,9)YBonus
74RENTALDECIMAL(18,9)YRental
75PAY_TYPE1_AMTDECIMAL(18,9)YPay Type 1 Amount
76PAY_TYPE2_AMTDECIMAL(18,9)YPay Type 2 Amount
77PAY_TYPE3_AMTDECIMAL(18,9)YPay Type 3 Amount
78PAY_TYPE4_AMTDECIMAL(18,9)YPay Type 4 Amount
79PAY_TYPE5_AMTDECIMAL(18,9)YPay Type 5 Amount
80PAY_TYPE6_AMTDECIMAL(18,9)YPay Type 6 Amount
81PAY_TYPE7_AMTDECIMAL(18,9)YPay Type 7 Amount
82PAY_TYPE8_AMTDECIMAL(18,9)YPay Type 8 Amount
83PAY_TYPE9_AMTDECIMAL(18,9)YPay Type 9 Amount
84HOURLY_RATE1DECIMAL(18,9)Y
85HOURLY_RATE2DECIMAL(18,9)Y
86HOURLY_RATE3DECIMAL(18,9)Y
87HOURLY_RATE4DECIMAL(18,9)Y
88HOURLY_RATE5DECIMAL(18,9)Y
89HOURLY_RATE6DECIMAL(18,9)Y
90SICK_RATESMALLINTYSick Leave Rate
91SICK_RATE2SMALLINTY
92MATERNITYLEAVE_RATESMALLINTYMaternity Leave Rate
93OTHER_TAX1SMALLINTY
94OTHER_DET1NVARCHAR(52)Y
95OTHER1DECIMAL(18,2)Y
96OTHER_TAX2SMALLINTY
97OTHER_DET2NVARCHAR(52)Y
98OTHER2FLOATY
99PFUND_TYPENVARCHAR(20)YP.Fund Type
100PFUND_EEDECIMAL(18,9)YEE Contribution Percentage
101PFUND_ERDECIMAL(18,9)YER Contribution Percentage
102Voluntary_EEDECIMAL(18,9)YEE Voluntary Contribution
103Voluntary_ERDECIMAL(18,9)YER Voluntary Contribution
104EEVC_SIGNCHAR(1)Y
105ERVC_SIGNCHAR(1)Y
106PF_PLAN_NONCHAR(40)YPF Plan No.
107PF_BENEFIT_PLAN_NONCHAR(12)YPF Benefit Plan No.
108PF_CERT_NONCHAR(40)Y
109IRD_TAX_FILE_NONVARCHAR(26)YIRD Tax File No.
110IRD_REMARKSNVARCHAR(120)YIRD Remarks
111MAIN_ERNVARCHAR(60)YMain Employer
112QUARTERNCHAR(2)YIs Quater Provided
113QUAR_ADDRESSNVARCHAR(220)YQuater Address
114QUAR_NATNVARCHAR(38)YQuater Nature
115QUAR_FMSMALLDATETIMEYQuarter Date From
116QUAR_TOSMALLDATETIMEYQuarter Date To
117QUAR_RENT1DECIMAL(18,2)YQuarter Rent Amount 1
118QUAR_RENT2DECIMAL(18,2)YQuarter Rent Amount 2
119QUAR_RENT3DECIMAL(18,2)YQuarter Rent Amount 3
120QUAR_RENT4DECIMAL(18,2)YQuarter Rent Amount 4
121PREVIOUS_EMPLOYERNVARCHAR(320)Y
122OSEA_PAIDBYNCHAR(2)YIs paid by Overseas Company
123OSEA_NAMENVARCHAR(120)YOverseas Company Name
124OSEA_ADDNVARCHAR(120)YOverseas Company Address
125OSEA_AMTNVARCHAR(40)YOverseas Company Amount
126SHARE_OPTIONSMALLINTYIs Share Option
127INS_PLANNCHAR(6)YInsurance Plan
128INS_GRADENCHAR(6)YGrading
129HOLIDAY_TYPEVARCHAR(3)YHoliday Type
130PHOTOIMAGEYPhoto
131MEMONVARCHAR(4000)YMemo
132USER01NVARCHAR(12)Y
133USER02NVARCHAR(24)Y
134USER03NVARCHAR(40)Y
135USER04NVARCHAR(60)Y
136USER05NVARCHAR(100)Y
137USER06NUMERICY
138USER07NUMERICY
139USER08NUMERICY
140USER09NUMERICY
141USER10NUMERICY
142USER11DATETIMEY
143USER12DATETIMEY
144USER13DATETIMEY
145USER14DATETIMEY
146USER15DATETIMEY
147USER16BITY
148USER17BITY
149USER18BITY
150USER19BITY
151USER20BITY
152CREATE_BYUDT_USERIDN
153CREATE_DATEUDT_DATESTAMPN
154LAST_UPDATE_BYUDT_USERIDY
155LAST_UPDATE_DATEUDT_DATESTAMPY
156EP_PASSWORDVARCHAR(60)YWebleave Password
157EP_APPROVER_NO1NVARCHAR(20)YWebleave Approver 1
158EP_APPROVER_NO2NVARCHAR(20)YWebleave Approver 2
159EP_APPROVER_NO3NVARCHAR(20)Y
160EP_LOGINBITYEnable Webleave Login
161EP_NOTICEBOARD_ADMINBITY
162EP_SHOW_ON_PHONE_LISTBITY
163EP_SHOW_MOBILE_PHONEBITY
164EP_SHOW_COMPANY_CALENDARBITY
165EP_COMPANY_CALENDAR_OWN_DEPT_ONLYBITY
166EP_SHOW_UPDATE_ROSTERBITY
167HK_INCOME_TAXBITYIs HK Income Tax
168EMAIL_PAYSLIPBITYEnable Payslip by Email
169NO_PREPAID_PAYROLLBITY
170USE_PERSONAL_EMAIL_FOR_PAYSLIPBITY
171NON_CONTINUOUS_CONTRACT_EEBITY
172PART_TIME_EMPLOYEEBITY
173ENABLE_ATTENDANCE_RECORDBITY
174WEBLEAVE_SHOW_ATTENDANCEBITY
175WEBLEAVE_SHOW_LEAVE_BALANCEBITY

Indexes
Sr.NameTypeColumns
1PK_plEmployeeClusteredEE_NO
2plEmployee_Index1NonclusteredJOIN_DATE
3plEmployee_Index10NonclusteredPART_TIME_EMPLOYEE
4plEmployee_Index2NonclusteredWORK_HRS_TYPE
5plEmployee_Index3NonclusteredROSTER_CODE
6plEmployee_Index4NonclusteredTERMN_DATE
7plEmployee_Index5NonclusteredEE_CLASS
8plEmployee_Index6NonclusteredENTITLEMENT_CODE
9plEmployee_Index7NonclusteredDEPT_CODE
10plEmployee_Index8NonclusteredENABLE_ATTENDANCE_RECORD
11plEmployee_Index9NonclusteredSALARY_BY




Index
Table:[dbo].[plEmploymentHistory]

Description

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYTIMESTAMPN
2EE_NONCHAR(20)N
3PREVIOUS_EMPLOYERNVARCHAR(100)N
4POSITIONNVARCHAR(80)N
5ENDING_SALARYDECIMAL(18,9)N
6WORKED_PERIODNVARCHAR(100)N
7REASON_FOR_LEAVINGNVARCHAR(100)N

Indexes
Sr.NameTypeColumns
1PK_plEmploymentHistoryClusteredTS_KEY




Index
Table:[dbo].[plHoliday]

Description
Holiday Table

Table Columns
Sr.NameDatatypeNullableDescription
1REGIONCHAR(3)NRegion Code
2Holiday_DateSMALLDATETIMENDate of Holiday
3Holiday_DescNVARCHAR(200)YDescription of Holiday
4PUBLICBITY
5STATUTORYBITYIs Statutory Holiday?
6CREATE_BYUDT_USERIDNCreated By
7CREATE_DATEUDT_DATESTAMPNCreation Date
8LAST_UPDATE_BYUDT_USERIDYLast Updated By
9LAST_UPDATE_DATEUDT_DATESTAMPYLast Update Date

Default Constraints
Sr.NameColumnValue
1DF_plHoliday_REGIONREGION('')

Indexes
Sr.NameTypeColumns
1PK_plHolidayClusteredREGION
Holiday_Date
2plHoliday_Index1NonclusteredSTATUTORY
3plHoliday_Index2NonclusteredHoliday_Date




Index
Table:[dbo].[plIR56B]

Description
IR56B Table

Table Columns
Sr.NameDatatypeNullableDescription
1TAX_YEARNVARCHAR(8)N
2SHEET_NOINTY
3EE_NONVARCHAR(20)N
4POSTEDUDT_BOOLEANN
5EE_TAX_NONVARCHAR(26)Y
6EE_TITLENVARCHAR(8)Y
7SURNAMENVARCHAR(40)Y
8OTHERNAMENVARCHAR(110)Y
9CHI_NAMENVARCHAR(100)Y
10HKID_NONVARCHAR(18)Y
11SEXNVARCHAR(2)Y
12MARITALSMALLINTY
13PASSPORTNVARCHAR(80)Y
14SPOUSE_NAMNVARCHAR(100)Y
15SP_HKIDNVARCHAR(18)Y
16SP_PASSPTNVARCHAR(80)Y
17RES_ADD1NVARCHAR(120)Y
18RES_ADD2NVARCHAR(60)Y
19AREA_CODENVARCHAR(2)Y
20CORR_ADDNVARCHAR(120)Y
21POSITIONNVARCHAR(80)Y
22MAIN_ERNVARCHAR(60)Y
23EMPLOYMENTNVARCHAR(32)Y
24PERIOD_1NVARCHAR(32)Y
25AMOUNT_1INTY
26PERIOD_2NVARCHAR(32)Y
27AMOUNT_2INTY
28PERIOD_3NVARCHAR(32)Y
29AMOUNT_3INTY
30PERIOD_4NVARCHAR(32)Y
31AMOUNT_4INTY
32PERIOD_5NVARCHAR(32)Y
33AMOUNT_5INTY
34PERIOD_6NVARCHAR(32)Y
35AMOUNT_6INTY
36PERIOD_7NVARCHAR(32)Y
37AMOUNT_7INTY
38PERIOD_8NVARCHAR(32)Y
39AMOUNT_8INTY
40PERIOD_9NVARCHAR(32)Y
41AMOUNT_9INTY
42PERIOD_10NVARCHAR(32)Y
43AMOUNT_10INTY
44DESC_11NVARCHAR(70)Y
45PERIOD_11NVARCHAR(32)Y
46AMOUNT_11INTY
47DESC_12NVARCHAR(70)Y
48PERIOD_12NVARCHAR(32)Y
49AMOUNT_12INTY
50DESC_13NVARCHAR(70)Y
51PERIOD_13NVARCHAR(32)Y
52AMOUNT_13INTY
53PERIOD_14NVARCHAR(32)Y
54AMOUNT_14INTY
55TTL_AMOUNTINTY
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
79CREATE_BYUDT_USERIDN
80CREATE_DATEUDT_DATESTAMPN
81LAST_UPDATE_BYUDT_USERIDY
82LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plIR56BClusteredTAX_YEAR
EE_NO




Index
Table:[dbo].[plIR56BBatch]

Description
IR56B Batch

Table Columns
Sr.NameDatatypeNullableDescription
1TAX_YEARNCHAR(8)N
2ER_TAX_NONCHAR(24)Y
3POSTEDUDT_BOOLEANN
4PRINT_DATESMALLDATETIMEY
5CREATE_BYUDT_USERIDN
6CREATE_DATEUDT_DATESTAMPN
7LAST_UPDATE_BYUDT_USERIDY
8LAST_UPDATE_DATEUDT_DATESTAMPY




Index
Table:[dbo].[plIR56F]

Description
IR56F Table

Table Columns
Sr.NameDatatypeNullableDescription
1EE_NONVARCHAR(20)N
2POSTEDUDT_BOOLEANN
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
14MARITALSMALLINTY
15SPOUSE_NAMNVARCHAR(100)Y
16SP_HKIDNVARCHAR(80)Y
17SP_PASSPTNVARCHAR(80)Y
18RES_ADD1NVARCHAR(120)Y
19RES_ADD2NVARCHAR(120)Y
20AREA_CODENCHAR(2)Y
21CORR_ADDNVARCHAR(120)Y
22POSITIONNVARCHAR(80)Y
23MAIN_ERNVARCHAR(60)Y
24LEAVE_DATENVARCHAR(16)Y
25LEAVE_FORNVARCHAR(80)Y
26EMPLOYMENTNVARCHAR(32)Y
27PERIOD_1NVARCHAR(32)Y
28AMOUNT_1INTY
29PERIOD_2NVARCHAR(32)Y
30AMOUNT_2INTY
31PERIOD_3NVARCHAR(32)Y
32AMOUNT_3INTY
33PERIOD_4NVARCHAR(32)Y
34AMOUNT_4INTY
35PERIOD_5NVARCHAR(32)Y
36AMOUNT_5INTY
37PERIOD_6NVARCHAR(32)Y
38AMOUNT_6INTY
39PERIOD_7NVARCHAR(32)Y
40AMOUNT_7INTY
41PERIOD_8NVARCHAR(32)Y
42AMOUNT_8INTY
43PERIOD_9NVARCHAR(32)Y
44AMOUNT_9INTY
45TTL_AMOUNTINTY
46QUARTERNVARCHAR(2)Y
47QUAR_ADD1NVARCHAR(120)Y
48QUAR_ADD2NVARCHAR(120)Y
49QUAR_NATNVARCHAR(40)Y
50QUAR_PERDNVARCHAR(60)Y
51QUAR_RENT1INTY
52QUAR_RENT2INTY
53QUAR_RENT3INTY
54QUAR_RENT4INTY
55EE_PAIDBYNVARCHAR(2)Y
56OSEA_NAMENVARCHAR(120)Y
57OSEA_ADDNVARCHAR(120)Y
58OSEA_AMTNVARCHAR(40)Y
59NEW_ERNVARCHAR(100)Y
60NEW_EE_ADDNVARCHAR(80)Y
61REMARKSNVARCHAR(120)Y
62IR56F_DATEDATETIMEY
63CREATE_BYUDT_USERIDN
64CREATE_DATEUDT_DATESTAMPN
65LAST_UPDATE_BYUDT_USERIDY
66LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plIR56FClusteredEE_NO




Index
Table:[dbo].[plIR56G]

Description
IR56G Table

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
14MARITALSMALLINTY
15SPOUSE_NAMNVARCHAR(100)Y
16SP_HKIDNVARCHAR(80)Y
17SP_PASSPTNVARCHAR(80)Y
18RES_ADD1NVARCHAR(120)Y
19RES_ADD2NVARCHAR(120)Y
20AREA_CODENCHAR(2)Y
21LEAVE_HK_DATESMALLDATETIMEY
22CORR_ADDNVARCHAR(120)Y
23POSITIONNVARCHAR(80)Y
24MAIN_ERNVARCHAR(60)Y
25LEAVE_DATENVARCHAR(16)Y
26LEAVE_FORNVARCHAR(80)Y
27EMPLOYMENTNVARCHAR(32)Y
28PERIOD_1NVARCHAR(32)Y
29AMOUNT_1INTY
30PERIOD_2NVARCHAR(32)Y
31AMOUNT_2INTY
32PERIOD_3NVARCHAR(32)Y
33AMOUNT_3INTY
34PERIOD_4NVARCHAR(32)Y
35AMOUNT_4INTY
36PERIOD_5NVARCHAR(32)Y
37AMOUNT_5INTY
38PERIOD_6NVARCHAR(32)Y
39AMOUNT_6INTY
40PERIOD_7NVARCHAR(32)Y
41AMOUNT_7INTY
42PERIOD_8NVARCHAR(32)Y
43AMOUNT_8INTY
44PERIOD_9NVARCHAR(32)Y
45AMOUNT_9INTY
46TTL_AMOUNTINTY
47QUARTERNVARCHAR(2)Y
48QUAR_ADD1NVARCHAR(120)Y
49QUAR_ADD2NVARCHAR(120)Y
50QUAR_NATNVARCHAR(40)Y
51QUAR_PERDNVARCHAR(60)Y
52QUAR_RENT1INTY
53QUAR_RENT2INTY
54QUAR_RENT3INTY
55QUAR_RENT4INTY
56EE_PAIDBYNVARCHAR(2)Y
57OSEA_NAMENVARCHAR(120)Y
58OSEA_ADDNVARCHAR(120)Y
59OSEA_AMTNVARCHAR(40)Y
60NEW_ERNVARCHAR(100)Y
61NEW_EE_ADDNVARCHAR(80)Y
62REMARKSNVARCHAR(120)Y
63BORNE_BY_ERSMALLINTY
64MONEY_HELDSMALLINTY
65MONEY_HELD_AMTNVARCHAR(60)Y
66MONEY_HELD_REASONNVARCHAR(100)Y
67DEPARTURE_REASONSMALLINTY
68DEPARTURE_RESIDENVARCHAR(140)Y
69DEPARTURE_HOME_COUNTRYNVARCHAR(40)Y
70DEPARTURE_SECONDEDNVARCHAR(40)Y
71DEPARTURE_OTHERNVARCHAR(200)Y
72RETURN_TO_HKSMALLINTY
73RETURN_DATENVARCHAR(100)Y
74SHARE_OPTIONSSMALLINTY
75SHARE_NONVARCHAR(100)Y
76SHARE_DATENVARCHAR(100)Y
77IR56G_DATEDATETIMEY
78CREATE_BYUDT_USERIDN
79CREATE_DATEUDT_DATESTAMPN
80LAST_UPDATE_BYUDT_USERIDY
81LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plIR56GClusteredEE_NO




Index
Table:[dbo].[plLeave]

Description
Leave Entry Records

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3LEAVE_FRSMALLDATETIMEY
4LEAVE_TOSMALLDATETIMEY
5DAYSDECIMAL(12,4)Y
6AMPMNCHAR(2)Y
7LEAVE_CODENCHAR(6)Y
8FR_TIMECHAR(5)Y
9TO_TIMECHAR(5)Y
10REMARKSNVARCHAR(510)Y
11CREATE_BYUDT_USERIDN
12CREATE_DATEUDT_DATESTAMPN
13LAST_UPDATE_BYUDT_USERIDY
14LAST_UPDATE_DATEUDT_DATESTAMPY
15APPROVED_BYUDT_USERIDY
16APPROVED_DATEUDT_DATESTAMPY
17VERIFY_BYUDT_USERIDY
18VERIFY_DATEUDT_DATESTAMPY
19LeaveApply_RowSerialDECIMAL(18,0)Y
20MANUAL_OVERWRITESMALLINTY
21ATTACHMENT_NAMENVARCHAR(200)Y
22ATTACHMENT_IMAGEIMAGEY

Triggers
Sr.NameDescription
1plLeave_DeleteLeaveDayRecord
2plLeave_UpdateLeaveDayRecord

Indexes
Sr.NameTypeColumns
1PK_plLeaveClusteredRowSerial
2plLeaveNonclusteredEE_NO
3plLeave_INDEX1NonclusteredLEAVE_CODE
4plLeave_INDEX2NonclusteredEE_NO
LEAVE_FR
LEAVE_CODE
5plLeave_INDEX3NonclusteredLEAVE_FR




Index
Table:[dbo].[plLeaveAdjustment]

Description
Leave Adjustment Table

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3ADJ_DATESMALLDATETIMEY
4DAYSDECIMAL(12,4)Y
5NATURENCHAR(2)Y
6REMARKSNVARCHAR(510)Y
7CREATE_BYUDT_USERIDN
8CREATE_DATEUDT_DATESTAMPN
9LAST_UPDATE_BYUDT_USERIDY
10LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plLeaveAdjustmentClusteredRowSerial
2plLeaveAdjustment_INDEX1NonclusteredEE_NO
ADJ_DATE
NATURE




Index
Table:[dbo].[plLeaveApply]

Description
Leave Application Records

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2EE_NONVARCHAR(20)N
3LEAVE_FRSMALLDATETIMEY
4LEAVE_TOSMALLDATETIMEY
5DAYSDECIMAL(12,4)Y
6AMPMNCHAR(2)Y
7LEAVE_CODENCHAR(6)Y
8FR_TIMECHAR(5)Y
9TO_TIMECHAR(5)Y
10REMARKSNVARCHAR(510)Y
11CREATE_BYUDT_USERIDN
12CREATE_DATEUDT_DATESTAMPN
13LAST_UPDATE_BYUDT_USERIDY
14LAST_UPDATE_DATEUDT_DATESTAMPY
15APPROVED_STSNVARCHAR(40)N
16PARTIALLY_APPROVED_BYNVARCHAR(40)Y
17PARTIALLY_APPROVED_DATESMALLDATETIMEY
18MAJORITY_APPROVED_BYNVARCHAR(40)Y
19MAJORITY_APPROVED_DATESMALLDATETIMEY
20ACTION_BYNVARCHAR(20)Y
21ACTION_DATESMALLDATETIMEY
22ATTACHMENT_NAMENVARCHAR(200)Y
23ATTACHMENT_IMAGEIMAGEY

Indexes
Sr.NameTypeColumns
1PK_plLeaveApplyClusteredRowSerial




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
6AMPMNCHAR(2)Y
7LEAVE_CODENCHAR(6)Y
8NATURENCHAR(2)Y

Indexes
Sr.NameTypeColumns
1PK_plLeaveDayRecordClusteredRowSerial
2plLeaveDayRecord_Index1NonclusteredLEAVE_CODE
3plLeaveDayRecord_Index2NonclusteredEE_NO
LEAVE_DATE
4plLeaveDayRecord_Index3NonclusteredEE_NO
LEAVE_DATE
AMPM
5plLeaveDayRecord_Index4NonclusteredEE_NO
LEAVE_DATE
DAYS
6plLeaveDayRecord_Index5NonclusteredEE_NO
LEAVE_DATE
NATURE
7plLeaveDayRecord_Index6NonclusteredNATURE
8plLeaveDayRecord_Index7NonclusteredLEAVE_DATE




Index
Table:[dbo].[plLeaveEntitlement]

Description
AL Entitlement Class

Table Columns
Sr.NameDatatypeNullableDescription
1Entitlement_CodeNVARCHAR(6)N
2DESCRIPTIONNVARCHAR(120)Y
3ENTITLEMENT_YEARCHAR(1)Y
4Entitle_over_1SMALLINTY
5Entitle_over_2SMALLINTY
6Entitle_over_3SMALLINTY
7Entitle_over_4SMALLINTY
8Entitle_over_5SMALLINTY
9Entitle_over_6SMALLINTY
10Entitle_over_7SMALLINTY
11Entitle_over_8SMALLINTY
12Entitle_over_9SMALLINTY
13Entitle_over_10SMALLINTY
14Entitle_over_11SMALLINTY
15Entitle_over_AD_1SMALLINTY
16Entitle_over_AD_2SMALLINTY
17Entitle_over_AD_3SMALLINTY
18Entitle_over_AD_4SMALLINTY
19Entitle_over_AD_5SMALLINTY
20Entitle_over_AD_6SMALLINTY
21Entitle_over_AD_7SMALLINTY
22Entitle_over_AD_8SMALLINTY
23Entitle_over_AD_9SMALLINTY
24Entitle_over_AD_10SMALLINTY
25Entitle_over_AD_11SMALLINTY
26IN_ADVANCESMALLINTY
27IN_ADVANCE_ADSMALLINTY
28START_MONTHSMALLINTY
29CREATE_BYUDT_USERIDY
30CREATE_DATEUDT_DATESTAMPY
31LAST_UPDATE_BYUDT_USERIDY
32LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plLeaveEntitlementClusteredEntitlement_Code




Index
Table:[dbo].[plLeaveNature]

Description
Leave Nature Table

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

Indexes
Sr.NameTypeColumns
1PK_plLeaveNatureClusteredNATURE




Index
Table:[dbo].[plLeavePeriod]

Description
Leave Period Table

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMSMALLDATETIMEY
3PERIOD_TOSMALLDATETIMEY
4CREATE_BYUDT_USERIDN
5CREATE_DATEUDT_DATESTAMPN
6LAST_UPDATE_BYUDT_USERIDY
7LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plLeavePeriod_1ClusteredPERIOD
2plLeavePeriod_INDEX1NonclusteredPERIOD_FROM
3plLeavePeriod_INDEX2NonclusteredPERIOD_TO




Index
Table:[dbo].[plLeaveType]

Description
Leave Type Table

Table Columns
Sr.NameDatatypeNullableDescription
1LEAVE_CODENCHAR(6)N
2DESCRIPTIONNCHAR(60)N
3NATURENCHAR(2)N
4WEBLEAVE_DECIMALINTY
5WEBLEAVE_VISIBLEINTY
6WEBLEAVE_ALLOW_BACKDATE_APPLICATIONINTY
7CREATE_BYUDT_USERIDN
8CREATE_DATEUDT_DATESTAMPN
9LAST_UPDATE_BYUDT_USERIDY
10LAST_UPDATE_DATEUDT_DATESTAMPY

Triggers
Sr.NameDescription
1plLeaveType_UpdateLeaveDayRecord

Indexes
Sr.NameTypeColumns
1PK_plLeaveTypeClusteredLEAVE_CODE
2plLeaveType_INDEX1NonclusteredNATURE




Index
Table:[dbo].[plMPFSP]

Description
MPF Trustees Table

Table Columns
Sr.NameDatatypeNullableDescription
1MPF_SP_CODENCHAR(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_IDNVARCHAR(40)Y
8MPF_SP_TRUSTEE_BANK_AC_NONVARCHAR(40)Y
9MPF_SP_STATEMENT_FORMATNCHAR(2)Y
10CREATE_BYUDT_USERIDN
11CREATE_DATEUDT_DATESTAMPN
12LAST_UPDATE_BYUDT_USERIDY
13LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plMPFSPClusteredMPF_SP_CODE




Index
Table:[dbo].[plOT]

Description
OT Rate Table

Table Columns
Sr.NameDatatypeNullableDescription
1OT_TYPENVARCHAR(4)N
2DESCRIPTIONNVARCHAR(100)Y
3PAY_TYPEVARCHAR(20)Y
4PAY_RATEDECIMAL(18,2)Y
5OT_RATE_FACTORDECIMAL(18,10)Y
6CREATE_BYUDT_USERIDN
7CREATE_DATEUDT_DATESTAMPN
8LAST_UPDATE_BYUDT_USERIDY
9LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plOTClusteredOT_TYPE




Index
Table:[dbo].[plPayroll]

Description
Payroll Records

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2YEARSMALLINTY
3MONTHSMALLINTY
4PERIODVARCHAR(7)Y
5POSTEDUDT_BOOLEANN
6EE_NONVARCHAR(20)N
7SALARY_PAY_DATESMALLDATETIMEY
8BADGE_NONVARCHAR(20)Y
9DEPT_CODENVARCHAR(24)Y
10EE_CLASSNVARCHAR(24)Y
11WORK_LOCATIONNCHAR(20)Y
12SALARY_BYNVARCHAR(2)Y
13AUTOPAYNVARCHAR(2)Y
14CHEQUE_NOUDT_CHEQUE_NOY
15WORK_DAYSDECIMAL(18,4)Y
16BASIC_SAL_REFDECIMAL(18,9)Y
17BASIC_SALDECIMAL(18,9)Y
18HDY_DAYRATEDECIMAL(18,9)Y
19HDY_LEAVEDECIMAL(18,4)Y
20HDY_PAYDECIMAL(18,9)Y
21ANN_DAYRATEDECIMAL(18,9)Y
22ANN_LEAVEDECIMAL(18,4)Y
23ANN_PAYDECIMAL(18,9)Y
24SICK_RATESMALLINTY
25SICK_DAYRATEDECIMAL(18,9)Y
26SICK_LEAVEDECIMAL(18,4)Y
27SICK_PAYDECIMAL(18,9)Y
28SICK_RATE2SMALLINTY
29SICK_DAYRATE2DECIMAL(18,9)Y
30SICK_LEAVE2DECIMAL(18,4)Y
31SICK_PAY2DECIMAL(18,9)Y
32BASIC_PAYDECIMAL(18,9)Y
33MATERNITYLEAVE_RATESMALLINTY
34MATERNITYLEAVE_DAYRATEDECIMAL(18,9)Y
35MATERNITYLEAVE_DAYDECIMAL(18,4)Y
36MATERNITYLEAVE_PAYDECIMAL(18,9)Y
37OT_RATEDECIMAL(18,9)Y
38OT_HRSDECIMAL(18,9)Y
39OT_PAYDECIMAL(18,9)Y
40OT_RATE2DECIMAL(18,9)Y
41OT_HRS2DECIMAL(18,9)Y
42OT_PAY2DECIMAL(18,9)Y
43OT_RATE3DECIMAL(18,9)Y
44OT_HRS3DECIMAL(18,9)Y
45OT_PAY3DECIMAL(18,9)Y
46OT_RATE4DECIMAL(18,9)Y
47OT_HRS4DECIMAL(18,9)Y
48OT_PAY4DECIMAL(18,9)Y
49OT_RATE5DECIMAL(18,9)Y
50OT_HRS5DECIMAL(18,9)Y
51OT_PAY5DECIMAL(18,9)Y
52DEDUCTION_RATEDECIMAL(18,9)Y
53DEDUCTION_MINSDECIMAL(18,9)Y
54DEDUCTION_AMTDECIMAL(18,9)Y
55ALLOWANCE_DAYRATEDECIMAL(18,9)Y
56ALLOWANCEDECIMAL(18,9)Y
57ALLOWANCE2_DAYRATEDECIMAL(18,9)Y
58ALLOWANCE2DECIMAL(18,9)Y
59DOUBLE_PAYDECIMAL(18,9)Y
60BONUSDECIMAL(18,9)Y
61WAGES_IN_LIEU_DAYRATEDECIMAL(18,9)Y
62WAGES_IN_LIEU_DAYSDECIMAL(18,4)Y
63WAGES_IN_LIEU_PAYDECIMAL(18,9)Y
64PAY_TYPE1_AMTDECIMAL(18,9)Y
65PAY_TYPE2_AMTDECIMAL(18,9)Y
66PAY_TYPE3_AMTDECIMAL(18,9)Y
67PAY_TYPE4_AMTDECIMAL(18,9)Y
68PAY_TYPE5_AMTDECIMAL(18,9)Y
69PAY_TYPE6_AMTDECIMAL(18,9)Y
70PAY_TYPE7_AMTDECIMAL(18,9)Y
71PAY_TYPE8_AMTDECIMAL(18,9)Y
72PAY_TYPE9_AMTDECIMAL(18,9)Y
73PAY_TYPE1_DESCNVARCHAR(100)Y
74PAY_TYPE2_DESCNVARCHAR(100)Y
75PAY_TYPE3_DESCNVARCHAR(100)Y
76PAY_TYPE4_DESCNVARCHAR(100)Y
77PAY_TYPE5_DESCNVARCHAR(100)Y
78PAY_TYPE6_DESCNVARCHAR(100)Y
79PAY_TYPE7_DESCNVARCHAR(100)Y
80PAY_TYPE8_DESCNVARCHAR(100)Y
81PAY_TYPE9_DESCNVARCHAR(100)Y
82NOPAY_RATEDECIMAL(18,9)Y
83NOPAY_HRSDECIMAL(18,9)Y
84NOPAY_PAYDECIMAL(18,9)Y
85NOPAY_PAY_BYCHAR(1)Y
86RESTDAY_PAYDECIMAL(18,9)Y
87LUNCHBREAK_PAYDECIMAL(18,9)Y
88MPF_AUTOCALSMALLINTY
89MPF_CPERD1SMALLDATETIMEY
90MPF_CPERD2SMALLDATETIMEY
91PFUND_TYPENVARCHAR(20)Y
92PFUND_EEDECIMAL(18,9)Y
93PFUND_ERDECIMAL(18,9)Y
94PFUND_EE_PAYDECIMAL(18,9)Y
95PFUND_EE_PAY_RETENTIONDECIMAL(18,9)Y
96PFUND_ER_PAYDECIMAL(18,9)Y
97PFUND_ER_PAY_RETENTIONDECIMAL(18,9)Y
98MPF_VLYEEDECIMAL(18,9)Y
99MPF_VLYEE_RETENTIONDECIMAL(18,9)Y
100MPF_VLYERDECIMAL(18,9)Y
101MPF_VLYER_RETENTIONDECIMAL(18,9)Y
102Voluntary_EEDECIMAL(18,9)Y
103Voluntary_ERDECIMAL(18,9)Y
104EEVC_SIGNCHAR(1)Y
105ERVC_SIGNCHAR(1)Y
106PAY_RATEDECIMAL(18,9)Y
107PAY_RATE2DECIMAL(18,9)Y
108PAY_RATE3DECIMAL(18,9)Y
109PAY_RATE4DECIMAL(18,9)Y
110PAY_RATE5DECIMAL(18,9)Y
111PAY_RATE6DECIMAL(18,9)Y
112WORK_TIMEDECIMAL(18,9)Y
113WORK_TIME2DECIMAL(18,9)Y
114WORK_TIME3DECIMAL(18,9)Y
115WORK_TIME4DECIMAL(18,9)Y
116WORK_TIME5DECIMAL(18,9)Y
117WORK_TIME6DECIMAL(18,9)Y
118WORK_PAYDECIMAL(18,9)Y
119WORK_PAY2DECIMAL(18,9)Y
120WORK_PAY3DECIMAL(18,9)Y
121WORK_PAY4DECIMAL(18,9)Y
122WORK_PAY5DECIMAL(18,9)Y
123WORK_PAY6DECIMAL(18,9)Y
124MPF_INCOMEDECIMAL(18,9)Y
125MPF_OPTIONAL_INCOMEDECIMAL(18,9)Y
126TOTAL_PAYDECIMAL(18,9)Y
127HOURLY_EE_REGARDED_DAYSDECIMAL(18,2)Y
128WORKED_HRSDECIMAL(18,2)Y
129COST_CENTRENVARCHAR(60)Y
130PF_EE_PERCENTNVARCHAR(40)Y
131PF_ER_PERCENTNVARCHAR(40)Y
132REMARKNVARCHAR(2048)Y
133REMARKS2NVARCHAR(2048)Y
134CREATE_BYUDT_USERIDN
135CREATE_DATEUDT_DATESTAMPN
136LAST_UPDATE_BYUDT_USERIDY
137LAST_UPDATE_DATEUDT_DATESTAMPY

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_INDEX2NonclusteredYEAR
MONTH
POSTED
EE_NO
7plPayroll_INDEX3NonclusteredPOSTED
8plPayroll_INDEX4NonclusteredYEAR
MONTH
EE_NO
9plPayroll_INDEX5NonclusteredCREATE_DATE
LAST_UPDATE_DATE
10plPayroll_INDEX6NonclusteredMONTH
11plPayroll_INDEX7NonclusteredLAST_UPDATE_DATE
12plPayroll_Index8NonclusteredEE_CLASS
13plPayroll_INDEX9NonclusteredSALARY_PAY_DATE




Index
Table:[dbo].[plPayrollBatch]

Description
Payroll Batch

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2PERIODCHAR(7)Y
3YEARSMALLINTY
4MONTHSMALLINTY
5POSTEDUDT_BOOLEANN
6SALARY_PAY_DATESMALLDATETIMEY
7MPF_CONTRIBUTION_DATESMALLDATETIMEY
8TOTAL_AUTOPAY_AMOUNTDECIMAL(18,9)Y
9TOTAL_CHEQUE_AMOUNTDECIMAL(18,9)Y
10TOTAL_MPF_EEDECIMAL(18,9)Y
11TOTAL_MPF_ERDECIMAL(18,9)Y
12CREATE_BYUDT_USERIDN
13CREATE_DATEUDT_DATESTAMPN
14LAST_UPDATE_BYUDT_USERIDY
15LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plPayrollBatchClusteredBATCH_NO
2plPayrollBatch_INDEX1NonclusteredPERIOD




Index
Table:[dbo].[plPayType]

Description
Pay Type Group Table

Table Columns
Sr.NameDatatypeNullableDescription
1RowSerialDECIMAL(18,0)N
2PAY_TYPE_GROUPINTY
3PAY_TYPENVARCHAR(100)Y

Indexes
Sr.NameTypeColumns
1PK_plPayTypeClusteredRowSerial




Index
Table:[dbo].[plPeriod]

Description
Payroll Period

Table Columns
Sr.NameDatatypeNullableDescription
1PERIODCHAR(7)N
2PERIOD_FROMSMALLDATETIMEY
3PERIOD_TOSMALLDATETIMEY
4WORKDAYDECIMAL(18,1)Y
5HOLIDAYSMALLINTY
6CREATE_BYUDT_USERIDN
7CREATE_DATEUDT_DATESTAMPN
8LAST_UPDATE_BYUDT_USERIDY
9LAST_UPDATE_DATEUDT_DATESTAMPY

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(80)N
3DEPT_CODENVARCHAR(24)N
4JOB_DESCRIPTIONNVARCHAR(-1)Y
5REQUIREMENTSNVARCHAR(-1)Y
6EXPECTED_EMPLOYEESINTY
7CREATE_BYCHAR(10)Y
8CREATE_DATEDATETIMEY
9LAST_UPDATE_BYCHAR(10)Y
10LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plPositionClusteredRowSerial




Index
Table:[dbo].[plPrePaidPayroll]

Description
Prepaid Payroll Records

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2YEARSMALLINTY
3MONTHSMALLINTY
4PERIODVARCHAR(7)Y
5POSTEDUDT_BOOLEANN
6EE_NONVARCHAR(20)N
7SALARY_PAY_DATESMALLDATETIMEY
8BADGE_NONVARCHAR(20)Y
9DEPT_CODENVARCHAR(24)Y
10EE_CLASSNVARCHAR(24)Y
11WORK_LOCATIONNCHAR(20)Y
12SALARY_BYNVARCHAR(2)Y
13AUTOPAYNVARCHAR(2)Y
14CHEQUE_NOUDT_CHEQUE_NOY
15WORK_DAYSDECIMAL(18,4)Y
16BASIC_SAL_REFDECIMAL(18,9)Y
17BASIC_SALDECIMAL(18,9)Y
18BASIC_PAYDECIMAL(18,9)Y
19OT_RATEDECIMAL(18,9)Y
20OT_HRSDECIMAL(18,9)Y
21OT_PAYDECIMAL(18,9)Y
22OT_RATE2DECIMAL(18,9)Y
23OT_HRS2DECIMAL(18,9)Y
24OT_PAY2DECIMAL(18,9)Y
25OT_RATE3DECIMAL(18,9)Y
26OT_HRS3DECIMAL(18,9)Y
27OT_PAY3DECIMAL(18,9)Y
28OT_RATE4DECIMAL(18,9)Y
29OT_HRS4DECIMAL(18,9)Y
30OT_PAY4DECIMAL(18,9)Y
31OT_RATE5DECIMAL(18,9)Y
32OT_HRS5DECIMAL(18,9)Y
33OT_PAY5DECIMAL(18,9)Y
34ALLOWANCE_DAYRATEDECIMAL(18,9)Y
35ALLOWANCEDECIMAL(18,9)Y
36ALLOWANCE2_DAYRATEDECIMAL(18,9)Y
37ALLOWANCE2DECIMAL(18,9)Y
38DOUBLE_PAYDECIMAL(18,9)Y
39BONUSDECIMAL(18,9)Y
40HDY_DAYRATEDECIMAL(18,9)Y
41HDY_LEAVEDECIMAL(18,4)Y
42HDY_PAYDECIMAL(18,9)Y
43ANN_DAYRATEDECIMAL(18,9)Y
44ANN_LEAVEDECIMAL(18,4)Y
45ANN_PAYDECIMAL(18,9)Y
46SICK_RATESMALLINTY
47SICK_DAYRATEDECIMAL(18,9)Y
48SICK_LEAVEDECIMAL(18,4)Y
49SICK_PAYDECIMAL(18,9)Y
50SICK_RATE2SMALLINTY
51SICK_DAYRATE2DECIMAL(18,9)Y
52SICK_LEAVE2DECIMAL(18,4)Y
53SICK_PAY2DECIMAL(18,9)Y
54MATERNITYLEAVE_RATESMALLINTY
55MATERNITYLEAVE_DAYRATEDECIMAL(18,9)Y
56MATERNITYLEAVE_DAYDECIMAL(18,4)Y
57MATERNITYLEAVE_PAYDECIMAL(18,9)Y
58DEDUCTION_RATEDECIMAL(18,9)Y
59DEDUCTION_MINSDECIMAL(18,9)Y
60DEDUCTION_AMTDECIMAL(18,9)Y
61WAGES_IN_LIEU_DAYRATEDECIMAL(18,9)Y
62WAGES_IN_LIEU_DAYSDECIMAL(18,4)Y
63WAGES_IN_LIEU_PAYDECIMAL(18,9)Y
64PAY_TYPE1_AMTDECIMAL(18,9)Y
65PAY_TYPE2_AMTDECIMAL(18,9)Y
66PAY_TYPE3_AMTDECIMAL(18,9)Y
67PAY_TYPE4_AMTDECIMAL(18,9)Y
68PAY_TYPE5_AMTDECIMAL(18,9)Y
69PAY_TYPE6_AMTDECIMAL(18,9)Y
70PAY_TYPE7_AMTDECIMAL(18,9)Y
71PAY_TYPE8_AMTDECIMAL(18,9)Y
72PAY_TYPE9_AMTDECIMAL(18,9)Y
73PAY_TYPE1_DESCNVARCHAR(100)Y
74PAY_TYPE2_DESCNVARCHAR(100)Y
75PAY_TYPE3_DESCNVARCHAR(100)Y
76PAY_TYPE4_DESCNVARCHAR(100)Y
77PAY_TYPE5_DESCNVARCHAR(100)Y
78PAY_TYPE6_DESCNVARCHAR(100)Y
79PAY_TYPE7_DESCNVARCHAR(100)Y
80PAY_TYPE8_DESCNVARCHAR(100)Y
81PAY_TYPE9_DESCNVARCHAR(100)Y
82NOPAY_RATEDECIMAL(18,9)Y
83NOPAY_HRSDECIMAL(18,9)Y
84NOPAY_PAYDECIMAL(18,9)Y
85NOPAY_PAY_BYCHAR(1)Y
86RESTDAY_PAYDECIMAL(18,9)Y
87LUNCHBREAK_PAYDECIMAL(18,9)Y
88MPF_AUTOCALSMALLINTY
89MPF_CPERD1SMALLDATETIMEY
90MPF_CPERD2SMALLDATETIMEY
91PFUND_TYPENVARCHAR(20)Y
92PFUND_EEDECIMAL(18,9)Y
93PFUND_ERDECIMAL(18,9)Y
94PFUND_EE_PAYDECIMAL(18,9)Y
95PFUND_EE_PAY_RETENTIONDECIMAL(18,9)Y
96PFUND_ER_PAYDECIMAL(18,9)Y
97PFUND_ER_PAY_RETENTIONDECIMAL(18,9)Y
98MPF_VLYEEDECIMAL(18,9)Y
99MPF_VLYEE_RETENTIONDECIMAL(18,9)Y
100MPF_VLYERDECIMAL(18,9)Y
101MPF_VLYER_RETENTIONDECIMAL(18,9)Y
102PF_EE_PERCENTNVARCHAR(40)Y
103PF_ER_PERCENTNVARCHAR(40)Y
104Voluntary_EEDECIMAL(18,9)Y
105Voluntary_ERDECIMAL(18,9)Y
106EEVC_SIGNCHAR(1)Y
107ERVC_SIGNCHAR(1)Y
108PAY_RATEDECIMAL(18,9)Y
109PAY_RATE2DECIMAL(18,9)Y
110PAY_RATE3DECIMAL(18,9)Y
111PAY_RATE4DECIMAL(18,9)Y
112PAY_RATE5DECIMAL(18,9)Y
113PAY_RATE6DECIMAL(18,9)Y
114WORK_TIMEDECIMAL(18,9)Y
115WORK_TIME2DECIMAL(18,9)Y
116WORK_TIME3DECIMAL(18,9)Y
117WORK_TIME4DECIMAL(18,9)Y
118WORK_TIME5DECIMAL(18,9)Y
119WORK_TIME6DECIMAL(18,9)Y
120WORK_PAYDECIMAL(18,9)Y
121WORK_PAY2DECIMAL(18,9)Y
122WORK_PAY3DECIMAL(18,9)Y
123WORK_PAY4DECIMAL(18,9)Y
124WORK_PAY5DECIMAL(18,9)Y
125WORK_PAY6DECIMAL(18,9)Y
126MPF_INCOMEDECIMAL(18,9)Y
127TOTAL_PAYDECIMAL(18,9)Y
128HOURLY_EE_REGARDED_DAYSDECIMAL(18,2)Y
129WORKED_HRSDECIMAL(18,2)Y
130COST_CENTRENVARCHAR(60)Y
131REMARKNVARCHAR(2048)Y
132REMARKS2NVARCHAR(2048)Y
133CREATE_BYUDT_USERIDN
134CREATE_DATEUDT_DATESTAMPN
135LAST_UPDATE_BYUDT_USERIDY
136LAST_UPDATE_DATEUDT_DATESTAMPY

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




Index
Table:[dbo].[plPrepaidPayrollBatch]

Description
Prepaid Payroll Batch

Table Columns
Sr.NameDatatypeNullableDescription
1BATCH_NONCHAR(24)N
2PERIODCHAR(7)Y
3YEARSMALLINTY
4MONTHSMALLINTY
5POSTEDUDT_BOOLEANN
6SALARY_PAY_DATESMALLDATETIMEY
7TOTAL_AUTOPAY_AMOUNTDECIMAL(18,9)Y
8TOTAL_CHEQUE_AMOUNTDECIMAL(18,9)Y
9TOTAL_MPF_EEDECIMAL(18,9)Y
10TOTAL_MPF_ERDECIMAL(18,9)Y
11MPF_CONTRIBUTION_DATESMALLDATETIMEY
12CREATE_BYUDT_USERIDN
13CREATE_DATEUDT_DATESTAMPN
14LAST_UPDATE_BYUDT_USERIDY
15LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plPrepaidPayrollBatchClusteredBATCH_NO




Index
Table:[dbo].[plPromotion]

Description
Position History Table

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYTIMESTAMPN
2EE_NONCHAR(20)N
3START_DATESMALLDATETIMEY
4DEPT_CODENCHAR(24)Y
5POSITIONNVARCHAR(100)Y
6SALARYDECIMAL(18,9)Y
7BONUSDECIMAL(18,9)Y
8ALLOWANCEDECIMAL(18,9)Y
9ALLOWANCE2DECIMAL(18,9)Y
10MEMONVARCHAR(2048)Y

Indexes
Sr.NameTypeColumns
1IX_plPromotionNonclusteredEE_NO
2PK_plPromotionClusteredTS_KEY
3plPromotion_INDEX1NonclusteredSTART_DATE




Index
Table:[dbo].[plReminder]

Description
Reminder Table

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

Indexes
Sr.NameTypeColumns
1PK_plReminderClusteredREMINDER_NO




Index
Table:[dbo].[plRoster]

Description
Roster Table Header

Table Columns
Sr.NameDatatypeNullableDescription
1ROSTER_CODENCHAR(20)N
2AUTHORIZEDSMALLINTY
3DESCRIPTIONNVARCHAR(120)Y
4CREATE_BYCHAR(10)Y
5CREATE_DATEDATETIMEY
6LAST_UPDATE_BYCHAR(10)Y
7LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plRosterClusteredROSTER_CODE




Index
Table:[dbo].[plRosterD]

Description
Roster Table Details

Table Columns
Sr.NameDatatypeNullableDescription
1ROSTER_CODENCHAR(20)N
2ROSTER_DATESMALLDATETIMEN
3SHIFT_CODENCHAR(20)Y

Triggers
Sr.NameDescription
1plRosterD_Update_plATTD

Indexes
Sr.NameTypeColumns
1PK_plRosterDClusteredROSTER_CODE
ROSTER_DATE
2plRosterD_Index1NonclusteredSHIFT_CODE




Index
Table:[dbo].[plSETUP]

Description
HRPro Setup

Table Columns
Sr.NameDatatypeNullableDescription
1COMPANY_CODECHAR(2)N
2ER_TAX_NONVARCHAR(24)Y
3TAX_SNAMENVARCHAR(60)Y
4TAX_DESIGNATIONNVARCHAR(50)Y
5AUTOPAY_FILE_FORMATNCHAR(4)Y
6BANK_CODENCHAR(10)Y
7HSBC_ACCOUNT_CODENCHAR(24)Y
8HSBC_APC_NONVARCHAR(6)Y
9CITI_PCODENCHAR(6)Y
10CITI_ACNONCHAR(20)Y
11CITI_CLIDNCHAR(16)Y
12CITI_CLNAMNVARCHAR(40)Y
13DBS_BATNONCHAR(10)Y
14DBS_ACNONCHAR(30)Y
15DBS_ACNAMNCHAR(40)Y
16DBS_BATNAMNCHAR(50)Y
17SC_ACCOUNT_NONCHAR(28)Y
18BASIC_SALARY_ACCOUNT_NOCHAR(10)Y
19BANK_AUTOPAY_FILE_FORMATCHAR(1)Y
20AUTOPAY_ACCOUNT_NO1CHAR(20)Y
21AUTOPAY_ACCOUNT_NO2CHAR(20)Y
22AUTOPAY_ACCOUNT_NAMENVARCHAR(100)Y
23MPF_SP_CODENCHAR(20)Y
24MPF_EMPLOYER_IDNCHAR(40)Y
25MPF_PLAN_NONCHAR(40)Y
26MPF_BENEFIT_PLAN_NONCHAR(40)Y
27MPF_EMPLOYER_PARTICIPATIONNCHAR(40)Y
28MPF_SCHEME_REGISTRATION_NONCHAR(40)Y
29MPF_CONTACT_PERSONNVARCHAR(100)Y
30MPF_MINIMUMDECIMAL(18,2)Y
31MPF_MINIMUM_2011_11DECIMAL(18,2)Y
32MPF_MAXIMUMDECIMAL(18,2)Y
33MPF_MAXIMUM_2011_11DECIMAL(18,2)Y
34MPF_FIXED_AMTDECIMAL(18,2)Y
35MPF_FIXED_AMT_2011_11DECIMAL(18,2)Y
36MPF_MINIMUM_DAILYDECIMAL(18,2)Y
37MPF_MINIMUM_DAILY_2011_11DECIMAL(18,2)Y
38MPF_MAXIMUM_DAILYDECIMAL(18,2)Y
39MPF_MAXIMUM_DAILY_2011_11DECIMAL(18,2)Y
40MPF_ER_60D_RETENTIONSMALLINTY
41MPF_MID_MONTH_CONTRIBUTIONSMALLINTY
42OT_VISIBLESMALLINTY
43OT_WAGESMALLINTY
44OT_TAXSMALLINTY
45OT_MPFSMALLINTY
46OT_SMWSMALLINTY
47OT_CATCHAR(1)Y
48DEDUCTION_VISIBLESMALLINTY
49DEDUCTION_WAGESMALLINTY
50DEDUCTION_TAXSMALLINTY
51DEDUCTION_MPFSMALLINTY
52DEDUCTION_SMWSMALLINTY
53DEDUCTION_CATCHAR(1)Y
54ALLOWANCE_VISIBLESMALLINTY
55ALLOWANCE_WAGESMALLINTY
56ALLOWANCE_TAXSMALLINTY
57ALLOWANCE_MPFSMALLINTY
58ALLOWANCE_SMWSMALLINTY
59ALLOWANCE_CATCHAR(1)Y
60ALLOWANCE_DESCNVARCHAR(100)Y
61ALLOWANCE2_VISIBLESMALLINTY
62ALLOWANCE2_WAGESMALLINTY
63ALLOWANCE2_TAXSMALLINTY
64ALLOWANCE2_MPFSMALLINTY
65ALLOWANCE2_SMWSMALLINTY
66ALLOWANCE2_CATCHAR(1)Y
67ALLOWANCE2_DESCNVARCHAR(100)Y
68DOUBLEPAY_VISIBLESMALLINTY
69DOUBLEPAY_WAGESMALLINTY
70DOUBLEPAY_TAXSMALLINTY
71DOUBLEPAY_MPFSMALLINTY
72DOUBLEPAY_SMWSMALLINTY
73DOUBLEPAY_CATCHAR(1)Y
74BONUS_VISIBLESMALLINTY
75BONUS_WAGESMALLINTY
76BONUS_TAXSMALLINTY
77BONUS_MPFSMALLINTY
78BONUS_SMWSMALLINTY
79BONUS_CATCHAR(1)Y
80HOLIDAYPAY_VISIBLESMALLINTY
81HOLIDAYPAY_WAGESMALLINTY
82HOLIDAYPAY_TAXSMALLINTY
83HOLIDAYPAY_MPFSMALLINTY
84HOLIDAYPAY_SMWSMALLINTY
85HOLIDAYPAY_CATCHAR(1)Y
86ANNUALLEAVEPAY_VISIBLESMALLINTY
87ANNUALLEAVEPAY_WAGESMALLINTY
88ANNUALLEAVEPAY_TAXSMALLINTY
89ANNUALLEAVEPAY_MPFSMALLINTY
90ANNUALLEAVEPAY_SMWSMALLINTY
91ANNUALLEAVEPAY_CATCHAR(1)Y
92SICKNESSALLOWANCE_VISIBLESMALLINTY
93SICKNESSALLOWANCE_WAGESMALLINTY
94SICKNESSALLOWANCE_TAXSMALLINTY
95SICKNESSALLOWANCE_MPFSMALLINTY
96SICKNESSALLOWANCE_SMWSMALLINTY
97SICKNESSALLOWANCE_CATCHAR(1)Y
98MATERNITYLEAVEPAY_VISIBLESMALLINTY
99MATERNITYLEAVEPAY_WAGESMALLINTY
100MATERNITYLEAVEPAY_TAXSMALLINTY
101MATERNITYLEAVEPAY_MPFSMALLINTY
102MATERNITYLEAVEPAY_SMWSMALLINTY
103MATERNITYLEAVEPAY_CATCHAR(1)Y
104WAGES_IN_LIEU_VISIBLESMALLINTY
105PAY_TYPE1_VISIBLESMALLINTY
106PAY_TYPE1_DESCNVARCHAR(100)Y
107PAY_TYPE1_WAGESMALLINTY
108PAY_TYPE1_TAXSMALLINTY
109PAY_TYPE1_MPFSMALLINTY
110PAY_TYPE1_SMWSMALLINTY
111PAY_TYPE1_CATCHAR(1)Y
112PAY_TYPE2_VISIBLESMALLINTY
113PAY_TYPE2_DESCNVARCHAR(100)Y
114PAY_TYPE2_WAGESMALLINTY
115PAY_TYPE2_TAXSMALLINTY
116PAY_TYPE2_MPFSMALLINTY
117PAY_TYPE2_SMWSMALLINTY
118PAY_TYPE2_CATCHAR(1)Y
119PAY_TYPE3_VISIBLESMALLINTY
120PAY_TYPE3_DESCNVARCHAR(100)Y
121PAY_TYPE3_WAGESMALLINTY
122PAY_TYPE3_TAXSMALLINTY
123PAY_TYPE3_MPFSMALLINTY
124PAY_TYPE3_SMWSMALLINTY
125PAY_TYPE3_CATCHAR(1)Y
126PAY_TYPE4_VISIBLESMALLINTY
127PAY_TYPE4_DESCNVARCHAR(100)Y
128PAY_TYPE4_WAGESMALLINTY
129PAY_TYPE4_TAXSMALLINTY
130PAY_TYPE4_MPFSMALLINTY
131PAY_TYPE4_SMWSMALLINTY
132PAY_TYPE4_CATCHAR(1)Y
133PAY_TYPE5_VISIBLESMALLINTY
134PAY_TYPE5_DESCNVARCHAR(100)Y
135PAY_TYPE5_WAGESMALLINTY
136PAY_TYPE5_TAXSMALLINTY
137PAY_TYPE5_MPFSMALLINTY
138PAY_TYPE5_SMWSMALLINTY
139PAY_TYPE5_CATCHAR(1)Y
140PAY_TYPE6_VISIBLESMALLINTY
141PAY_TYPE6_DESCNVARCHAR(100)Y
142PAY_TYPE6_WAGESMALLINTY
143PAY_TYPE6_TAXSMALLINTY
144PAY_TYPE6_MPFSMALLINTY
145PAY_TYPE6_SMWSMALLINTY
146PAY_TYPE6_CATCHAR(1)Y
147PAY_TYPE7_VISIBLESMALLINTY
148PAY_TYPE7_DESCNVARCHAR(100)Y
149PAY_TYPE7_WAGESMALLINTY
150PAY_TYPE7_TAXSMALLINTY
151PAY_TYPE7_MPFSMALLINTY
152PAY_TYPE7_SMWSMALLINTY
153PAY_TYPE7_CATCHAR(1)Y
154PAY_TYPE8_VISIBLESMALLINTY
155PAY_TYPE8_DESCNVARCHAR(100)Y
156PAY_TYPE8_WAGESMALLINTY
157PAY_TYPE8_TAXSMALLINTY
158PAY_TYPE8_MPFSMALLINTY
159PAY_TYPE8_SMWSMALLINTY
160PAY_TYPE8_CATCHAR(1)Y
161PAY_TYPE9_VISIBLESMALLINTY
162PAY_TYPE9_DESCNVARCHAR(100)Y
163PAY_TYPE9_WAGESMALLINTY
164PAY_TYPE9_TAXSMALLINTY
165PAY_TYPE9_MPFSMALLINTY
166PAY_TYPE9_SMWSMALLINTY
167PAY_TYPE9_CATCHAR(1)Y
168USER01_VISIBLESMALLINTY
169USER01_NAMENVARCHAR(50)Y
170USER02_VISIBLESMALLINTY
171USER02_NAMENVARCHAR(50)Y
172USER03_VISIBLESMALLINTY
173USER03_NAMENVARCHAR(50)Y
174USER04_VISIBLESMALLINTY
175USER04_NAMENVARCHAR(50)Y
176USER05_VISIBLESMALLINTY
177USER05_NAMENVARCHAR(50)Y
178USER06_VISIBLESMALLINTY
179USER06_NAMENVARCHAR(50)Y
180USER07_VISIBLESMALLINTY
181USER07_NAMENVARCHAR(50)Y
182USER08_VISIBLESMALLINTY
183USER08_NAMENVARCHAR(50)Y
184USER09_VISIBLESMALLINTY
185USER09_NAMENVARCHAR(50)Y
186USER10_VISIBLESMALLINTY
187USER10_NAMENVARCHAR(50)Y
188USER11_VISIBLESMALLINTY
189USER11_NAMENVARCHAR(50)Y
190USER12_VISIBLESMALLINTY
191USER12_NAMENVARCHAR(50)Y
192USER13_VISIBLESMALLINTY
193USER13_NAMENVARCHAR(50)Y
194USER14_VISIBLESMALLINTY
195USER14_NAMENVARCHAR(50)Y
196USER15_VISIBLESMALLINTY
197USER15_NAMENVARCHAR(50)Y
198USER16_VISIBLESMALLINTY
199USER16_NAMENVARCHAR(50)Y
200USER17_VISIBLESMALLINTY
201USER17_NAMENVARCHAR(50)Y
202USER18_VISIBLESMALLINTY
203USER18_NAMENVARCHAR(50)Y
204USER19_VISIBLESMALLINTY
205USER19_NAMENVARCHAR(50)Y
206USER20_VISIBLESMALLINTY
207USER20_NAMENVARCHAR(50)Y
208GL_POSTING_BYNCHAR(2)Y
209PRORATED_BYNCHAR(2)Y
210PRORATED_INCLUDE_ALLOWANCE1SMALLINTY
211PRORATED_INCLUDE_ALLOWANCE2SMALLINTY
212SATURDAYNCHAR(2)Y
213ACCESS_BY_GROUPINTY
214WITH_PMSMALLINTY
215WITH_TMSMALLINTY
216WITH_LMSMALLINTY
217WITH_AMSMALLINTY
218WITH_WLSMALLINTY
219WITH_BASMALLINTY
220WITH_MESMALLINTY
221LEAVE_DECIMALINTY
222DAILY_RATE_DECIMALINTY
223NET_SALARY_DECIMALINTY
224MPF_DECIMALINTY
225ORSO_DECIMALINTY
226ERPRO_DATABASENVARCHAR(100)Y
227ENABLE2007EAOSMALLINTY
228USE_CURRENT_MONTH_WAGESMALLINTY
229CHECK_CALLNAME_DUPLICATIONSMALLINTY
230CHECK_HKID_DUPLICATIONSMALLINTY
231ATTENDANCE_IMPORT_FORMATSMALLINTY
232ENABLE_OT_CALCSMALLINTY
233ENABLE_PREPAID_BATCHSMALLINTY
234ZERO_AMOUNT_FOR_MIDMONTH_PAYROLLSMALLINTY
235FINALPAY_ADD_ALPAYSMALLINTY
236HOLIDAYPAY_3_MONTHSSMALLINTY
237NOPAYLEAVEPAY_BYCHAR(1)Y
238PRORATED_SALARY_USE_START_DATESMALLINTY
239USE_LEAVE_PERIOD_IN_EE_CLASSSMALLINTY
240OT_OVER_20SMALLINTY
241FINAL_PAYMENT_BASED_ON_CURRENT_MONTH_AVERAGE_WAGESSMALLINTY
242AUTO_ANNUAL_LEAVE_FORFEITURESMALLINTY
243RETAIN_DAYSSMALLINTY
244IGNORED_IMPORT_PERIOD_CHECKINGSMALLINTY
245ENABLE_LUNCH_OUTINSMALLINTY
246ENABLE_ATTD_MINIMUM_WAGE_CALCSMALLINTY
247CHECK_AL_BASED_ONCHAR(1)Y
248FULL_PAY_SICK_LEAVE_ENTITLEMENTSMALLINTY
249CASUAL_LEAVE_ENTITLEMENTSMALLINTY
250ACTUAL_AL_NEGLECT_3_MTHSSMALLINTY
251NOPAY_DAYS_FROM_LEAVE_MODULESMALLINTY
252EE_NAME_INCLUDE_SUROTHERNAMESMALLINTY
253EE_NAME_INCLUDE_CALLNAMESMALLINTY
254EE_NAME_INCLUDE_CHINESENAMESMALLINTY
255FIRST_YR_ROUND_UP_TO_INTSMALLINTY
256DEFAULT_PROBATION_PERIODSMALLINTY
257DISABLE_CROSS_LEAVE_PERIOD_CHECKINGSMALLINTY
258ENABLE_ADDITIONAL_AL_ENTITLEMENTSMALLINTY
259NAME_FOR_STANDARD_ALNVARCHAR(40)Y
260NAME_FOR_ADDITIONAL_ALNVARCHAR(40)Y
261ANNUAL_LEAVE_PAY_INCLUDED_ADDITIONAL_AL_BALANCESMALLINTY
262ENABLE_LEAVE_DAYS_OVERWRITESMALLINTY
263ENABLE_LEAVE_TIME_IN_LEAVE_ENTRYSMALLINTY
264LEAVE_DAYS_USE_REGULAR_FRACTIONSMALLINTY
265USE_REGULAR_HOURS_FOR_IN_OUT_TIMESMALLINTY
266USE_REGULAR_DAYS_FOR_DAILY_EESMALLINTY
267ENABLE_MULTIPLE_COST_CENTRESMALLINTY
268IN_OUT_TIME_CUT_0500SMALLINTY
269ALLOW_AMEND_SHIFT_CODESMALLINTY
270PAYSLIP_PRINTS_DAILY_RATESSMALLINTY
271PAYSLIP_PRINTS_ANNUAL_LEAVE_BALANCESMALLINTY
272WEBLEAVE_DECIMALINTY
273WEBLEAVE_DISALLOW_LEAVE_APPLICATION_WHEN_ZERO_BALANCESMALLINTY
274WEBLEAVE_SHOW_LEAVE_ADJUSTMENT_IN_LEAVE_HISTORYSMALLINTY
275WEBLEAVE_SHOW_LEAVE_ADJUSTMENT_IN_SUBORDINATE_LEAVE_HISTORYSMALLINTY
276WEBLEAVE_SHOW_COMPENSATION_LEAVE_BALANCESMALLINTY
277WEBLEAVE_SHOW_SICK_LEAVE_BALANCESMALLINTY
278WEBLEAVE_ANNUAL_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
279WEBLEAVE_SHOW_ALTERNATE_ANNUAL_LEAVE_BALANCESMALLINTY
280WEBLEAVE_ALTERNATE_ANNUAL_LEAVE_BALANCE_STATEMENTNVARCHAR(160)Y
281WEBLEAVE_SHOW_CURRENT_YEAR_TAKENSMALLINTY
282WEBLEAVE_CURRENT_YEAR_TAKEN_STATEMENTNVARCHAR(160)Y
283WEBLEAVE_ENABLE_ATTACHMENTSMALLINTY
284WEBLEAVE_ENABLE_HR_RECEIVES_APPROVED_REJECTED_EMAILSMALLINTY
285WEBLEAVE_MAKE_APPLY_LEAVE_AS_STARTUP_PAGESMALLINTY
286WEBLEAVE_ENABLE_CHINESESMALLINTY
287WEBLEAVE_REQUIRE_APPROVAL_FOR_BOTH_APPROVERSSMALLINTY
288EP_ENABLE_ATTENDANCE_RECORDSMALLINTY
289EP_ENABLE_UPDATE_PERSONAL_PARTICULARSSMALLINTY
290EP_APPROVE_UPP_BYNCHAR(20)Y
291EP_ENABLE_UPP_REPLY_BY_EMAILSMALLINTY
292EP_UPP_APPROVE_SUBJECTNVARCHAR(510)Y
293EP_UPP_APPROVE_CONTENTNVARCHAR(2048)Y
294EP_UPP_REJECT_SUBJECTNVARCHAR(510)Y
295EP_UPP_REJECT_CONTENTNVARCHAR(2048)Y
296EP_ENABLE_COMPANY_LIBRARYSMALLINTY
297EP_ENABLE_PHONE_LISTSMALLINTY
298EP_SHOW_POSITION_ON_PHONE_LISTSMALLINTY
299EP_ENABLE_SALARY_HISTORYSMALLINTY
300EP_SH_NO_OF_PERIODSMALLINTY
301EP_SHOW_PAYSLIP_REMARKS_ON_SALARY_DETAILSSMALLINTY
302EP_ENABLE_CHANGE_PASSWORDSMALLINTY
303EP_LOGINPAGE_MESSAGENVARCHAR(-1)Y
304EP_SHOW_SHIFT_CODE_ON_EVENT_CALENDARSMALLINTY
305EP_COMPANY_CALENDAR_SHOW_BIRTHDAYSMALLINTY
306EP_ENABLE_SUPERIOR_VIEW_SUBORDINATESMALLINTY
307EP_DISABLE_EMPLOYEE_PORTALSMALLINTY
308EP_ENABLE_UPDATE_ROSTERSMALLINTY
309CREATE_BYUDT_USERIDY
310CREATE_DATEUDT_DATESTAMPY
311LAST_UPDATE_BYUDT_USERIDY
312LAST_UPDATE_DATEUDT_DATESTAMPY

Triggers
Sr.NameDescription
1Tr_ChangeLog

Indexes
Sr.NameTypeColumns
1PK_plSETUPClusteredCOMPANY_CODE




Index
Table:[dbo].[plShift]

Description
Shift Code Table

Table Columns
Sr.NameDatatypeNullableDescription
1SHIFT_CODENCHAR(20)N
2AUTHORIZEDSMALLINTY
3DESCRIPTIONNVARCHAR(120)Y
4SHIFT_TYPECHAR(1)Y
5ENABLE_BOOK_TIMESMALLINTY
6IN_TIMECHAR(5)Y
7IN_TIME_BEFORESMALLINTY
8OUT_TIMECHAR(5)Y
9OUT_TIME_AFTERSMALLINTY
10LATE_TOLERANCESMALLINTY
11LT_ONLY_IF_OT_FOR_HRSDECIMAL(18,2)Y
12LATE_TOLERANCE2SMALLINTY
13LT2_ONLY_IF_OT_FOR_HRSDECIMAL(18,2)Y
14EARLY_OUT_TOLERANCESMALLINTY
15INCLUDE_LUNCH_HOURSMALLINTY
16PAY_LUNCH_BREAKSMALLINTY
17ENABLE_LUNCH_TIMESMALLINTY
18LUNCH_OUT_TIMECHAR(5)Y
19LUNCH_OUT_TOLERANCESMALLINTY
20LUNCH_OUT_SCAN_FROMCHAR(5)Y
21LUNCH_OUT_SCAN_TOCHAR(5)Y
22LUNCH_IN_TIMECHAR(5)Y
23LUNCH_IN_TOLERANCESMALLINTY
24LUNCH_IN_SCAN_FROMCHAR(5)Y
25LUNCH_IN_SCAN_TOCHAR(5)Y
26OT_MINIMUM_MINSSMALLINTY
27OT_MAXIMUM_HRSSMALLINTY
28OT_ALLOW_EARLYTIMESMALLINTY
29OT_TRUNCATETO_QUARTERSMALLINTY
30OT_PAY_INCLUDED_MINIMUM_MINSSMALLINTY
31WORK_HRSDECIMAL(18,2)Y
32LUNCH_HRSDECIMAL(18,2)Y
33LATE_DEDUCTIONSMALLINTY
34EARLYOUT_DEDUCTIONSMALLINTY
35EXCLUDE_EARLIER_THAN_IN_TIMESMALLINTY
36OT_HRS_BASE_ON_WORKED_HRSSMALLINTY
37LATE_IN_EXCLUDE_LATE_TOLERANCESMALLINTY
38EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCESMALLINTY
39ANNLEAVE_ASNCHAR(2)Y
40CREATE_BYCHAR(10)Y
41CREATE_DATEDATETIMEY
42LAST_UPDATE_BYCHAR(10)Y
43LAST_UPDATE_DATEDATETIMEY

Indexes
Sr.NameTypeColumns
1PK_plShiftClusteredSHIFT_CODE
2plShift_Index1NonclusteredSHIFT_TYPE




Index
Table:[dbo].[plTermnReason]

Description
Termination Reasons Table

Table Columns
Sr.NameDatatypeNullableDescription
1REASON_CODENCHAR(4)N
2TERMN_REASONNVARCHAR(160)Y
3CREATE_BYUDT_USERIDN
4CREATE_DATEUDT_DATESTAMPN
5LAST_UPDATE_BYUDT_USERIDY
6LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_PLTermReasonClusteredREASON_CODE




Index
Table:[dbo].[plTraining]

Description
Education History Table

Table Columns
Sr.NameDatatypeNullableDescription
1TS_KEYTIMESTAMPN
2EE_NONCHAR(20)N
3COURSE_NAMENVARCHAR(200)Y
4START_DATESMALLDATETIMEY
5END_DATESMALLDATETIMEY
6QUALIFICATIONNVARCHAR(200)Y
7MEMONVARCHAR(2048)Y
8PATHNVARCHAR(400)Y

Indexes
Sr.NameTypeColumns
1PK_plTrainingClusteredTS_KEY




Index
Table:[dbo].[plUser]

Description
Security by Employee Group User Table

Table Columns
Sr.NameDatatypeNullableDescription
1USERIDCHAR(10)N
2ALL_EESMALLINTY
3CREATE_BYUDT_USERIDN
4CREATE_DATEUDT_DATESTAMPN
5LAST_UPDATE_BYUDT_USERIDY
6LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plUserClusteredUSERID
2plUser_INDEX1NonclusteredALL_EE




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
1plUserRight_INDEX1NonclusteredEE_NO




Index
Table:[dbo].[plWORKHRS]

Description
Work Hours Table

Table Columns
Sr.NameDatatypeNullableDescription
1WORK_HRS_TYPENVARCHAR(10)N
2DESCRIPTIONNVARCHAR(100)Y
3IN_TIMECHAR(5)Y
4IN_TIME_BEFORESMALLINTY
5OUT_TIMECHAR(5)Y
6SAT_OUT_TIMECHAR(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_HOURSMALLINTY
14PAY_LUNCH_BREAKSMALLINTY
15ENABLE_LUNCH_TIMESMALLINTY
16LUNCH_OUT_TIMECHAR(5)Y
17LUNCH_OUT_TOLERANCESMALLINTY
18LUNCH_OUT_SCAN_FROMCHAR(5)Y
19LUNCH_OUT_SCAN_TOCHAR(5)Y
20LUNCH_IN_TIMECHAR(5)Y
21LUNCH_IN_TOLERANCESMALLINTY
22LUNCH_IN_SCAN_FROMCHAR(5)Y
23LUNCH_IN_SCAN_TOCHAR(5)Y
24OT_MINIMUM_MINSSMALLINTY
25OT_MAXIMUM_HRSSMALLINTY
26OT_ALLOW_EARLYTIMESMALLINTY
27OT_TRUNCATETO_QUARTERSMALLINTY
28OT_PAY_INCLUDED_MINIMUM_MINSSMALLINTY
29WORK_HRSDECIMAL(18,2)Y
30LUNCH_HRSDECIMAL(18,2)Y
31SAT_HRSDECIMAL(18,2)Y
32SATURDAY_OFFSMALLINTY
33LATE_DEDUCTIONSMALLINTY
34EARLYOUT_DEDUCTIONSMALLINTY
35SATURDAYNCHAR(2)Y
36EXCLUDE_EARLIER_THAN_IN_TIMESMALLINTY
37OT_HRS_BASE_ON_WORKED_HRSSMALLINTY
38LATE_IN_EXCLUDE_LATE_TOLERANCESMALLINTY
39EARLY_OUT_EXCLUDE_EARLY_OUT_TOLERANCESMALLINTY
40CREATE_BYUDT_USERIDN
41CREATE_DATEUDT_DATESTAMPN
42LAST_UPDATE_BYUDT_USERIDY
43LAST_UPDATE_DATEUDT_DATESTAMPY

Indexes
Sr.NameTypeColumns
1PK_plWORKHRSClusteredWORK_HRS_TYPE




Index
Table:[dbo].[RptControl]

Description
Report Control Table

Table Columns
Sr.NameDatatypeNullableDescription
1RptCodeCHAR(10)N
2RptNameNVARCHAR(120)N
3RptTableViewNVARCHAR(80)N
4RptExcelCHAR(1)Y
5RptFontNameVARCHAR(20)N
6RptFontSizeINTN
7RptOrientationNVARCHAR(20)N
8RptFitWidthCHAR(1)N
9RptZoomRatioINTN
10RptPaperSizeINTN
11RptCrystalRptNVARCHAR(40)Y
12RptSystemDateFormatCHAR(1)Y
13RptCopiesINTY
14RptGroupbyVARCHAR(10)Y
15RptTotalListVARCHAR(150)Y
16RptPageBreaksCHAR(3)Y
17RptDescriptionNTEXTY
18RptCRParaName1NVARCHAR(40)Y
19RptCRParaType1CHAR(3)Y
20RptCRParaName2NVARCHAR(40)Y
21RptCRParaType2CHAR(3)Y
22LAST_UPDATE_DATEUDT_DATESTAMPY
23AUTO_UPDATECHAR(1)Y
24RptStoredProcNVARCHAR(80)Y

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

Indexes
Sr.NameTypeColumns
1PK_RptControlClusteredRptCode




Index
Table:[dbo].[smCONTROL]

Description
System Manager Control Table

Table Columns
Sr.NameDatatypeNullableDescription
1DESCRIPTIONNVARCHAR(200)N
2VALIDATE_QUERYNVARCHAR(2048)Y
3FIX_QUERYNVARCHAR(2048)Y
4AUTHORIZEDUDT_BOOLEANN

Indexes
Sr.NameTypeColumns
1PK_smCONTROLClusteredDESCRIPTION