PTAFCRTA_IDSEQ_NBRDefault Value: 0
RECNAMEPrompt Table: RECDEFN_VW
FIELDNAMEPrompt Table: PSRECFIELDALL
AMT_RECNAMEPrompt Table: PSRECDEFN_VW
AMT_FLDNAMEPrompt Table: PTAFAMTRECFIELD
LANGUAGE_CDPTAFCRTA_RECLNG(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
Default Value: 0 |
| 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: PSRECDEFN_VW |
| 6 | AMT_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Amount Field Name
Prompt Table: PTAFAMTRECFIELD |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |