PROCESS_INSTANCED=Days
M=Months
Y=Years
AP=Approved - Goes to Payroll
CN=Cancelled
NA=Needs Approval
PD=Paid
RP=Rejected by Payroll
RV=Reversed by Payroll
SP=Sent to Payroll
TP=Taken by Payroll
HRS_ERP_AWD_AET(SQL Table) |
Index Back |
|---|---|
ER_ERP_AWARD State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | REFERRAL_PGM_ID | Character(12) | VARCHAR2(12) NOT NULL | Employee referral program ID |
| 3 | REF_PGM_EFFDT | Date(10) | DATE | Referral Program Effective Dt |
| 4 | REQUIRE_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL | Require Approval for Payment |
| 5 | SEPCHK_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Separate check flag. |
| 6 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
| 7 | CURR_RULE_ID | Character(12) | VARCHAR2(12) NOT NULL | Current Rule ID |
| 8 | CURR_RULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Current Rule Type |
| 9 | DURATION | Number(5,0) | INTEGER NOT NULL | Recurrence Duration |
| 10 | DURATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Duration
D=Days M=Months Y=Years |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | AWARD_VALUE_ER | Number(16,2) | DECIMAL(15,2) NOT NULL | Award Value |
| 13 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL | Gross-Up |
| 14 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 15 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 16 | PAYMENT_STAT_ER | Character(2) | VARCHAR2(2) NOT NULL |
Payment Status
AP=Approved - Goes to Payroll CN=Cancelled NA=Needs Approval PD=Paid RP=Rejected by Payroll RV=Reversed by Payroll SP=Sent to Payroll TP=Taken by Payroll |
| 17 | DATE1 | Date(10) | DATE | Date 1 |
| 18 | DATE2 | Date(10) | DATE | Date 2 |
| 19 | FUTURE_DAYS | Number(10,0) | DECIMAL(10) NOT NULL | Days in the Future |
| 20 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 21 | WHERE_CLS_ER | Long Character(4096) | CLOB | Where Clause for Rules and Hot Jobs |
| 22 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 23 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 24 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 25 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |