SIRDIDLGN FILE
UPDATED BY
LO14.3 RD30.1 RD30.2 RD40.1 RD40.2 RD50.1
RD50.2 RD70.1 RD70.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILG-ID Alpha 20 (Lower Case) RD40.1 RD40.2
Element: Id
ILG-LOGIN-TYPE Alpha 5 RD40.1 RD40.2
Element: Login Type
ILG-USER-LOGIN Alpha 80 (Lower Case) RD40.1 RD40.2
Element: User Login
ILG-ACCESS-CODE Alpha 30 (Lower Case) RD40.1 RD40.2
Element: Access Code
ILG-OLD-ACCESS-CD Alpha 30 (Lower Case) RD40.1 RD40.2
Element: Old Access Cd
ILG-EXPIRE Numeric 3 RD40.1 RD40.2
Element: Expire
ILG-MESSAGE Alpha 60 (Lower Case) RD40.1 RD40.2
Element: Message
ILG-URL Alpha 256 (Lower Case) RD40.1 RD40.2
Element: Url
ILG-DATE Numeric 8 (yyyymmdd) RD40.1 RD40.2
Element: Date This field contains the system date
when this was created.
ILG-TIME Numeric 6 (hhmmss) RD40.1 RD40.2
Element: Time
ILG-ID-RECORD Derived
Element: Id Record
SIRDIDLGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILGSET1 ID LO14.3 RD30.1
LOGIN-TYPE RD30.2 RD40.1
USER-LOGIN RD40.2 RD50.1
RD50.2 RD70.1
RD70.2
ILGSET2 LOGIN-TYPE RD40.1 RD40.2
USER-LOGIN
ID
ILGSET3 USER-LOGIN
LOGIN-TYPE
ID
SIRDIDLGN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidhdr SIRDIDHDR Required
ILG-ID -> IDH-ID (IDHSET1)
Sirdlgntyp SIRDLGNTYP Required
ILG-LOGIN-TYPE -> LGT-LOGIN-TYPE
Webuser WEBUSER Required
When ILG-LOGIN-TYPE = "WEB "
ILG-USER-LOGIN -> WUR-WEB-USER
|
