emr_org_xwalk: The OPA Employee snapshot sql query in a form to be executed...
In iancj88/msuopa: Utility Functions for the MSU OPA Team
Description
Usage
Format
Source
Description
For readable formatting, replace /n with actual new lines characters and
then remove all instances of escape characters ('/'). Requires
'AS_OF_DATE_HERE' to be replaced with a valid character representation of
a date in the form YYYY-MM-DD. Also requires JOB_STATUSES_HERE string to be
replaced with a character vector comprised of atleast one value job status
abbreviations i.e. 'A', 'B', 'L'.
Usage
1
Format
A dataframe with 2487 rows and 4 variables:
- Dept Name
The Name of the dept as defined in FTVORGN table
- Dept Number
The six digit alpha-numeric dept. number as defined in
the FTVORGN table
- EMROrg
The EMR Org which the dept rolls up to. Originally created by
Glen Nethercut, 2014. Owned by OPA and maintained by Ian C Johnson
- VPOrg
The VP Org which is a slightly more aggregated rollup compared
to the EMROrg
Source
OPA Employee Access database
The EMR Organization Lookup table contains the crosswalk between organization
number, name, and higher-level organization known as 'EMROrg' and 'VPOrg.
Requires regular updates as dept numbers/names change. Numbers and names are
defined/governed by the Finance team.
iancj88/msuopa documentation built on May 17, 2019, 7:07 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Format Source
Description
For readable formatting, replace /n with actual new lines characters and then remove all instances of escape characters ('/'). Requires 'AS_OF_DATE_HERE' to be replaced with a valid character representation of a date in the form YYYY-MM-DD. Also requires JOB_STATUSES_HERE string to be replaced with a character vector comprised of atleast one value job status abbreviations i.e. 'A', 'B', 'L'.
Usage
1 |
Format
A dataframe with 2487 rows and 4 variables:
- Dept Name
The Name of the dept as defined in FTVORGN table
- Dept Number
The six digit alpha-numeric dept. number as defined in the FTVORGN table
- EMROrg
The EMR Org which the dept rolls up to. Originally created by Glen Nethercut, 2014. Owned by OPA and maintained by Ian C Johnson
- VPOrg
The VP Org which is a slightly more aggregated rollup compared to the EMROrg
Source
OPA Employee Access database The EMR Organization Lookup table contains the crosswalk between organization number, name, and higher-level organization known as 'EMROrg' and 'VPOrg.
Requires regular updates as dept numbers/names change. Numbers and names are defined/governed by the Finance team.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.