INFORMATION FOR...
navigation
Views
Views (sql select queries that behave like tables) are the core to the Business Apps database. They limit the data, remove unnecessary fields, and join to basic decode tables. Each index in the Business Apps Access database ties to one view.
The "create" statement for each view is linked to below.
Views
| View | Where | Notes |
| v_FIN_NonPayroll | OL_DETL_EXPS_AMT <> 0 AND (FIN_ACCT_CD < '20000' OR FIN_ACCT_CD IN ('219240', '219260')) | |
| v_FIN_Payroll | ||
| v_HR_CurrentPositions | JOB_DETL_STATUS_DESC = 'Active' | only 'Current' jobs are downloaded |
| v_HR_Transactions | ||
| v_HR_TransactionView | ||
| v_HR_Transaction_x_Foapal | ||
| V_T_PCARD_TRAN_DETL | pcard cardholder, authorizer, approver only populate if they're in v_pers_hist table | |
| v_T_OL_SUM | Tricky join: LEFT(T_OL_SUM.FIN_ACCT_CD, 1) = T_FIN_ACCT_TYPE_CD_HIST.FIN_ACCT_TYPE_CD | |
| v_PH_PINNACLE |