PCODESDTL – Contains contact information detail (address and phone number) for specific types of PCODES.

System: Human Resources (HR)
Prefix: PDD
Primary key: TYPE, CODE
Fields: 41
Updated by: 96 programs
Referenced by: 100 programs

PCODESDTL is the Contains contact information detail (address and phone number) for specific types of PCODES. table in Lawson Human Resources (prefix PDD). It is indexed by TYPE, CODE (PDDSET1); alternate indexes: PDDSET2. It is related 1:1 to PCODES, INSTCTRYCD and PCODESTYPE and 1:M to PRTAXAUTH. It is updated by HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 and 88 more and referenced by BN106, BN150, BN305, BN66.1, EXI2.1, EXI3.1, EXI4.1, HR11.1 and 92 more. The table has 41 fields, 2 indexes and 7 documented relations.

About PCODESDTL

Contains contact information detail (address and phone number) for specific types of PCODES.

Fields (41)

Column = COBOL field name without the PDD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PDD-TYPE` PK TYPE	Alpha 2	Indicates whether code is establishment, hospital, or physician.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-CODE` PK CODE	Alpha 10	Contains the code.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-CONTACT-LAST` CONTACT_LAST	Alpha 30 (Lower Case)	Contains the last name of the contact person.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-CONTACT-FIRST` CONTACT_FIRST	Alpha 15 (Lower Case)	Contains the first name of the contact person.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-CONTACT-MI` CONTACT_MI	Alpha 1	Contains the middle initial of the contact person.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-ADDR1` ADDR1	Alpha 57 (Lower Case)	This field contains the first line of address information.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-ADDR2` ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-ADDR3` ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	HR04.9
`PDD-ADDR4` ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	HR04.9
`PDD-CITY` CITY	Alpha 58 (Lower Case)	This field contains the city of the address.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-STATE` STATE	Alpha 2	This field contains the two-character state code of the address.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-ZIP` ZIP	Alpha 10	This field contains the postal code of the address.	HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +52 more (list truncated in source)
`PDD-COUNTY` COUNTY	Alpha 25 (Lower Case)	The county for the company address.	HR04.9
`PDD-PHONE-COUNTRY` PHONE_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	HR04.9
`PDD-PHONE` PHONE	Alpha 15	Phone number.	HR04.9
`PDD-PHONE-EXT` PHONE_EXT	Alpha 5	This field contains the telephone extension number.	HR04.9
`PDD-FAX-COUNTRY` FAX_COUNTRY	Alpha 6	This field contains the prefix of the telephone number. For example, the country or city code.	HR04.9
`PDD-FAX-NUMBER` FAX_NUMBER	Alpha 15	Phone number.	HR04.9
`PDD-FAX-EXT` FAX_EXT	Alpha 5	This field contains the telephone extension number.	HR04.9
`PDD-EMAIL-ADDRESS` EMAIL_ADDRESS	Alpha 60 (Lower Case)	Contains the e-mail address.	HR04.9
`PDD-USER1` USER1	Alpha 10	Contains user-defined information.	HR04.9
`PDD-USER2` USER2	Alpha 10	Contains user-defined information.	HR04.9
`PDD-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	HR04.9
`PDD-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	HR04.9
`PDD-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	HR04.9
`PDD-COUNTRY-CODE` COUNTRY_CODE	Alpha 2	Contains the country of the address.	HR04.9
`PDD-CMA-CODE` CMA_CODE	Alpha 10	Contains the Census Metropolitan Area code.	HR04.9
`PDD-SUPP-ADDR1` SUPP_ADDR1	Alpha 30 (Lower Case)	—	HR04.9
`PDD-SUPP-ADDR2` SUPP_ADDR2	Alpha 30 (Lower Case)	—	HR04.9
`PDD-SUPP-ADDR3` SUPP_ADDR3	Alpha 30 (Lower Case)	—	HR04.9
`PDD-SUPP-ADDR4` SUPP_ADDR4	Alpha 30 (Lower Case)	—	HR04.9
`PDD-SUPP-CITY` SUPP_CITY	Alpha 58 (Lower Case)	—	HR04.9
`PDD-SUPP-STATE` SUPP_STATE	Alpha 2	—	HR04.9
`PDD-SUPP-ZIP` SUPP_ZIP	Alpha 10	—	HR04.9
`PDD-SUPP-CNTRY-CD` SUPP_CNTRY_CD	Alpha 2	—	HR04.9
`PDD-REPORT-PROV` REPORT_PROV	Alpha 10	—	HR04.9
`PDD-NUMERIC1` NUMERIC1	Signed 15.4	—	HR04.9
`PDD-NUMERIC2` NUMERIC2	Signed 15.4	—	HR04.9
`PDD-FACILITY-NAME` FACILITY_NAME	Alpha 30	—	HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
`PDD-HIPAA-ID-NBR` HIPAA_ID_NBR	Alpha 30	—	HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
`PDD-HIPAA-ID-TYPE` HIPAA_ID_TYPE	Numeric 1	— `1` Social Number `2` Federal EIN `3` HCFA Provider Number `4` Other `5` Service Provider Nbr	HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PDDSET1`	`TYPE`, `CODE`	Primary		BN106, BN150, BN305, BN66.1, HR04.2, HR04.3, HR04.7, HR04.8 +22 more (list truncated in source)
`PDDSET2`	`COUNTRY-CODE`, `STATE`, `TYPE`, `CODE`			—

Relations

