PNSR Record Layout and Data Dictionary (updated 6/17/13)
Changes are highlighted in yellow
Data Element Name(s)	Description	Data Element Format	Valid Values	
npi_num	National Practitioner Identifier (NPI) 
Multiple occurrences of same NPI occurrences are possible the provider has more than one account with L&I or if they participate in any special program(s).	BIGINT(10) 		
prvdr_id	The Provider ID is the unique L&I provider account number assigned to this provider’s practice location.	VarChar (9)		
full_prvdr_name	Provider name	VarChar(31)		
first_name	Provider  first name 	VarChar(20)		
middle_name	Provider middle initial	VarChar(1)		
last_name	Provider last name	VarChar(40)		
prvdr_type_code	The provider type code displayed is L&I’s provider type code.	VarChar (2) 	See “Definitions Look-up Table” for Values.	
prvdr_specty_code	The provider specialty code displayed is L&I’s specialty codes.  These codes do not currently match Specialty Taxonomy Codes.	VarChar (2)	See “Definitions Look-up Table” for Values.	
program_code	The program code is used to indicate one of two things:
1.	the provider’s network status
(N Codes)
2.	any special programs the provider is enrolled in with L&I.
Will retain history even if status in “payment code” changes.	VarChar (3)	See “Definitions Look-up Table” in the “Network Codes” or “Program Codes” tabs for Values.	
program_beg_date	The begin date is the date the network status or program code was effective for the provider’s account.	Date (mm/dd/yyyy)		
program_end_date	The end date is the date the network status or program code was ended for the provider’s account.	Date (mm/dd/yyyy)		
payment_code	The payment code is added to SIE_Extract_V2 and is used to indicate the provider’s network status for payment purposes.   Payment code will be same as “program code” until statuses N07 or N08 are attained and retroactively applied to earlier date.	VarChar (3)	See “Definitions Look-up Table” in the “Network Codes” tab for Values.	

Provider Type and Specialty Table (codes and descriptions)
Please see the “Definitions Look-Up Table” on the Provider Network Status Report webpage for Provider Type, Specialty and Valid Type-Specialty Combinations. 
Record Layout and Data Dictionary Change History	
Date	Change	Note	
10/5/2012	•	Program Code “Data Element Format” changed from VarChar (2) to (3)

•	Addition of Type 40 (Nurse), Specialty 36 (Psychiatric) for Psychiatric ARNPs (see bottom of page 5).

This content removed from this document; see 12/27/2012 change below.	
12/27/2012	Deleted Provider Types and Specialties from this document- Referred to “Definitions Look-Up Table” on PNSR webpage	To reduce number of documents needing updates when changes occur.	
12/27/2012	Added “Change History” section.		
6/17/2013	•	Added new “Description” content for “Program Code”
•	Added new “Payment_code” field to end of record
•	Added informational reference to “Definitions Look-Up Table” in “Valid Values” column.	

“Payment code” column will be added to enhanced version (SIE_Extract_V2) of PNSR in June 2013