GPGB_P11D_AET(SQL Table) |
Index Back |
|---|---|
State Record for P11DState Record for P11D Extractor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | GPGB_TAX_END_YR | Number(4,0) | SMALLINT NOT NULL | Tax Year Ends In This Calendar Year |
| 5 | P11D_SOLUTION_ID | Character(10) | VARCHAR2(10) NOT NULL |
P11D Solution ID
Prompt Table: GPGB_P11D_SOL |
| 6 | P11D_EXTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | P11D Extract ID |
| 7 | P11D_EXTRACT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | P11D Extract Type |
| 8 | P11D_COLUMN_HEAD | Character(50) | VARCHAR2(50) NOT NULL | P11D Column Heading |
| 9 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 10 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 11 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 12 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 13 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 14 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 15 | P11D_METHOD | Character(30) | VARCHAR2(30) NOT NULL | Holds name of Application Class Method. |
| 16 | P11D_CONSTANT | Character(30) | VARCHAR2(30) NOT NULL | Constant |
| 17 | P11D_INCLUDE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether field is included in the P11D Extract output file |
| 18 | P11D_DT_IN_TAX_YR | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if date field falls within the tax year.
0=None 1=Specific date 2=Start date of period 3=End date of period |
| 19 | P11D_XLAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Detrmines whether to use the code, short xlat description or long xlat description.
1=Code 2=Xlat Short Description 3=Xlat Long Description |
| 20 | P11D_EXCLUDE_ROW | Character(1) | VARCHAR2(1) NOT NULL | Determines if row is excluded from output file. |
| 21 | P11D_GEN_LOG_FILE | Character(1) | VARCHAR2(1) NOT NULL | Flag to indicate whether a log file is to be generated by the P11D Extractor App Engine process. |
| 22 | P11D_DEBUG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether debug info is written to the log file generated by the P11D Extractor App Engine process.
Y/N Table Edit Default Value: N |
| 23 | GPGB_TXYR_BGN_DT | Date(10) | DATE | GPUK Tax Year Begin Date |
| 24 | GPGB_TXYR_END_DT | Date(10) | DATE | GPUK Tax Year End Date |
| 25 | SQL_TEXT | Character(80) | VARCHAR2(80) NOT NULL | SQL Text |
| 26 | SQL_TEXT1 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 1 |
| 27 | SQL_TEXT2 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 2 |
| 28 | SQL_TEXT3 | Character(254) | VARCHAR2(254) NOT NULL | Used to hold dynamic SQL Text |
| 29 | SQL_TEXT4 | Character(254) | VARCHAR2(254) NOT NULL | Used to hold dynamic SQL Text |
| 30 | P11D_CHAR50_KEY1 | Character(50) | VARCHAR2(50) NOT NULL | P11D Result Key Field |
| 31 | P11D_DATE_KEY1 | Date(10) | DATE | P11D Result Key Field |
| 32 | P11D_CHAR1_01 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 33 | P11D_CHAR1_02 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 34 | P11D_CHAR1_03 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 35 | P11D_CHAR1_04 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 36 | P11D_CHAR1_05 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 37 | P11D_CHAR1_06 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 38 | P11D_CHAR1_07 | Character(1) | VARCHAR2(1) NOT NULL | P11D Result Field |
| 39 | P11D_CHAR10_01 | Character(10) | VARCHAR2(10) NOT NULL | P11D Result Field |
| 40 | P11D_CHAR10_02 | Character(10) | VARCHAR2(10) NOT NULL | P11D Result Field |
| 41 | P11D_CHAR20_01 | Character(20) | VARCHAR2(20) NOT NULL | P11D Result Field |
| 42 | P11D_CHAR20_02 | Character(20) | VARCHAR2(20) NOT NULL | P11D Result Field |
| 43 | P11D_CHAR20_03 | Character(20) | VARCHAR2(20) NOT NULL | P11D Result Field |
| 44 | P11D_CHAR20_04 | Character(20) | VARCHAR2(20) NOT NULL | P11D Result Field |
| 45 | P11D_CHAR20_05 | Character(20) | VARCHAR2(20) NOT NULL | P11D Result Field |
| 46 | P11D_CHAR30_01 | Character(30) | VARCHAR2(30) NOT NULL | P11D Result Field |
| 47 | P11D_CHAR30_02 | Character(30) | VARCHAR2(30) NOT NULL | P11D Result Field |
| 48 | P11D_CHAR50_01 | Character(50) | VARCHAR2(50) NOT NULL | P11D Result Field |
| 49 | P11D_CHAR50_02 | Character(50) | VARCHAR2(50) NOT NULL | P11D Result Field |
| 50 | P11D_CHAR50_03 | Character(50) | VARCHAR2(50) NOT NULL | P11D Result Field |
| 51 | P11D_CHAR50_04 | Character(50) | VARCHAR2(50) NOT NULL | P11D Result Field |
| 52 | P11D_CHAR50_05 | Character(50) | VARCHAR2(50) NOT NULL | P11D Result Field |
| 53 | P11D_DATE_01 | Date(10) | DATE | P11D Result Field |
| 54 | P11D_DATE_02 | Date(10) | DATE | P11D Result Field |
| 55 | P11D_DATE_03 | Date(10) | DATE | P11D Result Field |
| 56 | P11D_DATE_04 | Date(10) | DATE | P11D Result Field |
| 57 | P11D_DATE_05 | Date(10) | DATE | P11D Result Field |
| 58 | P11D_DATE_06 | Date(10) | DATE | P11D Result Field |
| 59 | P11D_DATE_07 | Date(10) | DATE | P11D Result Field |
| 60 | P11D_DATE_08 | Date(10) | DATE | P11D Result Field |
| 61 | P11D_NUMBER_01 | Number(12,3) | DECIMAL(11,3) NOT NULL | P11D Result Field |
| 62 | P11D_NUMBER_02 | Number(12,3) | DECIMAL(11,3) NOT NULL | P11D Result Field |
| 63 | P11D_NUMBER_03 | Number(12,3) | DECIMAL(11,3) NOT NULL | P11D Result Field |
| 64 | P11D_NUMBER_04 | Number(12,3) | DECIMAL(11,3) NOT NULL | P11D Result Field |
| 65 | P11D_NUMBER_05 | Number(12,3) | DECIMAL(11,3) NOT NULL | P11D Result Field |