HCMD_CLASSIDHCMD_PARAMIDA=Active
I=Inactive
Default Value: A
Prompt Table: HCMD_VAR_VW
N=N
Y=Y
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
HCMD_FPAR_TBL(SQL Table) |
Index Back |
|---|---|
Service Parameters TableService Parameters Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 2 | HCMD_PARAMID |
Character(30) | VARCHAR2(30) NOT NULL | Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor |
| 3 | ORDERNO | Number(5,0) | INTEGER NOT NULL | Sort Order |
| 4 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |
| 5 | HCMD_PARAMTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Type
Prompt Table: HCMD_VAR_VW |
| 6 | HCMD_PARAMNAME | Character(30) | VARCHAR2(30) NOT NULL | Alias |
| 7 | HCMD_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=N Y=Y Y/N Table Edit Default Value: N |
| 8 | CONSTANT_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Constant Only
Y/N Table Edit Default Value: N |
| 9 | UPDATEABLE | Character(1) | VARCHAR2(1) NOT NULL |
This field was designed for EIM Roles. It specifies whether users of a given role can update information related to participants
Y/N Table Edit Default Value: N |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |