Entity YEEmployee

Description of Entity YEEmployee

This entity stores information about the employee. Some personal information like his/her address, name and date-of-birth. It also shows the flag rate for CPF and other wages. This entity is mainly for specific employees.


List of all Dependencies of the Entity YEEmployee

Name

Code

Class Name

Relation_114503

Relation_114503

Reference

Relation_108099

Relation_108099

Reference

Relation_108098

Relation_108098

Reference

Relation_108097

Relation_108097

Reference

Relation_108096

Relation_108096

Reference

Relation_180912

Relation_180912

Reference

Relation_1701911

Relation_1701911

Reference

Relation_1712993

Relation_1712993

Reference

Relation_1712994

Relation_1712994

Reference

Relation_109903

Relation_109903

Reference

Relation_121687

Relation_121687

Reference


List of Attributes of the Entity YEEmployee

Name

Code

PersonalSysId

PersonalSysId

YEYear

YEYear

Tax No

TaxNo

Designation

Designation

Address > Line 1 Block > House No

EEAddress1

Line 2 > Street Name

EEAddress2

Line 3 > Level No

EEAddress3

Unit No

EEAddress4

Type

EEAddressType

Country

EEAddressCountry

Postal Code

PostalCode

Full Name of Employee as per NRIC or FIN

EEName1

Full Name of Employee as per NRIC or FIN 2

EEName2

Full Name of Employee as per NRIC or FIN 3

EEName3

Date of Birth

DOB

Date of Commencement

Commencement

Date of Cessation or posted overseas

Cessation

Section45

IRASSection45

IR8SIndicator

IR8SIndicator

A8AIndicator

A8AIndicator

Flag100K

Flag100K

FlagPercentOrdWage

FlagPercentOrdWage

FlagOverseasCPF

FlagOverseasCPF

FlagExcessCPF

FlagExcessCPF

IRAS Nationality Code

IRASNationalityCode

Payee ID Type

PayeeIDType

Cessation Provision

CessationProvision

Description

MaritalStatusDesc

Gender

Gender

Using Global ID

CurrentYEGlobalId

SupYE Global ID

SupYEGlobalId

IR21Indicator

IR21Indicator

Last Changed Date Time

LastChangedDateTime

Nationality

NationalityDesc


Entity Attribute PersonalSysId of the Entity YEEmployee

Card of Attribute PersonalSysId of the Entity YEEmployee

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity YEEmployee

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute YEYear of the Entity YEEmployee

Card of Attribute YEYear of the Entity YEEmployee

Name

YEYear

Code

YEYear

Data Type

integer

Mandatory

Yes


Description of Attribute YEYear of the Entity YEEmployee

Shows the year. This holds the primary key for the YEEmployee table.
Example: 2012


Entity Attribute Tax No of the Entity YEEmployee

Card of Attribute Tax No of the Entity YEEmployee

Name

Tax No

Code

TaxNo

Data Type

char(20)

Mandatory

No


Description of Attribute Tax No of the Entity YEEmployee

Shows the tax number of the employee.


Entity Attribute Designation of the Entity YEEmployee

Card of Attribute Designation of the Entity YEEmployee

Name

Designation

Code

Designation

Data Type

char(30)

Mandatory

No


Description of Attribute Designation of the Entity YEEmployee

Displays the designation of the employee.
Example: Manager / Director etc


Entity Attribute Address > Line 1 Block > House No of the Entity YEEmployee

Card of Attribute Address > Line 1 Block > House No of the Entity YEEmployee

Name

Address > Line 1 Block > House No

Code

EEAddress1

Data Type

char(30)

Mandatory

No


Description of Attribute Address > Line 1 Block > House No of the Entity YEEmployee

Shows the block / house number of the employee.


Entity Attribute Line 2 > Street Name of the Entity YEEmployee

Card of Attribute Line 2 > Street Name of the Entity YEEmployee

Name

Line 2 > Street Name

Code

EEAddress2

Data Type

char(30)

Mandatory

No


Description of Attribute Line 2 > Street Name of the Entity YEEmployee

Shows the street name of the employee's address.


Entity Attribute Line 3 > Level No of the Entity YEEmployee

Card of Attribute Line 3 > Level No of the Entity YEEmployee

Name

Line 3 > Level No

Code

EEAddress3

Data Type

char(30)

Mandatory

No


Description of Attribute Line 3 > Level No of the Entity YEEmployee

Shows which level the employee is living on.


Entity Attribute Unit No of the Entity YEEmployee

Card of Attribute Unit No of the Entity YEEmployee

Name

Unit No

Code

EEAddress4

Data Type

char(30)

Mandatory

No


Description of Attribute Unit No of the Entity YEEmployee

Shows the unit number of the employee's address.


Entity Attribute Type of the Entity YEEmployee

Card of Attribute Type of the Entity YEEmployee

Name

Type

Code

EEAddressType

Data Type

char(20)

Mandatory

No


Description of Attribute Type of the Entity YEEmployee

