List of properties

Entity MYPayrollData
Key property ID


Property starting with A
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Amount Amount Amount Number Amount

Property starting with B
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
BirthDate Date BirthDate

Property starting with C
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
CarAcquiredDate Car acquisition date Car acquisition date Date CarAcquiredDate
CarModel Car model Car model String CarModel
CarYear Car year Car year Number CarYear
CompanyCode String CompanyCode
CostCenter String CostCenter
CountryCode Country Country String CountryCode
CP22AEsosBalance Baki yang belum dilaksana Baki yang belum dilaksana Number CP22AEsosBalance
CP22AEsosEligibleShareAmt Jumlah saham layak Jumlah saham layak Number CP22AEsosEligibleShareAmt
CP22AEsosOptDate Tarikh opsyen diberi Tarikh opsyen diberi Date CP22AEsosOptDate
CP22AEsosSkim Jenis skim Jenis skim String CP22AEsosSkim
CP22AExtraPay Jumlah bayaran Jumlah bayaran Number CP22AExtraPay
CP22AExtraPayDate Tarikh pembayaran Tarikh pembayaran Date CP22AExtraPayDate
CP22AExtraPayType Jenis pembayaran Jenis pembayaran String CP22AExtraPayType
CP22APayOnHold Wang yang ditahan Wang yang ditahan Number CP22APayOnHold
CreatedDate Date CreatedDate
Creator Number Creator
CreatorName String CreatorName
CreditorNumber String CreditorNumber

Property starting with E
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
EmploymentStart Date EmploymentStart
EndDate Date EndDate

Property starting with F
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
FirstHalfPaymentMethod First half salary First half salary String FirstHalfPaymentMethod

Property starting with I
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ID Number ID

Property starting with M
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ModifiedDate Date ModifiedDate
Modifier Number Modifier
ModifierName String ModifierName

Property starting with N
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
NumberOfChildren Number of children Number of children Number NumberOfChildren

Property starting with P
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
PaymentPeriod Payment period Payment period String PaymentPeriod
PayrollYear Year Year String PayrollYear
Percentage Percentage Percentage Number Percentage
Period Period Period Number Period
PreviousEmployer Previous employer Previous employer String PreviousEmployer

Property starting with R
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ResourceCostCenter Cost center Cost center String ResourceCostCenter
ResourceID Resource Resource Number ResourceID
ResourceName String ResourceName

Property starting with S
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
SocialSecurityNumber String SocialSecurityNumber
SocsoScheme Socso scheme Socso scheme String SocsoScheme
StartDate Date StartDate

Property starting with T
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
TaxBranch Tax branch Tax branch String TaxBranch
TaxBranchSpouse Tax branch - Spouse Tax branch - Spouse String TaxBranchSpouse
TaxCategory Tax category Tax category String TaxCategory
TaxExemptionFrom Tax exemption from Tax exemption from Date TaxExemptionFrom
TaxExemptionTo to to Date TaxExemptionTo

Detail information of properties

Property starting with A
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Amount Amount Number 11 2

Property starting with B
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
BirthDate BirthDate Date 8 0

Property starting with C
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
CarAcquiredDate CarAcquiredDate Date 8 0
CarModel CarModel String 30 0
CarYear CarYear Number 4 0
CompanyCode CompanyCode String 3 0
CostCenter CostCenter String 8 0
CountryCode CountryCode String 3 0 MY
CP22AEsosBalance CP22AEsosBalance Number 11 2
CP22AEsosEligibleShareAmt CP22AEsosEligibleShareAmt Number 11 2
CP22AEsosOptDate CP22AEsosOptDate Date 8 0
CP22AEsosSkim CP22AEsosSkim String 30 0
CP22AExtraPay CP22AExtraPay Number 11 2
CP22AExtraPayDate CP22AExtraPayDate Date 8 0
CP22AExtraPayType CP22AExtraPayType String 30 0
CP22APayOnHold CP22APayOnHold Number 11 2
CreatedDate Created Date 0 0 NOW
Creator Creator Number 10 0 HUMRESID
CreatorName CreatorName String 64 0
CreditorNumber CreditorNumber String 6 0

Property starting with E
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
EmploymentStart EmploymentStart Date 8 0
EndDate EndDate Date 0 0

