R_PER001(SQL Table) |
Index Back |
|---|---|
Temp Table for SQR PER001This is a temporary work area used by the system during SQR report processing for report PER001. You don't need to touch this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RPTID | Character(4) | VARCHAR2(4) NOT NULL | RptID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | DEPARTMENT | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 4 | EMPLNAME | Character(50) | VARCHAR2(50) NOT NULL | EmplName |
| 5 | EMPLNAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate EmplName |
| 6 | NOTICEDATE | Date(10) | DATE | NoticeDate |
| 7 | SPECIALFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | SpecialField1 |