TBH_TMPL_TXN_TYPB=Update Person and Job
H=Hire/Rehire
J=Update Job
N=Neither
P=Update Person
Default Value: H
HR_TBH_TXN_SCH(SQL View) |
Index Back |
|---|---|
Template Transaction Type TblThe Template TransactionTable will store the template transaction types. |
| SELECT TBH_TMPL_TXN_TYP , DESCR50 , TBH_PERSON_JOB_IND FROM PS_HR_TBH_TXN_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TBH_TMPL_TXN_TYP |
Character(10) | VARCHAR2(10) NOT NULL | Template Transaction Type |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | TBH_PERSON_JOB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Person/Job Indicator
B=Update Person and Job H=Hire/Rehire J=Update Job N=Neither P=Update Person Default Value: H |