SIRDPROXY FILE
UPDATED BY
RD34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXY-ID Alpha 20 (Lower Case) RD34.1
Element: Id
PXY-PROXY-ID Alpha 20 (Lower Case) RD34.1
Element: Proxy Id
PXY-ID-STATUS Numeric 1 RD34.1
Element: Id Status 1 = Active
2 = Inactive
9 = Historical
PXY-DESCRIPTION Alpha 50 (Lower Case) RD34.1
Element: Description This field contains the description.
PXY-BEGIN-DATE Numeric 8 (yyyymmdd) RD34.1
Element: Begin Date
PXY-END-DATE Numeric 8 (yyyymmdd) RD34.1
Element: Ending Date The ending date in a range of dates.
PXY-BEGIN-TIME Numeric 6 (hhmmss) RD34.1
Element: Begin Time
PXY-END-TIME Numeric 6 (hhmmss) RD34.1
Element: End Time
PXY-DATE Numeric 8 (yyyymmdd) RD34.1
Element: Date This field contains the system date
when this was created.
PXY-TIME Numeric 6 (hhmmss) RD34.1
Element: Time
PXY-ID-RECORD Derived
Element: Id Record
SIRDPROXY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXYSET1 ID RD34.1
PROXY-ID
PXYSET2 PROXY-ID
ID
SIRDPROXY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sirdidhdr SIRDIDHDR Required
PXY-ID -> IDH-ID (IDHSET1)
|
