PSARCH_IDPSARCH_BATCHNUMTBH_SEQRECNAMEPrompt Table: HR_TBH_RECDEFN
INSTANCEFIELDNAMEPrompt Table: HR_TBH_RECDTL
HR_TBH_DATAHIST(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 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | TBH_SEQ |
Number(12,0) | DECIMAL(12) NOT NULL | Template Sequence |
| 4 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: HR_TBH_RECDEFN |
| 5 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 6 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: HR_TBH_RECDTL |
| 7 | TBH_CHAR | Character(70) | VARCHAR2(70) NOT NULL | Template Stage Charecter |
| 8 | TBH_DATE | Date(10) | DATE | Template Stage Date |
| 9 | TBH_TIME | Time(15) | TIMESTAMP | Template Time |
| 10 | TBH_DATETIME | DateTime(26) | TIMESTAMP | Template Stage Datetime |
| 11 | TBH_NUM | Number(19,6) | DECIMAL(18,6) NOT NULL | Template Stage Number |