PROCESS_INSTANCEA=Amount
B=Hours or Amounts
H=Hours
Y/N Table Edit
Default Value: N
PYRE_VALID_AET(SQL Table) |
Index Back |
|---|---|
PYRE_VALID state recordThis is the state record for Ap Eng=PYRE_VALID, used for push-button logic on the Rapid Entry Paysheets. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PYRE_TMPLT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rapid Paysheets Template Type
A=Amount B=Hours or Amounts H=Hours |
| 3 | PYRE_TMPLT_ID | Character(15) | VARCHAR2(15) NOT NULL | Template ID for Rapid Entry Paysheets |
| 4 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 5 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit Default Value: N |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | EARNS_BEGIN_DT | Date(10) | DATE | Earnings Begin Date |
| 8 | EARNS_END_DT | Date(10) | DATE | Earnings End Date |
| 9 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 10 | TEXT_MSG | Character(100) | VARCHAR2(100) NOT NULL | Text Message |