HMCR_TEST_IDHMCR_PORTAL_LABELTYPENAMEPARENT_SEQNUMPROPNAMESEQNUM0=Character
2=Number
4=Date
6=Boolean
8=DateTime
0=AND
1=OR
HMCR_TYPE_PROP(SQL Table) |
Index Back |
|---|---|
Services TesterRecord storing user test information for Service Tester |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HMCR_TEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Test Name |
| 2 | HMCR_PORTAL_LABEL |
Character(30) | VARCHAR2(30) NOT NULL | Service/Exception/Type name for storing in cache |
| 3 | TYPENAME |
Character(30) | VARCHAR2(30) NOT NULL | Type Name |
| 4 | PARENT_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | PROPNAME |
Character(30) | VARCHAR2(30) NOT NULL | Property Name |
| 6 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | HMCR_IFC_UUID | Character(30) | VARCHAR2(30) NOT NULL | UUID of the service |
| 8 | HMCR_RECFIELDTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Record Field type
0=Character 2=Number 4=Date 6=Boolean 8=DateTime |
| 9 | REQUIRED_FIELD | Character(1) | VARCHAR2(1) NOT NULL | * Required Field |
| 10 | NUM_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Numeric Value |
| 11 | DATE1 | Date(10) | DATE | Date 1 |
| 12 | BOOLEAN_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
AND\OR
0=AND 1=OR |
| 13 | DESCRLONG | Long Character | CLOB | Long Description |