EP_XFER_AET

(SQL Table)
Index Back

Automated Cancellation record

Record storing employee data to cancel document later using AE program.

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 EP_CREATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time a document was created.
7 EP_SELECT_SW Character(1) VARCHAR2(1) NOT NULL Switch that determines if the row is selected. This field is used in the Document Selection page for express transactions (Transfer, Cancel, etc.).

Y/N Table Edit

Default Value: N