R_ACTION_COUNTS(SQL Table) |
Index Back |
|---|---|
Report Work AreaThis is a temporary work area used by the system during SQR report processing. You don't need to touch this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPARTMENT | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BEGINS | Number(3,0) | SMALLINT NOT NULL | BEGINS |
| 4 | HIRES | Number(3,0) | SMALLINT NOT NULL | HIRES |
| 5 | RETIRES | Number(3,0) | SMALLINT NOT NULL | Retires |
| 6 | XFERSIN | Number(3,0) | SMALLINT NOT NULL | TRANSFERS IN |
| 7 | XFERSOUT | Number(3,0) | SMALLINT NOT NULL | TRANSFERSOUT |
| 8 | TERMINATIONS | Number(3,0) | SMALLINT NOT NULL | TERMINATIONS |
| 9 | ENDS | Number(3,0) | SMALLINT NOT NULL | ENDS |