P11D_SOLUTION_IDP11D_EXTRACT_IDPrompt Table: GPGB_P11D_E_TYP
Prompt Table: PSRECDEFN
GPGB_P11D_EXT(SQL Table) |
Index Back |
|---|---|
P11D Extract DefinitionExtract types for third party P11D solution |
| # | 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 | P11D_EXTRACT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
P11D Extract Type
Prompt Table: GPGB_P11D_E_TYP |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 6 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |