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 | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |
| 10 | TEXT_MSG | Character(100) | VARCHAR2(100) NOT NULL | Text Message |
| 11 | PSHUP_INACT_EMP | Character(1) | VARCHAR2(1) NOT NULL | This indicates if PSHUP Inactive Employees feature will be used by the customer |
| 12 | DESCR10 | Character(10) | VARCHAR2(10) NOT NULL | Description field of length 10 |
| 13 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 14 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 15 | DESCR65 | Character(65) | VARCHAR2(65) NOT NULL | Field used to hold a character field of up to length 65 |