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.

Field / column	Type	Description & values	Updated 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` 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` PREREQ_GRP	Alpha 2	—	UG99.4
`UGC-PREREQ-SEQ` PREREQ_SEQ	Numeric 3	—	UG99.4
`UGC-PREREQ-TYPE` PREREQ_TYPE	Alpha 1	S P M O X	UG99.4
`UGC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	—

Indexes (5)

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
`UGCSET1`	`PATH`, `SYSTEM-CD`, `JOB-TYPE`, `SEQ`	Primary		UG00.1, UG95.1, UG99.2, UG99.3, UG99.4, UG99.6, UG99.7
`UGCSET2`	`PATH`, `PREREQ-GRP`, `PREREQ-SEQ`	Subset	Where (PREREQ-GRP != Spaces)	UG99.4, UG99.6
`UGCSET3`	`PATH`, `UPG-OBJECT`, `SYSTEM-CD`, `JOB-TYPE`, `SEQ`			UG95.4
`UGCSET4`	`PATH`, `SYSTEM-CD`, `JOB-TYPE`, `SEQ`	Subset	Where (SYSTEM-CD = Spaces)	—
`UGCSET5`	`PATH`, `UPG-OBJECT`	Subset	Where (JOB-TYPE = "match")	UG95.4

Programs

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