AM_USD_AF_HDR(SQL Table) |
Index Back |
---|---|
AM USD AF HeaderAM 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 |