HPCNTPAY02A_AET(SQL Table) |
Index Back |
|---|---|
AE state rec for Contract PayAE state record for E&G contract pay renewal process. AE program HP_CNTPAY02. |
| # | 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 | CURRENT_DT | Date(10) | DATE | Current Effective Date |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 7 | RENEWAL_DAYS_OUT | Number(3,0) | SMALLINT NOT NULL | Public Sector Extension This is a run control field. It is used to indicate the number of days forward from the current date within which the batch process (CNTPAY02.SQR) will search for expiring contracts to be renewed. |
| 8 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL | Holiday Schedule |
| 9 | WORK_SCHEDULE | Character(7) | VARCHAR2(7) NOT NULL | Work Schedule |
| 10 | HP_WORKDAYS | Number(3,0) | SMALLINT NOT NULL | Stores actual work days for contract period |
| 11 | DATE_COUNT | Number(3,0) | SMALLINT NOT NULL | Date Counter |
| 12 | CONTRACT_BEGIN_DT | Date(10) | DATE | Contract Begin Date |
| 13 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 14 | YES | Character(1) | VARCHAR2(1) NOT NULL | Yes |
| 15 | NO | Character(1) | VARCHAR2(1) NOT NULL | No |
| 16 | FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag |
| 17 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 18 | FLAG2 | Character(1) | VARCHAR2(1) NOT NULL | Flag2 |
| 19 | FLAG3 | Character(1) | VARCHAR2(1) NOT NULL | Flag3 |
| 20 | FLAG4 | Character(1) | VARCHAR2(1) NOT NULL | Flag4 |
| 21 | DATA_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Data Exists
Default Value: N |
| 22 | FREQUENCY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the type of a frequency ID.
A=Annual B=Biweekly C=Contract D=Daily F=Every Four Weeks H=Hourly M=Monthly Q=Quarterly S=Semimonthly W=Weekly Default Value: C |
| 23 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration Default Value: A |
| 24 | BEGINDTTM | DateTime(26) | TIMESTAMP | Begin Date/Time |