HCMD_OATT_TBL(SQL Table) |
Index Back |
|---|---|
Object Descriptor AttributesCreated 2/18/02 by Eric Solberg |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 2 | HCMD_ATTRIBID |
Character(30) | VARCHAR2(30) NOT NULL | Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor |
| 3 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 4 | HCMD_ATTRIBNAME | Character(30) | VARCHAR2(30) NOT NULL | Attribute Name Alias |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | HCMD_ALLOWMODIFY | Character(1) | VARCHAR2(1) NOT NULL |
Created by Eric Solberg 2/18/02
Y if in-field modifications allowed to this field
Y/N Table Edit Default Value: N |
| 8 | HCMD_ALLOWDELETE | Character(1) | VARCHAR2(1) NOT NULL |
Created by Eric Solberg 2/18/02
Y if in-field removal of this field is allowed
Y/N Table Edit Default Value: N |
| 9 | HCMD_USEINQUERIES | Character(1) | VARCHAR2(1) NOT NULL |
Use in Queries?
Y/N Table Edit Default Value: N |
| 10 | HCMD_USEINRULES | Character(1) | VARCHAR2(1) NOT NULL |
Use in Rules?
Y/N Table Edit Default Value: N |
| 11 | HCMD_USEINUI | Character(1) | VARCHAR2(1) NOT NULL |
Use in UI?
Y/N Table Edit Default Value: N |
| 12 | HCMD_BUSKEY | Character(1) | VARCHAR2(1) NOT NULL |
Business key?
Default Value: N |
| 13 | DESCRLONG | Long Character | CLOB | Long Description |