EMPLIDEMPL_RCDDefault Value: 0
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
Default Value: N
HR_PORG_TMP(SQL Table) |
Index Back |
|---|---|
Temp table Per Org Asg RefreshTemp table Per Org Asg Refresh AE - HR_PERORGASN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 4 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 5 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Default Value: 0 |
| 6 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 7 | BUSINESS_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Business Title |
| 8 | POSITION_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Phone number for the Position |
| 9 | AE_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now Default Value: N |
| 10 | ERROR_TEXT | Long Character | CLOB | Error Text |