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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
UGS-PATH PKPATH | Alpha 20 (Lower Case) | — | XUGS.1 |
UGS-UPGRADE-ID PKUPGRADE_ID | Alpha 10 (Lower Case) | — | XUGS.1 |
UGS-RUN-GROUP PKRUN_GROUP | Alpha 15 (Lower Case) | — | XUGS.1 |
UGS-SYSTEM-CD PKSYSTEM_CD | Alpha 2 | — | XUGS.1 |
UGS-TYPE PKTYPE | Alpha 2 | — | XUGS.1 |
UGS-PROGRAM PKPROGRAM | Alpha 30 (Lower Case) | — | XUGS.1 |
UGS-FILE-NAME PKFILE_NAME | Alpha 30 (Lower Case) | — | XUGS.1 |
UGS-PROC-GROUPPROC_GROUP | Alpha 10 (Lower Case) | — | XUGS.1 |
UGS-WRITNWRITN | Numeric 12 | — | XUGS.1 |
UGS-DUPSDUPS | Numeric 12 | — | XUGS.1 |
UGS-UPDATEDUPDATED | Numeric 12 | — | XUGS.1 |
UGS-MESSAGEMESSAGE | Alpha 64 (Lower Case) | — | XUGS.1 |
UGS-TIMETIME | Numeric 8 | — | XUGS.1 |
UGS-TIME-SEQTIME_SEQ | Numeric 12 | — | — |
UGS-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | XUGS.1 |
UGS-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | XUGS.1 |
UGS-USERUSER | Alpha 10 (Lower Case) | — | XUGS.1 |
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 |
|---|---|---|---|---|
UGSSET1 | PATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, TYPE, PROGRAM, FILE-NAME | Primary | UG95.1, UG95.2, UG95.3, UG95.4, XUGS.1 | |
UGSSET2 | PATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, FILE-NAME, TYPE, PROGRAM | Subset | Where FILE-NAME != Spaces | UG95.1, UG95.4 |
UGSSET3 | PATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, PROGRAM, TYPE, FILE-NAME | — | ||
UGSSET4 | PATH, UPGRADE-ID, RUN-GROUP, SYSTEM-CD, PROGRAM, FILE-NAME, TYPE | UG95.1, UG95.2 | ||
UGSSET5 | PATH, UPGRADE-ID, RUN-GROUP, PROGRAM, FILE-NAME, SYSTEM-CD, TYPE | XUGS.1 |