AM_USD_AF_HDR

(SQL Table)
Index Back

AM USD AF Header

AM Upload Spreadsheet Data AF Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DATE_SUBMITTED Date(10) DATE Date Submitted
2 DTTM_STAMP 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.
3 ORIGINATOR_ID Character(30) VARCHAR2(30) NOT NULL Originator
4 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
5 APPROVER Character(11) VARCHAR2(11) NOT NULL Employee ID
6 DATE_APPROVED Date(10) DATE Date Approved
7 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
9 AM_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template ID
10 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
11 EMAIL_TEXT Character(250) VARCHAR2(250) NOT NULL EMAIL TEXT