PTAFCRTA_REC(SQL Table) |
Index Back |
|---|---|
Criteria DefinitionCriteria can be defined as queries, application classes & SQL Definitions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTAFCRTA_ID |
Character(100) | VARCHAR2(100) NOT NULL | Criteria ID |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
| 5 | AMT_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Amount Record
Prompt Table: PTAFAMT_REC_VW |
| 6 | AMT_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Amount Field Name
Prompt Table: PTAFAMTRECFIELD |
| 7 | PTAFCRITERIA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag for whether all criteria are needed or any
A=All O=One |
| 8 | PTAFAMOUNT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Amount Field
N=No Y=Yes Default Value: N |
| 9 | PTAFCRTA_OP_NUM | Character(2) | VARCHAR2(2) NOT NULL |
Criteria Operator
<=Less Than >=Greater Than B=Between(Inclusive) Default Value: > |
| 10 | AMOUNT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |
| 11 | AMOUNT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 13 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 14 | RECNAME_CUR | Character(15) | VARCHAR2(15) NOT NULL |
Currency Record
Prompt Table: PSRECDEFNPVW |
| 15 | FIELDNAME_CUR | Character(18) | VARCHAR2(18) NOT NULL |
Currency Field
Prompt Table: PTAFAMTRECFIELD |
| 16 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |