TRW_STMT_IDEMPLIDTRW_STMT_RCDEMPL_RCDN=Not Applicable
P=Primary Job
S=Secondary Job
TRW_EE_STMT_JBI(SQL Table) |
Index Back |
|---|---|
TRW EE Stmt Jobs Included RcdThis table stores information about the employee job(s) that were included in the total rewards employee statement. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRW_STMT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Reward Statement ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | TRW_STMT_RCD |
Number(3,0) | SMALLINT NOT NULL | Statement Record |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 6 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 7 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |