HRCONTNBR – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
HCN
Primary key
COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBR
Fields
16
Updated by
3 programs
Referenced by
7 programs

HRCONTNBR is a Lawson Human Resources table (prefix HCN); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBR (HCNSET1); alternate indexes: HCNSET3. It is related 1:1 to APPLICANT, PRSYSTEM, PCODES, EMDEPEND, EMPLOYEE, PAINSTRUCT, PAEMPLOYEE and PARTICIPNT. It is updated by HR11.1, HR20.1 and PA115 and referenced by HR170, HR211, HR220, HR70.1, PA311, PA390 and PA93.2. The table has 16 fields, 2 indexes and 8 documented relations.

About HRCONTNBR

No description in the Lawson data dictionary.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
HCN-COMPANY PK
COMPANY		Numeric 4—HR20.1
HCN-REQ-TYPE PK
REQ_TYPE		Alpha 1Contains the type of person the contact number belongs to.
  • 1 Employee
  • 2 Applicant
  • 3 COBRA Participant
  • 4 Dependent
  • 5 Instructor
HR20.1
HCN-ID-NBR PK
ID_NBR		Numeric 10Contains an identification number (for example, an employee number) for this type of record.HR20.1
HCN-DEPENDENT PK
DEPENDENT		Numeric 4Contains the dependent if Req-Type = Dependent.HR20.1
HCN-SEQ-NBR PK
SEQ_NBR		Numeric 4Sequential number that allows unlimited phone records per Company:Req-Type:ID-Nbr:Dependent.HR20.1
HCN-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)Beginning date related to the contact number.HR20.1
HCN-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.HR20.1
HCN-DATE
DATE		Numeric 8 (yyyymmdd)This field contains the system date when this was created. Internal date used for record sorting/display.HR20.1
HCN-CONTACT-TYPE
CONTACT_TYPE		Alpha 10User-defined type of number (for example, cell phone, pager, vacation residence, and so on).HR20.1
HCN-PHONE-COUNTRY
PHONE_COUNTRY		Alpha 6This field contains the prefix of the telephone number. For example, the country or city code.HR20.1
HCN-PHONE
PHONE		Alpha 15Contains the phone number.HR20.1
HCN-PHONE-EXT
PHONE_EXT		Alpha 5This field contains the telephone extension number.HR20.1
HCN-COMMENT
COMMENT		Alpha 40 (Lower Case)This field contains the comment narrative.HR20.1
HCN-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR20.1
HCN-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR20.1
HCN-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR20.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
HCNSET1COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, SEQ-NBRPrimaryHR11.1, HR20.1, PA115, PA390, PA93.2
HCNSET3COMPANY, REQ-TYPE, ID-NBR, DEPENDENT, DATE*, SEQ-NBRKeyChange, SubsetWhere REQ-TYPE != "5"HR170, HR20.1, HR211, HR220, HR70.1, PA115, PA311

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen HCN-REQ-TYPE = "2"HCN-COMPANY → APL-COMPANY, HCN-ID-NBR → APL-APPLICANT
CompanyPRSYSTEMRequiredHCN-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Contact TypePCODESRequiredWhen HCN-CONTACT-TYPE != Spaces"NT" → PCO-TYPE, HCN-CONTACT-TYPE → PCO-CODE
DependentEMDEPENDRequiredWhen HCN-REQ-TYPE = "4"HCN-COMPANY → EMD-COMPANY, HCN-ID-NBR → EMD-EMPLOYEE, HCN-DEPENDENT → EMD-SEQ-NBR
EmployeeEMPLOYEERequiredWhen HCN-REQ-TYPE = "1"HCN-COMPANY → EMP-COMPANY, HCN-ID-NBR → EMP-EMPLOYEE
InstructorPAINSTRUCTRequiredWhen HCN-REQ-TYPE = "5"HCN-ID-NBR → INS-INSTRUCT
PaemployeePAEMPLOYEERequiredWhen HCN-REQ-TYPE = "1"HCN-COMPANY → PEM-COMPANY, HCN-ID-NBR → PEM-EMPLOYEE
ParticipntPARTICIPNTRequiredWhen HCN-REQ-TYPE = "3"HCN-COMPANY → PAR-COMPANY, HCN-ID-NBR → PAR-PARTICIPNT

Programs

Updated by (3)

Referenced by (7)