PROCESS_INSTANCEDefault Value: %date
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
A=Active
I=Inactive
FT_PRSNWRKR_AET(SQL Table) |
Index Back |
|---|---|
Person / Worker Extract AETState record for Person / Worker Extract AE program |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | PER_ORG | Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest |
| 7 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |
| 8 | ORG_INSTANCE_ERN | Number(3,0) | SMALLINT NOT NULL | Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level. |
| 9 | ROW_COUNT2 | Number(8,0) | INTEGER NOT NULL | Number of rows. |
| 10 | CURRENT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Currently Assigned To |
| 11 | CURRENT_PER_ORG | Character(3) | VARCHAR2(3) NOT NULL | Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. |
| 12 | CURR_ORG_INST_ERN | Signed Number(4,0) | DECIMAL(3) NOT NULL | Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level. |
| 13 | CURRENT_EMPL_RCD | Signed Number(4,0) | DECIMAL(3) NOT NULL | Current Empl Record Number |
| 14 | CURR_EFFDT | Date(10) | DATE | Current Benefit Date |
| 15 | CURRENT_EFFSEQ | Signed Number(4,0) | DECIMAL(3) NOT NULL | Current Effective Sequence Nbr |
| 16 | CURRENT_HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Current HR Status |
| 17 | MAX_DATE | Date(10) | DATE | Maximum Date |
| 18 | LATEST_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Latest Effective Sequence |
| 19 | MAX_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Maximum Effective Sequence |
| 20 | PRIMARY_ASSIGN_FLG | Character(1) | VARCHAR2(1) NOT NULL | Primary Assignment Flag |
| 21 | PRIMARY_RECORD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Primary Record Flag |
| 22 | EMPLID_CHG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Employee ID Changed Flag |
| 23 | ORG_INST_CHG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Org Instance Ern Changed Flag |
| 24 | ACTION_CHG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Action Changed Flag |
| 25 | EMPL_RCD_CHG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Employee Record # Changed Flag |
| 26 | NEW_WORK_TERMS_FLG | Character(1) | VARCHAR2(1) NOT NULL | New Work Terms Record Flag |
| 27 | NEW_ASSIGNMENT_FLG | Character(1) | VARCHAR2(1) NOT NULL | New Assignment Flag |
| 28 | WORK_TERMS_COUNT | Number(8,0) | INTEGER NOT NULL | Number of rows. |
| 29 | WRK_TRM_TOT_COUNT | Number(8,0) | INTEGER NOT NULL | Number of rows. |
| 30 | ASSIGNMENT_COUNT | Number(8,0) | INTEGER NOT NULL | Number of rows. |
| 31 | ASSIGNMENT_COUNT2 | Number(8,0) | INTEGER NOT NULL | Number of rows. |
| 32 | WT_ASSIGN_COUNT | Number(8,0) | INTEGER NOT NULL | Number of rows. |