ATTRIBUTE_NAMERECNAMEPrompt Table: WC_ATTRIB_REC
FIELDNAMEPrompt Table: PSRECFIELD
SEQ_NUM1=Sum
2=Count
3=Minimum
4=Maximum
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
WC_ATTRIB_COND(SQL Table) |
Index Back |
|---|---|
Dyn Role attribute conditionsthis is the building block for the conditional where clause that the end-user/marketing person can provide a bind value at role creation time. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ATTRIBUTE_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: WC_ATTRIB_REC |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELD |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 6 | WC_AGGREGATE_FUNC | Character(1) | VARCHAR2(1) NOT NULL |
Function
1=Sum 2=Count 3=Minimum 4=Maximum |
| 7 | WC_ALIAS_NAME_MIX | Character(20) | VARCHAR2(20) NOT NULL | Alias name |
| 8 | REQUIRED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
N=No Y=Yes Y/N Table Edit Default Value: Y |