UGCHKLST – Upgrade checklist file

System
Upgrade Module (UG)
Prefix
UGC
Primary key
PATH, SYSTEM-CD, JOB-TYPE, SEQ
Fields
19
Updated by
0 programs
Referenced by
0 programs

UGCHKLST is the Upgrade checklist file table in Lawson Upgrade Module (prefix UGC). It is indexed by PATH, SYSTEM-CD, JOB-TYPE, SEQ (UGCSET1); alternate indexes: UGCSET2, UGCSET3, UGCSET4 and UGCSET5. The table has 19 fields, 5 indexes and 0 documented relations.

About UGCHKLST

Upgrade checklist file

Fields (19)

Column = COBOL field name without the UGC- 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 / columnTypeDescription & valuesUpdated by
#UGC-PATH PK
PATH		Alpha 20 (Lower Case)—UG99.4, UG99.7
#UGC-SYSTEM-CD PK
SYSTEM_CD		Alpha 2—UG99.4, UG99.7
#UGC-JOB-TYPE PK
JOB_TYPE		Alpha 10 (Lower Case)—UG99.4, UG99.7
#UGC-SEQ PK
SEQ		Numeric 3——
#UGC-UPG-OBJECT SET3 SET5
UPG_OBJECT		Alpha 14 (Lower Case)—UG99.4, UG99.7
#UGC-BATCH-INT
BATCH_INT		Alpha 1——
#UGC-SRC-TRG
SRC_TRG		Alpha 1—UG99.4
#UGC-TYPE
TYPE		Alpha 1—UG99.4
#UGC-HAS-PARMS
HAS_PARMS		Alpha 1—UG99.4
#UGC-IS-REQUIRED
IS_REQUIRED		Alpha 1——
#UGC-EXCLUDE-IF
EXCLUDE_IF		Alpha 2——
#UGC-INCLUDE-IF
INCLUDE_IF		Alpha 2——
#UGC-MISC1
MISC1		Alpha 2—UG99.4
#UGC-MISC2
MISC2		Alpha 2—UG99.4
#UGC-MISC3
MISC3		Alpha 16—UG95.4, UG99.4
#UGC-PREREQ-GRP SET2
PREREQ_GRP		Alpha 2—UG99.4
#UGC-PREREQ-SEQ SET2
PREREQ_SEQ		Numeric 3—UG99.4
#UGC-PREREQ-TYPE
PREREQ_TYPE		Alpha 1S P M O XUG99.4
#UGC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)——

Indexes (5)

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.

IndexKeysFlagsConditionUsed in
UGCSET1
  1. PATH
  2. SYSTEM-CD
  3. JOB-TYPE
  4. SEQ
PrimaryUG00.1, UG95.1, UG99.2, UG99.3, UG99.4, UG99.6, UG99.7
UGCSET2
  1. PATH
  2. PREREQ-GRP
  3. PREREQ-SEQ
SubsetWhere (PREREQ-GRP != Spaces)UG99.4, UG99.6
UGCSET3
  1. PATH
  2. UPG-OBJECT
  3. SYSTEM-CD
  4. JOB-TYPE
  5. SEQ
UG95.4
UGCSET4
  1. PATH
  2. SYSTEM-CD
  3. JOB-TYPE
  4. SEQ
SubsetWhere (SYSTEM-CD = Spaces)—
UGCSET5
  1. PATH
  2. UPG-OBJECT
SubsetWhere (JOB-TYPE = "match")UG95.4

Programs

No Lawson programs are documented as updating or referencing this table.