PowerSchool ERP Missouri

OASIS Report - File Layout And Data Mapping - Employer Reporting - Demographic Details (Record Type 222)

The following table shows the positions, position names, descriptions, and data sources or valid values for the Demographic Details record (Type 222) in the Employer Reporting file.

Position

Position Name

Description

Data Source or Valid Values

1

Record Type

Identifies the record type.

The valid value is 222.

2

SSN

The employee's Social Security number.

Retrieved from the Social Security Number field on the General tab of the MO OASIS Report - Enrollment page.

3

Last Name

The employee's last name.

Retrieved from the Last Name field on the Demographic tab of the MO OASIS Report - Enrollment page.

4

First Name

The employee’s first name.

Retrieved from the First Name field on the Demographic tab of the MO OASIS Report - Enrollment page.

5

Middle Name

The employee's middle name.

Retrieved from the Middle Name field on the Demographic tab of the MO OASIS Report - Enrollment page.

6

Name Suffix

The employee’s name suffix.

Retrieved from the Suffix field on the Demographic tab of the MO OASIS Report - Enrollment page.

7

Address Line 1

The first line of the employee's address. 

Retrieved from the Address 1 field on the Demographic tab of the MO OASIS Report - Enrollment page.

8

Address Line 2

The second line of the employee's address. 

Retrieved from the Address 2 field on the Demographic tab of the MO OASIS Report - Enrollment page.

9

Suite

The suite or apartment number of the employee's mailing address, if applicable.

Retrieved from the Suite field on the Demographic tab of the MO OASIS Report - Enrollment page.

10

City

The employee's city of residence. 

Retrieved from the City field on the Demographic tab of the MO OASIS Report - Enrollment page.

11

State

The employee's state of residence. 

Retrieved from the State field on the Demographic tab of the MO OASIS Report - Enrollment page.

12

Zip Code (5)

The employee's zip code. 

Retrieved from positions 1-5 of the Zip Code field on the Demographic tab of the MO OASIS Report - Enrollment page.

13

Zip+4

The employee's zip code extension. 

Retrieved from positions 7-10 of the Zip Code field on the Demographic tab of the MO OASIS Report - Enrollment page.

14

Birth Date

The employee's date of birth. 

Retrieved from the Date of Birth field on the General tab of the MO OASIS Report - Enrollment page.