TBH_SEQRECNAMEPrompt Table: HR_TBH_RECDEFN
INSTANCEFIELDNAMEPrompt Table: HR_TBH_RECDTL
GP_ABS_DATA(SQL Table) |
Index Back |
|---|---|
Template Data TableConfigurable Sections: Template Data Table.This staging table stores the data captured during a Absence template-based process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TBH_SEQ |
Number(12,0) | DECIMAL(12) NOT NULL | Template Sequence |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: HR_TBH_RECDEFN |
| 3 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HR_TBH_RECDTL |
| 5 | GP_ABS_CS_CHAR | Character(70) | VARCHAR2(70) NOT NULL | Configurable Sections Setup: Template Stage Charecter |
| 6 | GP_ABS_CS_DATE | Date(10) | DATE | Configurable Sections Setup: Template Stage Date |
| 7 | GP_ABS_CS_TIME | Time(15) | TIMESTAMP | Configurable Sections Setup: Template Time |
| 8 | GP_ABS_CS_DATETIME | DateTime(26) | TIMESTAMP | Configurable Sections Setup: Template Stage Datetime |
| 9 | GP_ABS_CS_NUM | Number(19,6) | DECIMAL(18,6) NOT NULL | Template Stage Number |