TBH_SEQRECNAMEPrompt Table: HR_TBH_RECDEFN
INSTANCEFIELDNAMEPrompt Table: HR_TBH_RECDTL
HR_TBH_DATA(SQL Table) |
Index Back |
|---|---|
Template Data TableTemplate Data Table.This staging table stores the data captured during a template-based hire. |
| # | 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 | TBH_CHAR | Character(70) | VARCHAR2(70) NOT NULL | Template Stage Charecter |
| 6 | TBH_DATE | Date(10) | DATE | Template Stage Date |
| 7 | TBH_TIME | Time(15) | TIMESTAMP | Template Time |
| 8 | TBH_DATETIME | DateTime(26) | TIMESTAMP | Template Stage Datetime |
| 9 | TBH_NUM | Number(19,6) | DECIMAL(18,6) NOT NULL | Template Stage Number |