July 30, 2008, 12:56 PM
kittenFILENAME=AT_AR_BALANCE_BY_ENTITY, SUFFIX=SQLORA , $
SEGMENT=AT_AR_BALANCE_BY_ENTITY, SEGTYPE=S0, $
FIELDNAME=PIDM_KEY, ALIAS=PIDM_KEY, USAGE=P9, ACTUAL=P5, $
FIELDNAME=ENTITY_IND, ALIAS=ENTITY_IND, USAGE=A1V, ACTUAL=A1V,
MISSING=ON, $
FIELDNAME=ID, ALIAS=ID, USAGE=A9V, ACTUAL=A9V, $
FIELDNAME=SSN, ALIAS=SSN, USAGE=A9V, ACTUAL=A9V,
MISSING=ON, $
FIELDNAME=LAST_NAME, ALIAS=LAST_NAME, USAGE=A60V, ACTUAL=A60V, $
FIELDNAME=FIRST_NAME, ALIAS=FIRST_NAME, USAGE=A15V, ACTUAL=A15V,
MISSING=ON, $
FIELDNAME=MIDDLE_NAME, ALIAS=MIDDLE_NAME, USAGE=A15V, ACTUAL=A15V,
MISSING=ON, $
FIELDNAME=MIDDLE_INITIAL, ALIAS=MIDDLE_INITIAL, USAGE=A1V, ACTUAL=A1V,
MISSING=ON, $
FIELDNAME=NAME_PREFIX, ALIAS=NAME_PREFIX, USAGE=A20V, ACTUAL=A20V,
MISSING=ON, $
FIELDNAME=NAME_SUFFIX, ALIAS=NAME_SUFFIX, USAGE=A20V, ACTUAL=A20V,
MISSING=ON, $
FIELDNAME=ACCOUNT_BALANCE, ALIAS=ACCOUNT_BALANCE, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=AMOUNT_DUE, ALIAS=AMOUNT_DUE, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=MEMO_BALANCE, ALIAS=MEMO_BALANCE, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=DEPOSIT_BALANCE, ALIAS=DEPOSIT_BALANCE, USAGE=D20.2, ACTUAL=D8,
MISSING=ON, $
FIELDNAME=OLDEST_EFFECTIVE_DATE, ALIAS=OLDEST_EFFECTIVE_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FILENAME=SLRMASG, SUFFIX=SQLORA ,
REMARKS='Meal Assignment Table', $
SEGMENT=SLRMASG, SEGTYPE=S0, $
FIELDNAME=SLRMASG_PIDM, ALIAS=SLRMASG_PIDM, USAGE=P9, ACTUAL=P5,
DESCRIPTION='This field defines the internal identifier associated with the meal assignments', $
FIELDNAME=SLRMASG_TERM_CODE, ALIAS=SLRMASG_TERM_CODE, USAGE=A6V, ACTUAL=A6V,
DESCRIPTION='This field defines the term code associated with the meal assignments', $
FIELDNAME=SLRMASG_MRCD_CODE, ALIAS=SLRMASG_MRCD_CODE, USAGE=A4V, ACTUAL=A4V,
DESCRIPTION='This field defines the meal plan code', $
FIELDNAME=SLRMASG_BEGIN_DATE, ALIAS=SLRMASG_BEGIN_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field identifies the first day of the meal assignment', $
FIELDNAME=SLRMASG_END_DATE, ALIAS=SLRMASG_END_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field identifies the last day of the meal assignment', $
FIELDNAME=SLRMASG_TOTAL_DAYS, ALIAS=SLRMASG_TOTAL_DAYS, USAGE=P11.5, ACTUAL=P5,
DESCRIPTION='This field identifies the total number of days of the meal assignment', $
FIELDNAME=SLRMASG_TOTAL_MONTHS, ALIAS=SLRMASG_TOTAL_MONTHS, USAGE=P9.5, ACTUAL=P4,
DESCRIPTION='This field identifies the total number of months of the meal assignment', $
FIELDNAME=SLRMASG_TOTAL_TERMS, ALIAS=SLRMASG_TOTAL_TERMS, USAGE=P9.5, ACTUAL=P4,
DESCRIPTION='This field identifies the total number of terms of the meal assignment', $
FIELDNAME=SLRMASG_MSCD_CODE, ALIAS=SLRMASG_MSCD_CODE, USAGE=A2V, ACTUAL=A2V,
DESCRIPTION='This field identifies the meal plan status code of the meal assignment', $
FIELDNAME=SLRMASG_MSCD_DATE, ALIAS=SLRMASG_MSCD_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field defines the date the meal plan status code was last updated', $
FIELDNAME=SLRMASG_ONL_OR_BAT, ALIAS=SLRMASG_ONL_OR_BAT, USAGE=A1V, ACTUAL=A1V,
DESCRIPTION='This field identifies whether the meal assignment was created on-line or batch using the batch scheduler', $
FIELDNAME=SLRMASG_ACTIVITY_DATE, ALIAS=SLRMASG_ACTIVITY_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field identifies the date the record was created or last updated', $
FIELDNAME=SLRMASG_AR_IND, ALIAS=SLRMASG_AR_IND, USAGE=A1V, ACTUAL=A1V,
DESCRIPTION='This field identifies whether the meal assignment charges have been processed', $
FIELDNAME=SLRMASG_ROLL_IND, ALIAS=SLRMASG_ROLL_IND, USAGE=A1V, ACTUAL=A1V,
MISSING=ON,
DESCRIPTION='This field controls whether the meal assignment can be rolled using the roll forward process', $
FIELDNAME=SLRMASG_ASSESS_NEEDED, ALIAS=SLRMASG_ASSESS_NEEDED, USAGE=A1V, ACTUAL=A1V,
DESCRIPTION='This field identifies whether fee assessment is needed for the meal assignment', $
FIELDNAME=SLRMASG_DATA_ORIGIN, ALIAS=SLRMASG_DATA_ORIGIN, USAGE=A30V, ACTUAL=A30V,
MISSING=ON,
DESCRIPTION='DATA SOURCE: Source system that created or updated the row', $
FIELDNAME=SLRMASG_USER_ID, ALIAS=SLRMASG_USER_ID, USAGE=A30V, ACTUAL=A30V,
MISSING=ON,
DESCRIPTION='USER ID: User who inserted or last update the data', $
FILENAME=SLRRASG, SUFFIX=SQLORA ,
REMARKS='Room Assignment Table', $
SEGMENT=SLRRASG, SEGTYPE=S0, $
FIELDNAME=SLRRASG_PIDM, ALIAS=SLRRASG_PIDM, USAGE=P9, ACTUAL=P5,
DESCRIPTION='This field defines the internal identifier associated with the room assignments', $
FIELDNAME=SLRRASG_BLDG_CODE, ALIAS=SLRRASG_BLDG_CODE, USAGE=A6V, ACTUAL=A6V,
DESCRIPTION='This field identifies the building code of the room assignment', $
FIELDNAME=SLRRASG_ROOM_NUMBER, ALIAS=SLRRASG_ROOM_NUMBER, USAGE=A10V, ACTUAL=A10V,
DESCRIPTION='This field identifies the room number of the room assignment', $
FIELDNAME=SLRRASG_TERM_CODE, ALIAS=SLRRASG_TERM_CODE, USAGE=A6V, ACTUAL=A6V,
DESCRIPTION='This field defines the term associated with the room assignments', $
FIELDNAME=SLRRASG_RRCD_CODE, ALIAS=SLRRASG_RRCD_CODE, USAGE=A4V, ACTUAL=A4V,
DESCRIPTION='This field defines the room rate code associated with the assignment', $
FIELDNAME=SLRRASG_BEGIN_DATE, ALIAS=SLRRASG_BEGIN_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field identifies the first day of the room assignment', $
FIELDNAME=SLRRASG_END_DATE, ALIAS=SLRRASG_END_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field identifies the last day of the room assignment', $
FIELDNAME=SLRRASG_TOTAL_DAYS, ALIAS=SLRRASG_TOTAL_DAYS, USAGE=P11.5, ACTUAL=P5,
DESCRIPTION='This field identifies the total number of days of the room assignment', $
FIELDNAME=SLRRASG_TOTAL_MONTHS, ALIAS=SLRRASG_TOTAL_MONTHS, USAGE=P9.5, ACTUAL=P4,
DESCRIPTION='This field identifies the total number of months of the room assignment', $
FIELDNAME=SLRRASG_TOTAL_TERMS, ALIAS=SLRRASG_TOTAL_TERMS, USAGE=P9.5, ACTUAL=P4,
DESCRIPTION='This field identifies the total number of terms of the room assignment', $
FIELDNAME=SLRRASG_ASCD_CODE, ALIAS=SLRRASG_ASCD_CODE, USAGE=A2V, ACTUAL=A2V,
DESCRIPTION='This field identifies the status code of the room assignment', $
FIELDNAME=SLRRASG_ASCD_DATE, ALIAS=SLRRASG_ASCD_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field defines the date the room plan status code was last updated', $
FIELDNAME=SLRRASG_ONL_OR_BAT, ALIAS=SLRRASG_ONL_OR_BAT, USAGE=A1V, ACTUAL=A1V,
DESCRIPTION='This field identifies whether the room assignment was created on-line or batch using the batch scheduler', $
FIELDNAME=SLRRASG_ACTIVITY_DATE, ALIAS=SLRRASG_ACTIVITY_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
DESCRIPTION='This field identifies the date the record was created or last updated', $
FIELDNAME=SLRRASG_AR_IND, ALIAS=SLRRASG_AR_IND, USAGE=A1V, ACTUAL=A1V,
DESCRIPTION='This field identifies whether the room assignment charges have been processed', $
FIELDNAME=SLRRASG_OVERLOAD_IND, ALIAS=SLRRASG_OVERLOAD_IND, USAGE=A1V, ACTUAL=A1V,
MISSING=ON,
DESCRIPTION='This field identifies whether an overload condition existed to allow the room assignment', $
FIELDNAME=SLRRASG_ROLL_IND, ALIAS=SLRRASG_ROLL_IND, USAGE=A1V, ACTUAL=A1V,
MISSING=ON,
DESCRIPTION='This field controls whether the room assignment can be rolled using the roll forward process', $
FIELDNAME=SLRRASG_OVERRIDE_ERROR, ALIAS=SLRRASG_OVERRIDE_ERROR, USAGE=A1V, ACTUAL=A1V,
MISSING=ON,
DESCRIPTION='This field identifies whether an error override condition existed to allow the room assignment', $
FIELDNAME=SLRRASG_ASSESS_NEEDED, ALIAS=SLRRASG_ASSESS_NEEDED, USAGE=A1V, ACTUAL=A1V,
DESCRIPTION='This field identifies whether fee assessment is needed for the room assignment', $
FIELDNAME=SLRRASG_DATA_ORIGIN, ALIAS=SLRRASG_DATA_ORIGIN, USAGE=A30V, ACTUAL=A30V,
MISSING=ON,
DESCRIPTION='DATA SOURCE: Source system that created or updated the row', $
FIELDNAME=SLRRASG_USER_ID, ALIAS=SLRRASG_USER_ID, USAGE=A30V, ACTUAL=A30V,
MISSING=ON,
DESCRIPTION='USER ID: User who inserted or last update the data', $