|
|
SIRDXTYDEF FILE
REFERENCED BY
RD41.2 RD41.3 RD41.4 RD941
UPDATED BY
RD61.1 RD990
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
XTY-XREF-TYPE Alpha 15 (Lower Case) RD61.1 RD990
Element: Xref Type
XTY-ATTRIBUTE Alpha 30 RD61.1 RD990
Element: Attribute
XTY-REQUIRED Alpha 1 RD61.1 RD990
Element: Required Y = Yes
N = No
XTY-DEFAULT-VALUE Alpha 55 (Lower Case) RD61.1
Element: Default Value
XTY-KEY-FIELD Alpha 1 RD61.1 RD990
Element: Key Field Y = Yes
N = No
XTY-KEY-ORDER Numeric 4 RD61.1 RD990
Element: Key Order
XTY-ENCRYPTED Alpha 1 RD61.1 RD990
Element: Encrypted Y = Yes
N = No
XTY-DATE Numeric 8 (yyyymmdd) RD61.1 RD990
Element: Date This field contains the system date
when this was created.
XTY-TIME Numeric 6 (hhmmss) RD61.1 RD990
Element: Time
SIRDXTYDEF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
XTYSET1 XREF-TYPE RD41.2 RD41.3
ATTRIBUTE RD41.4 RD61.1
RD941 RD990
XTYSET2 XREF-TYPE KeyChange, Subset RD41.2 RD941
KEY-ORDER Where KEY-FIELD = "Y"
ATTRIBUTE
XTYSET3 ATTRIBUTE RD61.2 RD61.3
XREF-TYPE
XTYSET4 ENCRYPTED KeyChange, Subset RD41.2 RD41.3
XREF-TYPE Where KEY-FIELD = "N" RD41.4
ATTRIBUTE
SIRDXTYDEF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdxrftyp SIRDXRFTYP Required
XTY-XREF-TYPE -> XRT-XREF-TYPE
Sirdxtyatt SIRDXTYATT Required
XTY-ATTRIBUTE -> XTA-ATTRIBUTE
|
