ROLENAMEATTRIBUTE_NAMEPrompt Table: WC_ATTRIB_HDR
SEQ_NUMPrompt Table: WC_ATTRIB_COND
1=Sum
2=Count
3=Minimum
4=Maximum
<=less than
<==less than or equal to
<>=not equal
==equal
>=greater than
>==greater than or equal to
WC_ROLE_DTL(SQL Table) |
Index Back |
|---|---|
Dyn Role query dtl tableThis table contains all the detail of the query plus the bind values to be used for the role. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | ATTRIBUTE_NAME |
Character(30) | VARCHAR2(30) NOT NULL |
Attribute Name
Prompt Table: WC_ATTRIB_HDR |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Prompt Table: WC_ATTRIB_COND |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 7 | WC_AGGREGATE_FUNC | Character(1) | VARCHAR2(1) NOT NULL |
Function
1=Sum 2=Count 3=Minimum 4=Maximum |
| 8 | WC_OPERATOR_2 | Character(2) | VARCHAR2(2) NOT NULL |
Operator
<=less than <==less than or equal to <>=not equal ==equal >=greater than >==greater than or equal to |
| 9 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 10 | WC_VALUE_CHAR | Character(30) | VARCHAR2(30) NOT NULL | Value |
| 11 | WC_VALUE_NUM | Signed Number(29,0) | DECIMAL(28) NOT NULL | Value |