Shows the type of address.
Example:
L = Local Residential Address
F = Foreign Address
C = C/O Address
N = No Address


Entity Attribute Country of the Entity YEEmployee

Card of Attribute Country of the Entity YEEmployee

Name

Country

Code

EEAddressCountry

Data Type

char(20)

Mandatory

No


Description of Attribute Country of the Entity YEEmployee

Shows the country of the address location.


Entity Attribute Postal Code of the Entity YEEmployee

Card of Attribute Postal Code of the Entity YEEmployee

Name

Postal Code

Code

PostalCode

Data Type

char(6)

Mandatory

No


Description of Attribute Postal Code of the Entity YEEmployee

Stores the postal code of the person's address.


Entity Attribute Full Name of Employee as per NRIC or FIN of the Entity YEEmployee

Card of Attribute Full Name of Employee as per NRIC or FIN of the Entity YEEmployee

Name

Full Name of Employee as per NRIC or FIN

Code

EEName1

Data Type

char(35)

Mandatory

No


Description of Attribute Full Name of Employee as per NRIC or FIN of the Entity YEEmployee

The first line for the employee's name.


Entity Attribute Full Name of Employee as per NRIC or FIN 2 of the Entity YEEmployee

Card of Attribute Full Name of Employee as per NRIC or FIN 2 of the Entity YEEmployee

Name

Full Name of Employee as per NRIC or FIN 2

Code

EEName2

Data Type

char(35)

Mandatory

No


Description of Attribute Full Name of Employee as per NRIC or FIN 2 of the Entity YEEmployee

The second line for the employee's address.


Entity Attribute Full Name of Employee as per NRIC or FIN 3 of the Entity YEEmployee

Card of Attribute Full Name of Employee as per NRIC or FIN 3 of the Entity YEEmployee

Name

Full Name of Employee as per NRIC or FIN 3

Code

EEName3

Data Type

char(10)

Mandatory

No


Description of Attribute Full Name of Employee as per NRIC or FIN 3 of the Entity YEEmployee

The third line for the employee's address.


Entity Attribute Date of Birth of the Entity YEEmployee

Card of Attribute Date of Birth of the Entity YEEmployee

Name

Date of Birth

Code

DOB

Data Type

date

Mandatory

No


Description of Attribute Date of Birth of the Entity YEEmployee

Stores the date of birth of the person.
It is in the format DD-MM-YYYY.


Entity Attribute Date of Commencement of the Entity YEEmployee

Card of Attribute Date of Commencement of the Entity YEEmployee

Name

Date of Commencement

Code

Commencement

Data Type

date

Mandatory

No


Description of Attribute Date of Commencement of the Entity YEEmployee

Shows when the employee's commencement was.
It is in the format: DD-MM-YYYY.


Entity Attribute Date of Cessation or posted overseas of the Entity YEEmployee

Card of Attribute Date of Cessation or posted overseas of the Entity YEEmployee

Name

Date of Cessation or posted overseas

Code

Cessation

Data Type

date

Mandatory

No


Description of Attribute Date of Cessation or posted overseas of the Entity YEEmployee

Shows the cessation date for the employee.
It is in the format: DD-MM-YYYY.


Entity Attribute Section45 of the Entity YEEmployee

Card of Attribute Section45 of the Entity YEEmployee

Name

Section45

Code

IRASSection45

Data Type

char(1)

Mandatory

No


Description of Attribute Section45 of the Entity YEEmployee

Indicates if the employee is under the iras section 45 - Non resident director and is withholding tax on the director's fee.
IRAS Section 45 is withholding tax as applied to partnerships. When someone makes a payment (Interest / Fees) to a non-resident person, he / she has to deduct a tax from the payment and pay that amount to IRAS.


Entity Attribute IR8SIndicator of the Entity YEEmployee

Card of Attribute IR8SIndicator of the Entity YEEmployee

Name

IR8SIndicator

Code

IR8SIndicator

Data Type

char(1)

Mandatory

No


Description of Attribute IR8SIndicator of the Entity YEEmployee

The IR8S indicator is to track if employees have made excess CPF contributions on their wages and will claim the refund for excess CPF contributions.


Entity Attribute A8AIndicator of the Entity YEEmployee

Card of Attribute A8AIndicator of the Entity YEEmployee

Name

A8AIndicator

Code

A8AIndicator

Data Type

char(1)

Mandatory

No


Description of Attribute A8AIndicator of the Entity YEEmployee

Shows if employees are provided with benefits-in-kind.


Entity Attribute Flag100K of the Entity YEEmployee

Card of Attribute Flag100K of the Entity YEEmployee

Name

Flag100K

Code

Flag100K

Data Type

char(1)

Mandatory

No


Description of Attribute Flag100K of the Entity YEEmployee

Shows a flag rate of 100,000 on its chargeable income regardless of whether it is in a local or foreign company.


Entity Attribute FlagPercentOrdWage of the Entity YEEmployee

Card of Attribute FlagPercentOrdWage of the Entity YEEmployee