One to one (6) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cma	PCODES	Required	When PDD-CMA-CODE != Spaces	`"CA"` → `PCO-TYPE`, `PDD-CMA-CODE` → `PCO-CODE`
Country	INSTCTRYCD	Required	When (PDD-COUNTRY-CODE != Spaces)	`PDD-COUNTRY-CODE` → `INT-COUNTRY-CODE`
Pcodes	PCODES	Required		`PDD-TYPE` → `PCO-TYPE`, `PDD-CODE` → `PCO-CODE`
Pcodestype	PCODESTYPE	Not Required		`PDD-TYPE` → `PCS-TYPE`
Report Prov	PCODES	Required	When PDD-REPORT-PROV != Spaces	`"RP"` → `PCO-TYPE`, `PDD-REPORT-PROV` → `PCO-CODE`
Supp Country	INSTCTRYCD	Not Required		`PDD-SUPP-CNTRY-CD` → `INT-COUNTRY-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Tax Auth	PRTAXAUTH			`PDD-COUNTRY-CODE` → `PRX-COUNTRY-CODE`, → `PRX-TAX-ID-CODE`

Programs

Updated by (96)

HR04.2 Human Resource Codes
HR04.3 Human Resource Codes
HR04.7 User Fields Value List
HR04.8 Human Resource Codes
HR04.9 Human Resource Codes
HR80.1 Job Occupation Type
HR80.2 Union
HR80.3 Bargaining Unit
HR80.4 Badge Code
HR80.5 Mail Group
HR80.6 Hire Source
HR80.7 User Level
HR80.8 Relationship
HR80.9 Primary Care Physician
HR81.1 Education Degree
HR81.2 Education Subject
HR81.3 Education Institution
HR81.4 Competency
HR81.5 Competency and Certification Source
HR81.6 Certification
HR81.7 Company Property
HR81.8 Emergency Medical
HR81.9 Work Restriction
HR82.1 Working Condition
HR82.2 Work Requirement
HR82.3 Parking Lot
HR82.4 Relocation
HR82.5 Benefit
HR82.6 Qualification
HR82.7 Proficiency
HR82.8 User Field
HR82.9 Association
HR83.1 Review Type
HR83.2 Performance Rating
HR83.3 Applicant Rating
HR83.4 Interview Rating
HR83.5 Personnel Action Reason
HR83.6 Review Type
HR83.7 Benefit Reason Code
HR83.8 Requisition Status
HR83.9 Reason Code
HR84.1 Position Reason Code
HR84.2 Budget Reason Code
HR84.3 Requisition Cost
HR84.4 Supervisor User Field 1
HR84.5 Supervisor User Field 2
HR84.6 Supervisor User Field 3
HR84.7 Supervisor User Field 4
HR84.8 Supervisor User Field 5
HR84.9 Incident Status
HR85.1 Incident Outcome
HR85.2 Incident Category
HR85.3 Incident
HR85.4 Illness
HR85.5 Body Part
HR85.6 Incident Cost Category
HR85.7 Incident Cost Type
HR85.8 Accommodations
HR86.1 Incident Follow Up Category
HR86.2 Incident Follow Up Type
HR86.3 Incident Follow Up Outcome
HR86.4 Test Type
HR86.5 Test Correspondence
HR86.6 Test Source
HR86.7 Test User Field 2
HR86.8 Test User Field 3
HR86.9 Test Eligibility Override Reason
HR87.1 Test Reason
HR87.2 Test Notification Type
HR87.3 Test Refusal Reason
HR87.4 Incident Severity
HR87.5 Incident User 2
HR87.6 Incident User 3
HR87.7 Grievance and Disciplinary Action Category
HR87.8 Grievance and Disciplinary Action Status
HR87.9 Grievance and Disciplinary Action Outcome
HR88.1 Grievance and Disciplinary Action Step Category
HR88.2 Grievance and Disciplinary Action Step Type
HR88.3 Grievance and Disciplinary Action Step Outcome
HR88.4 Human Resource Codes - Disability
HR88.5 Human Resource Codes - Religion
HR88.6 Contract Type
HR88.7 Census Metropolitan Area
HR89.1 HR Codes - Work Eligibility Document Type
HR89.2 HR Codes - Work Eligibility Document Description
HR89.3 Human Resource Codes - Work Eligibility Status
HR89.4 Human Resource Codes - Travel Doc Application Status
HR89.5 Human Resource Codes - Travel Document
HR89.6 Human Resource Codes - Contact Number Type
HR89.7 HR Codes - Official Languages - Bilingual Region
HR89.8 Sharp Device
HR89.9 Brand of Device
HR91.7 Objective Status
HR92.1 Day Codes
HR92.2 Leave Status
HR92.3 Leave Reason

Referenced by (100)

BN106 Benefit Transaction Export
BN150 Life Insurance Reportable Income
BN305 Highly Compensated Employees
BN66.1 Estimated Pay Calculation
EXI2.1 Invoke for PRTRDPD
EXI3.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR204 Human Resource Code Listing
HR28.1 Employee Ethnicity
HR511 Employee Conversion
LP130 Absence Plan Payout
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA149 Update Scheduled Tests
PA290 Health and Safety Incident Listing
PA372 Health and Safety Incident Purge
PA490 OSHA Log, Summary Report
PA496 Official Languages Report
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.2 Mass Pay Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA590 Health and Safety Incident Conversion
PA594 EECRS CSV Interface
PA90.1 Health and Safety Incident
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR14.1 Employee Deduction
PR140 Earnings and Deductions Calculation
PR15.2 Employee Deduction Speed Entry
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR198 General Ledger Posting
PR205 Deduction Listing
PR29.1 Pension Payment Maintenance
PR296 New Hire Reporting
PR30.1 Standard Time Record
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR45.1 Error Processing
PR512 Employee ACH Distribution Interface
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR80.1 Manual Check
PR80.4 Manual Payment
PR82.1 Adjustment
PR84.1 Seniority Recalculation Inquiry
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
UK102 Bonus Pay Update
ZH510 Update PCP from ZPENDPCP
ZP296 New Hire Reporting