SIRDIDPREF FILE
UPDATED BY
RD06.1 RD06.2 RD06.3 WF12.5
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SIP-ID Alpha 20 (Lower Case) RD06.1 RD06.2
Element: Id RD06.3 WF12.5
SIP-SYSTEM-NAME Alpha 10 RD06.1 RD06.2
Element: System Name RD06.3 WF12.5
SIP-FIELD-NAME Alpha 20 (Lower Case) RD06.1 RD06.2
Element: Field Name RD06.3 WF12.5
SIP-FIELD-VALUE Alpha 99 (Lower Case) RD06.1 RD06.2
Element: Field Value RD06.3 WF12.5
SIP-DATE Numeric 8 (yyyymmdd) RD06.1 RD06.2
Element: Date This field contains the system date RD06.3
when this was created.
SIP-TIME Numeric 6 (hhmmss) RD06.1 RD06.2
Element: Time RD06.3
SIP-ID-RECORD Derived
Element: Id Record
SIRDIDPREF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SIPSET1 ID RD06.1 RD06.2
SYSTEM-NAME RD06.3 WF12.5
FIELD-NAME
SIPSET2 SYSTEM-NAME RD06.2
FIELD-NAME
ID
SIPSET3 SYSTEM-NAME Subset RD06.1 RD06.3
FIELD-NAME Where ID = Spaces
SIRDIDPREF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidhdr SIRDIDHDR Required
SIP-ID -> IDH-ID
Sisetup SISETUP Required
SIP-SYSTEM-NAME -> SUP-SYSTEM-NAME
SIP-FIELD-NAME -> SUP-FIELD-NAME
|