Name

FlagPercentOrdWage

Code

FlagPercentOrdWage

Data Type

char(1)

Mandatory

No


Description of Attribute FlagPercentOrdWage of the Entity YEEmployee

Shows the flag percentage of the ordinary wage.


Entity Attribute FlagOverseasCPF of the Entity YEEmployee

Card of Attribute FlagOverseasCPF of the Entity YEEmployee

Name

FlagOverseasCPF

Code

FlagOverseasCPF

Data Type

char(1)

Mandatory

No


Description of Attribute FlagOverseasCPF of the Entity YEEmployee

Shows the overseas flag rate for CPF.


Entity Attribute FlagExcessCPF of the Entity YEEmployee

Card of Attribute FlagExcessCPF of the Entity YEEmployee

Name

FlagExcessCPF

Code

FlagExcessCPF

Data Type

char(1)

Mandatory

No


Description of Attribute FlagExcessCPF of the Entity YEEmployee

Shows if the flag rate exceeds CPF.


Entity Attribute IRAS Nationality Code of the Entity YEEmployee

Card of Attribute IRAS Nationality Code of the Entity YEEmployee

Name

IRAS Nationality Code

Code

IRASNationalityCode

Data Type

char(20)

Mandatory

No


Description of Attribute IRAS Nationality Code of the Entity YEEmployee

Shows the nationality code of each country.
Example:
Australia = "701"
New Zealand = "705"
Taiwan = "334"
etc


Entity Attribute Payee ID Type of the Entity YEEmployee

Card of Attribute Payee ID Type of the Entity YEEmployee

Name

Payee ID Type

Code

PayeeIDType

Data Type

char(1)

Mandatory

No


Description of Attribute Payee ID Type of the Entity YEEmployee

Shows the identity type of the payee. It refers to the Organisation ID type.
Example:
UEN = Unique Entity Number (UEN) - Business
ASGD = Tax Reference number assigned by IRAS
CRN = Central Registration number issued by Ministry of Trade & Industries
etc


Entity Attribute Cessation Provision of the Entity YEEmployee

Card of Attribute Cessation Provision of the Entity YEEmployee

Name

Cessation Provision

Code

CessationProvision

Data Type

char(1)

Mandatory

No


Description of Attribute Cessation Provision of the Entity YEEmployee

Indicates if the employee is under cessation provision, in a form of a checkbox.
Cessation provisions are applicable to those employees who commenced work with a company before 1 January 1969 and stopped thereafter. It involves the adjustment of income to certain basis period of assessment.
If the employee commenced work before 1 January 1969 and ceased work in the current tax year, the indicator will be ticked.
If the employee commenced work after 1 January 1969 and ceased work in the current tax year, the indicator will be unticked.


Entity Attribute Description of the Entity YEEmployee

Card of Attribute Description of the Entity YEEmployee

Name

Description

Code

MaritalStatusDesc

Data Type

char(60)

Mandatory

No


Description of Attribute Description of the Entity YEEmployee

This attribute holds the description or long name for the marital status code.
Example: Married / Divorced / Widower


Entity Attribute Gender of the Entity YEEmployee

Card of Attribute Gender of the Entity YEEmployee

Name

Gender

Code

Gender

Data Type

char(1)

Mandatory

No


Description of Attribute Gender of the Entity YEEmployee

Shows the gender of the family member.
Example: Male = "1". Female = "0".


Entity Attribute Using Global ID of the Entity YEEmployee

Card of Attribute Using Global ID of the Entity YEEmployee

Name

Using Global ID

Code

CurrentYEGlobalId

Data Type

char(20)

Mandatory

No


Description of Attribute Using Global ID of the Entity YEEmployee

Shows the global identity for the current year end.


Entity Attribute SupYE Global ID of the Entity YEEmployee

Card of Attribute SupYE Global ID of the Entity YEEmployee

Name

SupYE Global ID

Code

SupYEGlobalId

Data Type

char(20)

Mandatory

No


Description of Attribute SupYE Global ID of the Entity YEEmployee

Shows the global identity for the year end.


Entity Attribute IR21Indicator of the Entity YEEmployee

Card of Attribute IR21Indicator of the Entity YEEmployee

Name

IR21Indicator

Code

IR21Indicator

Data Type

char(1)

Mandatory

No


Description of Attribute IR21Indicator of the Entity YEEmployee

Shows the tax clearance.


Entity Attribute Last Changed Date Time of the Entity YEEmployee

Card of Attribute Last Changed Date Time of the Entity YEEmployee

Name

Last Changed Date Time

Code

LastChangedDateTime

Data Type

timestamp

Mandatory

No


Description of Attribute Last Changed Date Time of the Entity YEEmployee

Stores the date and time of when the previous changes were made.


Entity Attribute Nationality of the Entity YEEmployee

Card of Attribute Nationality of the Entity YEEmployee

Name

Nationality

Code

NationalityDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Nationality of the Entity YEEmployee

Stores the nationality of the employee.