PowerSchool ERP Louisiana
PowerSchool ERP Louisiana
Breadcrumbs

LA Unique Id - File Layout and Data Mapping - Detail Record

The detail records should appear between the header and trailer records.

Each field should be delimited, even if data is not available for a specific field.

The following table shows the column letters, names, descriptions, data types, whether used for matching, data sources or valid values, and whether the field is required or optional for the LA Unique Id upload file’s detail record.

Column Letter

Column Name

Description

Data Type

Used for Matching?

Data Source or Valid Values

Required?

A

Record Type

Identifies the record type.

Char (2)

Not applicable

The valid value is ID.

Required

B

School/Site Code

The employee’s site code.

Char(6)

No

The valid value is a concatenation of the following field values:

Required

C

Residing District Code

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

D

Last Name

The employee's last name.

VarChar(60)

Yes

Retrieved from the Last Name field on the Employee Information page.

Required

E

First Name

The employee’s first name.

VarChar(60)

Yes

Retrieved from the First Name field on the Employee Information page.

Required

F

Middle Name

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

G

Name Suffix

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

H

Gender

The employee's gender. 

Char(1)

Yes

Valid values:

  • F = Female

  • M = Male

Retrieved from the Sex at Birth field on the Employee Information page.

Required

I

Date of Birth

The employee's date of birth. 

The format can be:

  • mm/dd/yyyy

  • m/d/yyyy

  • mm/d/yyyy

  • m/dd/yyyy

  • yyyy-mm-dd

VarChar(10)

Yes

Retrieved from the Birthdate field on the Employee Information page.

Required

J

Grade Placement

The state-defined Grade Level code.

Char(2)

No

For a list of valid values, refer to the ENTRY_GRADE_CODE section in the Louisiana Department of Education - User Guide for Creating and Loading - Extract Files for Student Data.

Retrieved from the Grade Level section on the Assignments page.

Required

K

Student Local ID Number

The employee’s identification (ID) number.

VarChar(20)

No

Retrieved from the Employee Number field on the Employee Information page.

Required

L

Social Security Number

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

M

Race/Ethnicity

The race or ethnicity of the employee.

Char(6)

No

The Race/Ethnicity codes represent the Hispanic Indicator and five race codes. The position of the Hispanic Indicator and the five race codes is fixed. For each position, indicate N=No and Y=Yes as follows:

  • 1st Position: HI7 - Hispanic Indicator

  • 2nd Position: AM7 - American Indian or Alaskan Native Indicator

  • 3rd Position: AS7- Asian Indicator

  • 4th Position: BL7 - Black Indicator

  • 5th Position: PI7 - Native Hawaiian or Other Pacific Islander indicator

  • 6th Position: WH7 - White Indicator

Retrieved from the Race/Ethnicity tab of the Employee Information page.

Required

N

State ID/Unique ID

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

O

LEA Code

LEA / Sponsor code assigned by LDOE

Char(3)

No

The valid value is the last three digits of the Employer TRSL ID on the Human Resources Profile - State page.

Required

P

Ending School Session Year

The ending year of the school session.

The format is YYYY.

For example, the ending school session year for the school year 7/1/2025 - 6/30/26 is 2026.

Char(4)

No

Not applicable

Required

Q

Alternate Last Name

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

R

Alternate ID

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

S

Alternate Source

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

T

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

U

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

V

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

W

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

X

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

Y

LWC CONSENT FLAG

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

Z

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

AA

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

AB

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

AC

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

AD

Parental Consent Flag

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

AE

RESERVED

This field is not used and should be left blank.

VarChar(4)

No

Not applicable

Not required

AF

RESERVED

This field is not used and should be left blank.

VarChar(10)

No

Not applicable

Not required

AG

RESERVED

This field is not used and should be left blank.

VarChar(10)

No

Not applicable

Not required

AH

RESERVED

This field is not used and should be left blank.

VarChar(10)

No

Not applicable

Not required

AI

RESERVED

This field is not used and should be left blank.

VarChar(10)

No

Not applicable

Not required

AJ

RESERVED

This field is not used and should be left blank.

VarChar(10)

No

Not applicable

Not required

AK

RESERVED

This field is not used and should be left blank.

Varchar(60)

No

Not applicable

Not required

AL

RESERVED

This field is not used and should be left blank.

Varchar(100)

No

Not applicable

Not required

AM

RESERVED

This field is not used and should be left blank.

VarChar(60)

No

Not applicable

Not required

AN

RESERVED

This field is not used and should be left blank.

VarChar(50)

No

Not applicable

Not required

AO

Street Address (Physical)

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

AP

Street Address 2 (Physical)

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

AQ

City (Physical)

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

AR

State (Physical)

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

AS

Zip Code (Physical)

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

AT

RESERVED

This field is not used and should be left blank.

VarChar(22)

No

Not applicable

Not required

AU

RESERVED

This field is not used and should be left blank.

VarChar(20)

No

Not applicable

Not required

AV

RESERVED

This field is not used and should be left blank.

VarChar(20)

No

Not applicable

Not required

AW

RESERVED

This field is not used and should be left blank.

VarChar(20)

No

Not applicable

Not required

AX

RESERVED

This field is not used and should be left blank.

VarChar(20)

No

Not applicable

Not required

AY

RESERVED

This field is not used and should be left blank.

VarChar(125)

No

Not applicable

Not required

AZ

RESERVED

This field is not used and should be left blank.

VarChar(25)

No

Not applicable

Not required

BA

RESERVED

This field is not used and should be left blank.

VarChar(20)

No

Not applicable

Not required

BB

RESERVED

This field is not used and should be left blank.

VarChar(2)

No

Not applicable

Not required

BC

Submission Purpose

The purpose of the submission.

Char(3)

No

The valid value is 001.

Required

BD

Person Type

The current person type of the individual.

Char(2)

No

Valid values:

  • 01 = Early Childhood

  • 02 = Public/Charter K-12

  • 04 = HomeSchool

  • 05 = Non-Public

Required

BE

Location Active Flag

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

BF

RESERVED

This field is not used and should be left blank.

VarChar(100)

No

Not applicable

Not required

BG

RESERVED

This field is not used and should be left blank.

date

No

Not applicable

Not required

BH

RESERVED

This field is not used and should be left blank.

Varchar(2)

No

Not applicable

Not required

BI

RESERVED

This field is not used and should be left blank.

VarChar(100)

No

Not applicable

Not required

BJ

RESERVED

This field is not used and should be left blank.

Varchar(1)

No

Not applicable

Not required

BK

RESERVED

This field is not used and should be left blank.

datetime

No

Not applicable

Not required

BL

RESERVED

This field is not used and should be left blank.

Numeric (10.2)

No

Not applicable

Not required

BM

RESERVED

This field is not used and should be left blank.

Varchar(25)

No

Not applicable

Not required

BN

RESERVED

This field is not used and should be left blank.

Varchar(100)

No

Not applicable

Not required

BO

RESERVED

This field is not used and should be left blank.

VarChar(100)

No

Not applicable

Not required

BP

RESERVED

This field is not used and should be left blank.

VarChar(100)

No

Not applicable

Not required

BQ

RESERVED

This field is not used and should be left blank.

VarChar(100)

No

Not applicable

Not required

BR

Active Location Count

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

BS

RESERVED

This field is not used and should be left blank.

datetime

No

Not applicable

Not required

BT

Match Score

This field is not required.

Not applicable

Not applicable

Not applicable

Not required

BU

ID Record Status

This field is not required.

Not applicable

Not applicable

Not applicable

Not required