DATA ORGANIZATION

KEY FIELD

WHAT IS KEY FIELD

• A Key Field or Primary Key is the field in a record that uniquely identifies each record

EXAMPLE OF KEY SECURITY

1. Social Security Number
2. Student Identification Numbers
3. Employee Identification Numbers
4. National Identification Numbers

How Social Security Numbers Work

• As each SSN is unique, the number's initial record-keeping role for the worker and the government to track Social Security entitlements, broadened.
• The nine-digits of the SSN are divided into three parts, each separated by a hyphen. 
• The first three digits, the area numbers, are based upon the zip code in the applicant's mailing address on the original application form. 
• The second two numbers are the group numbers, ranging from 01 to 99, which serve to break the SSNs with the same area numbers into more manageable blocks. 
• The final four digits of the SSN, the serial numbers, run consecutively from 0001 to 9999 within each group designation.

SOICIAL SECURITY IN MALAYSIA

The Social Security Organization (SOCSO) provides social security protection by social insurance including medical and cash benefits, provision of artificial aids and rehabilitation to employees to reduce the sufferings and to provide financial guarantees and protection to the family.

 STUDENT IDENTIFICATION NUMBERS 

                A student number is the number assigned to a student upon first entering or registering with an educational institution and is used to identify the student in lieu of a name for grades, essays, projects, exams and official documents.

               For Universiti Teknologi Malaysia (UTM)students their Matrix Card start with 'A' for undergraduate intake student but for direct intake student start with 'B'. H for Degree student. Master student's matrix card number start with 'M'. For UTMKL student their matrix number starte with AD, D for Diploma student.

              For example, BH100063; B for direct intake student; H for Degree; 10  for Academic Year when the number was issued, it refer to 2010; last 4 digit is refer to individual number issued in the order of enrollment.

EMPLOYEE IDENTIFICATION NUMBERS

An Employer Identification Number (EIN) is a nine-digit number that IRS assigns in the following format:

XX-XXXXXXX. It is used to identify the tax accounts of employers and certain others who have no employees. However, for employee plans, an alpha (for example, P) or the plan number (e.g., 003) may follow the EIN. 

The IRS uses the number to identify taxpayers that are required to file various business tax returns. EINs are used by employers, sole proprietors, corporations, partnerships, non-profit associations, trusts, estates of decedents, government agencies, certain individuals, and other business entities. 

NATIONAL IDENTIFICATION NUMBER

            In Malaysia, a 12-digit number (format: YYMMDD-SS-###G, since 1991) known as the National Registration Identification Card Number (NRIC No.) is issued to citizens and permanent residents on a MyKad. Prior to January 1, 2004, a separate social security (SOCSO) number (also the old IC number in format 'S#########', S denotes state of birth or country of origin (alphabet or number), # is a 9-digit serial number) was used for social security-related affairs.

           The first group of numbers (YYMMDD) are the date of birth. The second group of numbers (SS) represents the place of birth of the holder - the states (01-13), the federal territories (14-16) or the country of origin (60-85) . The last group of numbers (###G) is a serial number in an unidentified pattern which is randomly generated. The last digit (G) is an odd number for a male, while an even number is given for a female. For example 890123-03-7889; indicate that he born in 23 January 1989, in Kelantan, last digit represent that he is male.