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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#HCN-COMPANY PKCOMPANY | Numeric 4 | — | HR20.1 |
#HCN-REQ-TYPE PKREQ_TYPE | Alpha 1 | Contains the type of person the contact number belongs to.
| HR20.1 |
#HCN-ID-NBR PKID_NBR | Numeric 10 | Contains an identification number (for example, an employee number) for this type of record. | HR20.1 |
#HCN-DEPENDENT PKDEPENDENT | Numeric 4 | Contains the dependent if Req-Type = Dependent. | HR20.1 |
#HCN-SEQ-NBR PKSEQ_NBR | Numeric 4 | Sequential number that allows unlimited phone records per Company:Req-Type:ID-Nbr:Dependent. | HR20.1 |
#HCN-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | Beginning date related to the contact number. | HR20.1 |
#HCN-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The end date for this effort period. | HR20.1 |
#HCN-DATE SET3DATE | Numeric 8 (yyyymmdd) | This field contains the system date when this was created. Internal date used for record sorting/display. | HR20.1 |
#HCN-CONTACT-TYPECONTACT_TYPE | Alpha 10 | User-defined type of number (for example, cell phone, pager, vacation residence, and so on). | HR20.1 |
#HCN-PHONE-COUNTRYPHONE_COUNTRY | Alpha 6 | This field contains the prefix of the telephone number. For example, the country or city code. | HR20.1 |
#HCN-PHONEPHONE | Alpha 15 | Contains the phone number. | HR20.1 |
#HCN-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the telephone extension number. | HR20.1 |
#HCN-COMMENTCOMMENT | Alpha 40 (Lower Case) | This field contains the comment narrative. | HR20.1 |
#HCN-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | HR20.1 |
#HCN-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | HR20.1 |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
HCNSET1 |
| Primary | HR11.1, HR20.1, PA115, PA390, PA93.2 | |
HCNSET3 |
| KeyChange, Subset | Where REQ-TYPE != "5" | HR170, HR20.1, HR211, HR220, HR70.1, PA115, PA311 |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Applicant | APPLICANT | Required | When HCN-REQ-TYPE = "2" |
| |||||||||
| Company | PRSYSTEM | Required |
| ||||||||||
| Contact Type | PCODES | Required | When HCN-CONTACT-TYPE != Spaces |
| |||||||||
| Dependent | EMDEPEND | Required | When HCN-REQ-TYPE = "4" |
| |||||||||
| Employee | EMPLOYEE | Required | When HCN-REQ-TYPE = "1" |
| |||||||||
| Instructor | PAINSTRUCT | Required | When HCN-REQ-TYPE = "5" |
| |||||||||
| Paemployee | PAEMPLOYEE | Required | When HCN-REQ-TYPE = "1" |
| |||||||||
| Participnt | PARTICIPNT | Required | When HCN-REQ-TYPE = "3" |
|