EP_REVIEW_TYPEPrompt Table: EP_REVW_TYP_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
EP_INSTAL_EE_X(SQL Table) |
Index Back |
|---|---|
Document Type: SetupStores Review Type to be used for automated transfer of employee's documents |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: EP_REVW_TYP_VW |
| 2 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 3 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | EP_DAYS_TO_END | Number(3,0) | SMALLINT NOT NULL | Number of Days until Period End Date. Used for Auto Transfer when EE changes jobs. |
| 5 | EP_ADD_MGR_PEER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No, Add the manager as a participant.
Used for Auto Transfer when EE changes jobs.
Y/N Table Edit Default Value: N |
| 6 | EP_XFER_AFT_END_SW | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No, transfer documents after their period end dates.
Used for Auto Transfer when EE changes jobs.
Y/N Table Edit Default Value: N |