GP_PI_GEN_SOVR(SQL Table) |
Index Back |
---|---|
Generated PI-SOVRThis contains SOVRs for generated PI. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group | |
4 | Character(18) | VARCHAR2(18) NOT NULL | calendar id | |
5 | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar ID | |
6 | Number(3,0) | SMALLINT NOT NULL | PI version number | |
7 | Number(8,0) | INTEGER NOT NULL | PIN Number | |
8 | Character(1) | VARCHAR2(1) NOT NULL |
Positive Input Source
A=Absence G=Generated PI M=Manual T=Time&Labor |
|
9 | Number(3,0) | SMALLINT NOT NULL | Instance of Generated PI | |
10 | Date(10) | DATE | end date | |
11 | Number(8,0) | INTEGER NOT NULL | Supporting Element PIN Number | |
12 | ENTRY_TYPE_SOVR | Character(3) | VARCHAR2(3) NOT NULL | entry type sovr |
13 | SOVR_VAL_CHAR | Character(25) | VARCHAR2(25) NOT NULL | Supporting Element Character Value |
14 | SOVR_VAL_NUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Supporting Element Numeric Value |
15 | SOVR_VAL_DT | Date(10) | DATE | Date Value |
16 | PIN_SOVR_SETID_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
17 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
18 | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |