PROCESS_INSTANCEC=Complete
V=Void
X=W-2c Issued
AA_CONV_JPN_AET(SQL Table) |
Index Back |
|---|---|
Additional Appt ConversionThis program converts the data stored in ADD_APPT_JPN into concurrent records stored on the JOB table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | EMPL_RCD_JPN | Signed Number(4,0) | DECIMAL(3) NOT NULL | Tracks the empl_rcd of an additional appointment. This is used in records that also lists the main appointment empl_rcd. |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 12 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
C=Complete V=Void X=W-2c Issued |
| 13 | AE_INT_2 | Number(2,0) | SMALLINT NOT NULL | Number Work Field |
| 14 | AE_INT_3 | Number(3,0) | SMALLINT NOT NULL | Number Work Field |
| 15 | AE_INT_4 | Number(4,0) | SMALLINT NOT NULL | Number Work Field |
| 16 | AE_INT_5 | Number(5,0) | INTEGER NOT NULL | Number Work Field |
| 17 | AE_INT_6 | Number(6,0) | INTEGER NOT NULL | Number Work Field |
| 18 | AE_INT_7 | Number(7,0) | INTEGER NOT NULL | Number Work Field |
| 19 | AE_INT_8 | Number(8,0) | INTEGER NOT NULL | Number Work Field |
| 20 | AE_INT_9 | Number(9,0) | DECIMAL(9) NOT NULL | Number Work Field |
| 21 | AE_INT_10 | Number(10,0) | DECIMAL(10) NOT NULL | Number Work Field |
| 22 | AE_INT_11 | Number(11,0) | DECIMAL(11) NOT NULL | Number Work Field |
| 23 | AE_INT_12 | Number(12,0) | DECIMAL(12) NOT NULL | Number Work Field |
| 24 | AE_INT_13 | Number(13,0) | DECIMAL(13) NOT NULL | Number Work Field |
| 25 | AE_INT_14 | Number(14,0) | DECIMAL(14) NOT NULL | Number Work Field |
| 26 | AE_INT_15 | Number(15,0) | DECIMAL(15) NOT NULL | Number Work Field |