GPGB_P11D_MAP(SQL Table) |
Index Back |
---|---|
P11D Field MappingField Mapping 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 | 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 |
8 | P11D_INCLUDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether field is included in the P11D Extract output file
Y/N Table Edit Default Value: Y |
9 | 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 Default Value: 0 |
10 | 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 Default Value: 1 |
11 | P11D_EXCLUDE_ROW | Character(1) | VARCHAR2(1) NOT NULL |
Determines if row is excluded from output file.
Y/N Table Edit Default Value: N |