Property starting with F
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
FirstHalfPaymentMethod FirstHalfPaymentMethod String 1 0 P
P,8466,Percentage
A,4182,Amount

Property starting with I
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ID ID Number 10 0

Property starting with M
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ModifiedDate Modified Date 0 0 NOW
Modifier Modifier Number 10 0 HUMRESID
ModifierName ModifierName String 64 0

Property starting with N
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
NumberOfChildren NumOfChildren Number 5 2 0

Property starting with P
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
PaymentPeriod PaymentPeriod String 1 0 M
M,24003,Monthly
S,0,Semi-monthly
B,30355,Bi-weekly
W,24228,Weekly
PayrollYear PayrollYear String 4 0 select stringvalue from settings where settingname='lnjr_std'
2004,0,2004
Percentage Percentage Number 8 4
Period Period Number 3 0 SELECT TOP 1 LTRIM(per_fin) FROM perdat WHERE bgdatum <= GETDATE() AND eddatum >=GETDATE()
1,0, 1
2,0, 2
3,0, 3
4,0, 4
5,0, 5
6,0, 6
7,0, 7
8,0, 8
9,0, 9
10,0, 10
11,0, 11
12,0, 12
PreviousEmployer PreviousEmployer String 30 0

Property starting with R
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ResourceCostCenter ResourceCostCenter String 8 0
ResourceID ResourceID Number 10 0
ResourceName ResourceName String 64 0

Property starting with S
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
SocialSecurityNumber SocialSecurityNumber String 50 0
SocsoScheme SocsoScheme String 1 0 E
E,0,Employment injury & invalidity
I,0,Employment injury only
StartDate StartDate Date 0 0

Property starting with T
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
TaxBranch TaxBranch String 2 0
,0,
AS,0,Alor Setar
BI,0,Bintulu
BM,0,Bukit Mertajam
CH,0,Cheras
DU,0,Jalan Duta
IP,0,Ipoh
JB,0,Johor Bahru
KP,0,Kg. Attap
KB,0,Kota Bharu
KC,0,Kuching
KA,0,Kluang
KK,0,Kota Kinabalu
KG,0,Klang
KN,0,Kuantan
KR,0,Kangar
KT,0,Kuala Terengganu
KE,0,Keningau
LA,0,Labuan
ME,0,Melaka
MR,0,Miri
MU,0,Muar
PJ,0,Petaling Jaya
PP,0,Pulau Pinang
RB,0,Raub
SI,0,Sibu
SD,0,Sandakan
SA,0,Shah Alam
SP,0,Sungai Petani
SR,0,Seremban
SY,0,Syarikat
TP,0,Taiping
TW,0,Tawau
TI,0,Teluk Intan
TM,0,Temerloh
TB,0,Tidak bermastatin
WM,0,Wangsa Maju
TaxBranchSpouse TaxBranchSpouse String 2 0
,0,
AS,0,Alor Setar
BI,0,Bintulu
BM,0,Bukit Mertajam
CH,0,Cheras
DU,0,Jalan Duta
IP,0,Ipoh
JB,0,Johor Bahru
KP,0,Kg. Attap
KB,0,Kota Bharu
KC,0,Kuching
KA,0,Kluang
KK,0,Kota Kinabalu
KG,0,Klang
KN,0,Kuantan
KR,0,Kangar
KT,0,Kuala Terengganu
KE,0,Keningau
LA,0,Labuan
ME,0,Melaka
MR,0,Miri
MU,0,Muar
PJ,0,Petaling Jaya
PP,0,Pulau Pinang
RB,0,Raub
SI,0,Sibu
SD,0,Sandakan
SA,0,Shah Alam
SP,0,Sungai Petani
SR,0,Seremban
SY,0,Syarikat
TP,0,Taiping
TW,0,Tawau
TI,0,Teluk Intan
TM,0,Temerloh
TB,0,Tidak bermastatin
WM,0,Wangsa Maju
TaxCategory TaxCategory String 1 0 1
1,0,Category 1 - Single
2,0,Category 2 - Married and spouse not working
3,0,Category 3 - Married and both are working
TaxExemptionFrom TaxExcemptionFrom Date 8 0
TaxExemptionTo TaxExcemptionTo Date 8 0

List of obsolete properties
There is no obsolete property