RECNAMEPrompt Table: HR_TBH_RECLKPVW
INSTANCEDefault Value: 1
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
HR_TBH_RECDEFN(SQL Table) |
Index Back |
|---|---|
Template Record Setup TableThe Template Record Setup Table will simply contain one row for each table currently included in the core Hire processes with at least one enterable field (e.g. PERSON, JOB, GVT_JOB). Multiple instances of the same record can be added (e.g. phone numbers, email addresses etc). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: HR_TBH_RECLKPVW |
| 2 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL |
Instance Number
Default Value: 1 |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | ALIAS_TBL_NAME | Character(18) | VARCHAR2(18) NOT NULL | Alias Table Name |
| 5 | TBH_USE_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Template-Based Hire Use Only
Y/N Table Edit Default Value: N |
| 6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |