| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TBH_TMPL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Template ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
TBH_PER_ORG |
Character(3) |
VARCHAR2(3) NOT NULL |
Organizational Relationship
CWR=Contingent Worker
EMP=Employee
|
| 4 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 5 |
CATEGORY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Category Code
Prompt Table:
HR_TBH_CTG_TBL
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 7 |
JOB_EFFDT |
Date(10) |
DATE |
Job Effective Date
|
| 8 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 9 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 10 |
AUTO_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Update Process
Y/N Table Edit
Default Value: Y
|
| 11 |
FED |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Functionality
Y/N Table Edit
Default Value: N
|
| 12 |
COUNTRY_NM_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Name Format Types
Prompt Table:
HR_TBH_NMSECVW
|
| 13 |
COUNTRY_AD_FORMAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Supported Address Format Types
Prompt Table:
HR_TBH_ADSECVW
|
| 14 |
TBH_SM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Search Match flag
Default Value: N
Prompt Table:
XL_PSYESNO_VW
|
| 15 |
SM_PARM_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
Prompt Table:
HCR_SM_PARM_TBL
|
| 16 |
SM_RSLT_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Search Match Result Code.
Prompt Table:
HCR_SM_RSLT_TBL
|
| 17 |
TBH_EU_DECIDES |
Character(1) |
VARCHAR2(1) NOT NULL |
End-User Decides
Default Value: N
Prompt Table:
XL_PSYESNO_VW
|
| 18 |
TBH_PERORGSUMM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Per Org Summary
Default Value: N
Prompt Table:
XL_PSYESNO_VW
|
| 19 |
TBH_HR_DECIDES |
Character(1) |
VARCHAR2(1) NOT NULL |
End-User Decides
Y/N Table Edit
Default Value: N
|
| 20 |
TBH_ACT_MANY_INCTV |
Character(4) |
VARCHAR2(4) NOT NULL |
Action One Inactive
HIRN=Hire Using New Instance
HRPR=Send to HR Administrator
Default Value: HRPR
|
| 21 |
TBH_ACT_ONE_INCTV |
Character(4) |
VARCHAR2(4) NOT NULL |
Action One Inactive
HIRE=Hire Using Existing Instance
HIRN=Hire Using New Instance
HRPR=Send to HR Administrator
REHR=Rehire Using Existing Instance
Default Value: HRPR
|
| 22 |
TBH_HIR_NEWINST |
Character(1) |
VARCHAR2(1) NOT NULL |
Hire New Instance
Y/N Table Edit
Default Value: N
|
| 23 |
TBH_HIR_OLDINST |
Character(1) |
VARCHAR2(1) NOT NULL |
Hire Old Instance
Y/N Table Edit
Default Value: N
|
| 24 |
TBH_REH_OLDINST |
Character(1) |
VARCHAR2(1) NOT NULL |
Rehire Old Instance
Y/N Table Edit
Default Value: N
|
| 25 |
TBH_SUBMIT_TO_HR |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to determine whether or not the End-User will be able to submit a template to HR instead of saving the data to the Core tables.
Y/N Table Edit
Default Value: Y
|
| 26 |
TBH_COMM_ALL_PAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to determine whether comments will be shown on all pages or only the last page of the template.
Y/N Table Edit
Default Value: Y
|
| 27 |
TBH_CONTRACT_LINK |
Character(1) |
VARCHAR2(1) NOT NULL |
Link to the Contract Data component.
Y/N Table Edit
Default Value: N
|
| 28 |
TBH_TMPL_TXN_TYP |
Character(10) |
VARCHAR2(10) NOT NULL |
Template Transaction Type
Default Value: HIRE
Prompt Table:
HR_MNG_TXN_VW1
|