P11D_SOLUTION_IDP11D_EXTRACT_IDSEQNUMPrompt Table: PSRECFIELDALL
GPGB_P11D_MP_VW(SQL View) |
Index Back |
|---|---|
P11D Field Mapping ViewField Mapping for third party P11D solution. This view shows only the fields actually appearing in the output file. |
| SELECT P11D_SOLUTION_ID ,P11D_EXTRACT_ID ,SEQNUM ,FIELDNAME ,P11D_COLUMN_HEAD ,P11D_METHOD ,P11D_CONSTANT FROM PS_GPGB_P11D_MAP WHERE P11D_INCLUDE_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | P11D_SOLUTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | P11D Solution ID |
| 2 | P11D_EXTRACT_ID |
Character(10) | VARCHAR2(10) NOT NULL | P11D Extract ID |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
| 5 | P11D_COLUMN_HEAD | Character(50) | VARCHAR2(50) NOT NULL | P11D Column Heading |
| 6 | P11D_METHOD | Character(30) | VARCHAR2(30) NOT NULL | Holds name of Application Class Method. |
| 7 | P11D_CONSTANT | Character(30) | VARCHAR2(30) NOT NULL | Constant |