UGSTAT – Upgrade Statistics

System
Upgrade Module (UG)
Prefix
UGS
Primary key
PATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, TYPE, PROGRAM, FILE-NAME
Fields
17
Updated by
2 programs
Referenced by
0 programs

UGSTAT is the Upgrade Statistics table in Lawson Upgrade Module (prefix UGS). It is indexed by PATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, TYPE, PROGRAM, FILE-NAME (UGSSET1); alternate indexes: UGSSET2, UGSSET3, UGSSET4 and UGSSET5. It is updated by UG95.3 and XUGS.1. The table has 17 fields, 5 indexes and 0 documented relations.

About UGSTAT

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the UGS- 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
#UGS-PATH PK
PATH		Alpha 20 (Lower Case)—XUGS.1
#UGS-UPGRADE-ID PK
UPGRADE_ID		Alpha 10 (Lower Case)—XUGS.1
#UGS-RUN-GROUP PK
RUN_GROUP		Alpha 15 (Lower Case)—XUGS.1
#UGS-SYSTEM-CD PK
SYSTEM_CD		Alpha 2—XUGS.1
#UGS-TYPE PK
TYPE		Alpha 2—XUGS.1
#UGS-PROGRAM PK
PROGRAM		Alpha 30 (Lower Case)—XUGS.1
#UGS-FILE-NAME PK
FILE_NAME		Alpha 30 (Lower Case)—XUGS.1
#UGS-PROC-GROUP
PROC_GROUP		Alpha 10 (Lower Case)—XUGS.1
#UGS-WRITN
WRITN		Numeric 12—XUGS.1
#UGS-DUPS
DUPS		Numeric 12—XUGS.1
#UGS-UPDATED
UPDATED		Numeric 12—XUGS.1
#UGS-MESSAGE
MESSAGE		Alpha 64 (Lower Case)—XUGS.1
#UGS-TIME
TIME		Numeric 8—XUGS.1
#UGS-TIME-SEQ
TIME_SEQ		Numeric 12——
#UGS-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—XUGS.1
#UGS-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—XUGS.1
#UGS-USER
USER		Alpha 10 (Lower Case)—XUGS.1

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
UGSSET1
  1. PATH
  2. UPGRADE-ID
  3. RUN-GROUP
  4. SYSTEM-CD
  5. TYPE
  6. PROGRAM
  7. FILE-NAME
PrimaryUG95.1, UG95.2, UG95.3, UG95.4, XUGS.1
UGSSET2
  1. PATH
  2. UPGRADE-ID
  3. RUN-GROUP
  4. SYSTEM-CD
  5. FILE-NAME
  6. TYPE
  7. PROGRAM
SubsetWhere FILE-NAME != SpacesUG95.1, UG95.4
UGSSET3
  1. PATH
  2. UPGRADE-ID
  3. RUN-GROUP
  4. SYSTEM-CD
  5. PROGRAM
  6. TYPE
  7. FILE-NAME
—
UGSSET4
  1. PATH
  2. UPGRADE-ID
  3. RUN-GROUP
  4. SYSTEM-CD
  5. PROGRAM
  6. FILE-NAME
  7. TYPE
UG95.1, UG95.2
UGSSET5
  1. PATH
  2. UPGRADE-ID
  3. RUN-GROUP
  4. PROGRAM
  5. FILE-NAME
  6. SYSTEM-CD
  7. TYPE
XUGS.1

Programs

Updated by (2)