GP_ABS_LVDN_AET(SQL Table) |
Index Back |
|---|---|
Leave Donations CacheLeave Donations Main Cache Record |
| # | 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 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN1_VW |
| 5 | STRM_NUM | Number(4,0) | SMALLINT NOT NULL | Stream Number |
| 6 | EMPLID_FROM | Character(11) | VARCHAR2(11) NOT NULL | EMPLID (first for a range) |
| 7 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | Empl ID To |
| 8 | PRD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Period Type
C=Current R=Retro |
| 9 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 10 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 11 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 13 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 14 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 15 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 16 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 17 | LVDN_PRGM_ID | Character(10) | VARCHAR2(10) NOT NULL | Leave Program |
| 18 | BGN_DT | Date(10) | DATE | Begin Date |
| 19 | END_DT | Date(10) | DATE | end date |
| 20 | LVDN_PRGM_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Leave Donation Program Category
B=Bank I=Individual |
| 21 | LVDN_REQUEST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Leave Donation Request Type
ADJ=Adjust DON=Donate RCV=Receive RET=Return TER=Terminate |
| 22 | LVDN_CONTRIB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Leave Donation Contribution Type
B=Recurring or One-Time O=One-Time R=Recurring |
| 23 | TOTAL_LVDN_UNITS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Total Leave Donation Units |
| 24 | RETURNED_LVDN_UNIT | Number(7,2) | DECIMAL(6,2) NOT NULL | Returned Leave Donation Units |
| 25 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 26 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 27 | PROCESSED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Leave Donations Batch Process to indicate whether to process a request or not.
N=Processing Not Applicable X=Processing Cancelled Y=Process |
| 28 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 29 | LVDN_PIN_NUM_ELIG | Number(8,0) | INTEGER NOT NULL | Eligible Entitlement |
| 30 | LVDN_PIN_NUM | Number(8,0) | INTEGER NOT NULL | Leave Donation Target Entitlement |
| 31 | LVDN_UNITS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Leave Donation Request Units |
| 32 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 33 | RECIPIENT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Leave Donation Recipient Emplid |
| 34 | RECIPIENT_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Recipient Nbr |
| 35 | RETURNED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Leave Returned Flag |
| 36 | TRANSACTION_NBR_LD | Number(15,0) | DECIMAL(15) NOT NULL | Transaction Nbr is used in LVDN process for recurring donate requests. |
| 37 | CURR_AVAILABLE_BAL | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Maximum Hours |
| 38 | TOT_ADJUSTED_UNITS | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Total Adjusted Units |
| 39 | TOT_DONATED_UNITS | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Total Donated Units |
| 40 | TOT_RECEIVED_UNITS | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Total Received Units |
| 41 | TOT_RETURNED_UNITS | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Leave Donation Program Total Returned Units |
| 42 | FREQ_ANNUAL_FACTOR | Number(12,7) | DECIMAL(11,7) NOT NULL | Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year. |
| 43 | LVDN_PRG_ANN_FREQ | Number(12,7) | DECIMAL(11,7) NOT NULL | Annual Frequency Factor for Recurring Leave Donations Program |
| 44 | DEFER_PROCESSING | Character(1) | VARCHAR2(1) NOT NULL | Flag for deferred LVDN Processing |
| 45 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 46 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 47 | EOAWPARENT_THREAD | Number(15,0) | DECIMAL(15) NOT NULL | Parent Thread ID |
| 48 | LVDN_RECUR_CREATED | Character(1) | VARCHAR2(1) NOT NULL | Recurring Row Created Flag |