PROCESS_INSTANCEB=Biweekly
D=Daily
S=Semi-Monthly
W=Weekly
EX_XMLP_RPT_AET(SQL Table) |
Index Back |
|---|---|
XMLP AET RecordAET record for the BI Publisher reports that use a query data source |
| # | 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 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 5 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | ASOFDATE | Date(10) | DATE | As of Date |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 9 | DESCR_BU | Character(30) | VARCHAR2(30) NOT NULL | Business Unit Description |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | DESCR_DEPTID | Character(30) | VARCHAR2(30) NOT NULL | (Department Name) |
| 12 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 13 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 14 | FROM_DATE | Date(10) | DATE | From Date |
| 15 | THRU_DATE | Date(10) | DATE | Through Date |
| 16 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 17 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL | Version Number |
| 18 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 19 | TIME_RPT_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Time Report Period
B=Biweekly D=Daily S=Semi-Monthly W=Weekly |
| 20 | HOURS_PER_DAY | Number(3,0) | SMALLINT NOT NULL | Hours Per Day |
| 21 | REGULAR_HOURS | Signed Number(17,3) | DECIMAL(15,3) NOT NULL | Regular Hours |
| 22 | POSSIBLE_HOURS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Possible Hours |
| 23 | PERIOD_HOURS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Period Hours |
| 24 | TOTAL_HOURS_EX | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Total Hours |
| 25 | OVERTIME_HOURS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Overtime Hours |
| 26 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 27 | COMPANY_PD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Company Paid Amount |
| 28 | PERSONAL_EXP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Personal Expense Amount (Non-Reimbursable) |
| 29 | PREPAID_EXP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Prepaid Expense Amount |
| 30 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 31 | AMOUNT_DUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Due |
| 32 | EX_INCLUDE_NOTES | Character(1) | VARCHAR2(1) NOT NULL | Include Expense Notes |
| 33 | CGST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | CGST Tax Amount |
| 34 | IGST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | IGST Tax Amount |
| 35 | SGST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SGST Tax Amount |