LC Digital Repository Development and Support


LC Work Unit Validation Table -- Supporting Information


How LC_Unit Attributes "Map" to REMEDY Table T17 and View T96

LC_UNIT Attribute Table T17View T96
NU_LC_UNIT   (LC Work Unit ID)   C536870920    "NU_ENTRY_ORG"
NA_LC_SYMBOL   (LC Unit's Office Symbol)   C536870914    "NA_SYM"
NA_LC_SYMBOL  (LC Unit's Office Symbol) CB   "NA_SYM"
DT_DEFINED   (Date Defined in Table) n/an/a
DT_CLOSED   (Date LC Unit Closed) n/an/a


REMEDY Organization Table

Field Name in SYbase T17 ARSYstem NameType
T17.C536870921,CD_TYPE_ORGvarchar(1)
T17.C536870923NA_Key_Personvarchar(30)
T17.C8,NA_ORGvarchar(128)
T17.C536870914,NA_SYMvarchar(30)
T17.C536870918,NA_ORG_FLvarchar(95)
T17.C536870920,NU_ENTRY_ORGvarchar(4)
T17.C536870919,NU_ENTRY_PNTvarchar(25)
T17.C536870916,NU_MAIL_STOPvarchar(4)
T17.C536870915,NU_ORG_IDvarchar(9)
T17.C7,Statsinteger
T17.C536870912,TX_BLDG_RMvarchar(17)
C1Entry IDvarchar(15)
C2 varchar(30)
C6 integer
C536870917 integer

Notes on REMEDY Organization Table:
  1. To link the REMEDY Organization Table to the Employee Table, T16, in SQL, equate field T17.C536870915, NU_ORG_ID, to field T16.C536870925, NU_ORG_ASGND.
  2. The ARSystem name can vary (in fact, it can be anything at all) depending upon what the REMEDY Administrators decide to call a field when they are creating a screen. Usually administrators pick names which mean exactly what they are.

Return to top of table
Return to Validation Codes Table of Contents


Created: 4/3/98       Revised: 8/30/98
National Digital Library Program - Digital Repository Development Project
Comments: tmcc@loc.gov