|
|
SIRDIDCOL FILE
UPDATED BY
RD32.1 RD32.2 RD32.3 RD32.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICL-ID Alpha 20 (Lower Case) RD32.1 RD32.2
Element: Id RD32.3 RD32.4
ICL-COLLECTION Alpha 20 (Lower Case) RD32.1 RD32.2
Element: Collection RD32.3 RD32.4
ICL-MEMBER-ID Alpha 20 (Lower Case) RD32.1 RD32.3
Element: Member Id
ICL-NON-MEMBER-ID Alpha 20 (Lower Case) RD32.2 RD32.4
Element: Non Member Id
ICL-DATE Numeric 8 (yyyymmdd) RD32.1 RD32.2
Element: Date This field contains the system date RD32.3 RD32.4
when this was created.
ICL-TIME Numeric 6 (hhmmss) RD32.1 RD32.2
Element: Time RD32.3 RD32.4
ICL-MEMBER-RECORD Derived
Element: Member Record
ICL-ID-RECORD Derived
Element: Id Record
SIRDIDCOL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICLSET1 ID RD32.1 RD32.2
COLLECTION RD32.3 RD32.4
NON-MEMBER-ID
MEMBER-ID
ICLSET2 ID Subset RD32.1 RD32.3
COLLECTION Where NON-MEMBER-ID = Spaces
MEMBER-ID
ICLSET3 ID Subset RD32.2 RD32.4
COLLECTION Where MEMBER-ID = Spaces
NON-MEMBER-ID
ICLSET4 ID Subset
NON-MEMBER-ID Where MEMBER-ID = Spaces
COLLECTION
ICLSET5 ID Subset
MEMBER-ID Where NON-MEMBER-ID = Spaces
COLLECTION
ICLSET6 MEMBER-ID Subset
ID Where NON-MEMBER-ID = Spaces
COLLECTION
SIRDIDCOL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Member First LOMXVALUE Not Required, Delete Cascades
Valid When ICL-NON-MEMBER-ID = Spaces
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-FIRST " -> LMV-MATRIX-CAT
Member Id SIRDIDHDR Required
ICL-MEMBER-ID -> IDH-ID
Member Last LOMXVALUE Not Required, Delete Cascades
Valid When ICL-NON-MEMBER-ID = Spaces
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LAST " -> LMV-MATRIX-CAT
Name First LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-FIRST " -> LMV-MATRIX-CAT
Name Last LOMXVALUE Not Required, Delete Cascades
IDH-OBJ-ID -> LMV-OBJ-ID
"PRIMARY " -> LMV-MATRIX-TYPE
"NAME-LAST " -> LMV-MATRIX-CAT
Sirdcollct SIRDCOLLCT Required
ICL-ID -> COL-ID
ICL-COLLECTION -> COL-COLLECTION
Sirdidhdr SIRDIDHDR Required
ICL-ID -> IDH-ID
Sirdnonmem SIRDNONMEM Required
ICL-ID -> CDT-ID
ICL-NON-MEMBER-ID -> CDT-NON-MEMBER-ID
|
