Tables and Views for PAYROLL as of 21-JUN-2004 08:15am
Date: 21-JUN-2004 Page: 1
TABLE: EXCEPTIONS
CREATOR: PAYROLL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ROW_ID ROWID 10 YES
OWNER VARCHAR2 30 YES
TABLE_NAME VARCHAR2 30 YES
CONSTRAINT VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 2
TABLE: GJBJOBS_INSTALL
CREATOR: PAYROLL
payroll GJBJOBS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBJOBS_NAME VARCHAR2 30 NO
GJBJOBS_TITLE VARCHAR2 30 NO
GJBJOBS_ACTIVITY_DATE DATE 7 NO
GJBJOBS_SYSI_CODE VARCHAR2 2 YES
GJBJOBS_JOB_TYPE_IND VARCHAR2 1 YES
GJBJOBS_DESC VARCHAR2 240 YES
GJBJOBS_COMMAND_NAME VARCHAR2 30 YES
GJBJOBS_PRNT_FORM VARCHAR2 30 YES
GJBJOBS_PRNT_CODE VARCHAR2 30 YES
GJBJOBS_LINE_COUNT NUMBER 3 YES
GJBJOBS_VALIDATION VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 3
TABLE: GJBPDEF_INSTALL
CREATOR: PAYROLL
payroll GJBPDEF rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDEF_JOB VARCHAR2 30 NO
GJBPDEF_NUMBER VARCHAR2 2 NO
GJBPDEF_DESC VARCHAR2 30 NO
GJBPDEF_LENGTH NUMBER 2 NO
GJBPDEF_TYPE_IND VARCHAR2 1 NO
GJBPDEF_OPTIONAL_IND VARCHAR2 1 NO
GJBPDEF_SINGLE_IND VARCHAR2 1 NO
GJBPDEF_ACTIVITY_DATE DATE 7 NO
GJBPDEF_LOW_RANGE VARCHAR2 30 YES
GJBPDEF_HIGH_RANGE VARCHAR2 30 YES
GJBPDEF_HELP_TEXT VARCHAR2 78 YES
GJBPDEF_VALIDATION VARCHAR2 30 YES
GJBPDEF_LIST_VALUES VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 4
TABLE: GJBPDFT_INSTALL
CREATOR: PAYROLL
payroll GJBPDFT rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDFT_JOB VARCHAR2 30 NO
GJBPDFT_NUMBER VARCHAR2 2 NO
GJBPDFT_ACTIVITY_DATE DATE 7 NO
GJBPDFT_USER_ID VARCHAR2 30 YES
GJBPDFT_VALUE VARCHAR2 30 YES
GJBPDFT_JPRM_CODE VARCHAR2 15 YES
Date: 21-JUN-2004 Page: 5
TABLE: GJBPVAL_INSTALL
CREATOR: PAYROLL
payroll GJBPVAL rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPVAL_JOB VARCHAR2 30 NO
GJBPVAL_NUMBER VARCHAR2 2 NO
GJBPVAL_VALUE VARCHAR2 30 NO
GJBPVAL_DESC VARCHAR2 30 NO
GJBPVAL_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 6
TABLE: GUBBHLP_INSTALL
CREATOR: PAYROLL
payroll GUBBHLP rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBBHLP_FORM_NAME VARCHAR2 30 NO
GUBBHLP_BLOCK_NAME VARCHAR2 30 YES
GUBBHLP_FIELD_NAME VARCHAR2 30 YES
GUBBHLP_TEXT LONG NO
GUBBHLP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 7
TABLE: GUBOBJS_INSTALL
CREATOR: PAYROLL
payroll GUBOBJS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOBJS_NAME VARCHAR2 30 NO
GUBOBJS_DESC VARCHAR2 80 NO
GUBOBJS_OBJT_CODE VARCHAR2 10 NO
GUBOBJS_SYSI_CODE VARCHAR2 2 NO
GUBOBJS_USER_ID VARCHAR2 30 NO
GUBOBJS_ACTIVITY_DATE DATE 7 NO
GUBOBJS_HELP_IND VARCHAR2 1 NO
GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 8
TABLE: GURAOBJ_INSTALL
CREATOR: PAYROLL
payroll GURAOBJ rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURAOBJ_OBJECT VARCHAR2 30 NO
GURAOBJ_DEFAULT_ROLE VARCHAR2 30 NO
GURAOBJ_CURRENT_VERSION VARCHAR2 10 NO
GURAOBJ_SYSI_CODE VARCHAR2 2 NO
GURAOBJ_ACTIVITY_DATE DATE 7 NO
GURAOBJ_CHECKSUM VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 9
TABLE: GURDMOD_INSTALL
CREATOR: PAYROLL
payroll GURDMOD rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURDMOD_CODE VARCHAR2 30 YES
GURDMOD_DATE DATE 7 YES
GURDMOD_APPLIED_BY_USER VARCHAR2 30 YES
GURDMOD_OBJECT VARCHAR2 30 YES
GURDMOD_DESC VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 10
TABLE: GURMENU_INSTALL
CREATOR: PAYROLL
payroll GURMENU rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURMENU_NAME VARCHAR2 30 NO
GURMENU_OBJ_NAME VARCHAR2 30 NO
GURMENU_SORT_SEQ NUMBER NO
GURMENU_USER_ID VARCHAR2 30 NO
GURMENU_ACTIVITY_DATE DATE 7 NO
GURMENU_DESC VARCHAR2 80 YES
Date: 21-JUN-2004 Page: 11
TABLE: GUROPTM_INSTALL
CREATOR: PAYROLL
payroll GUROPTM rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUROPTM_SORT_SEQ NUMBER 5 2 YES
GUROPTM_TYPE_IND VARCHAR2 1 NO
GUROPTM_FORM_NAME VARCHAR2 30 NO
GUROPTM_NAME1 VARCHAR2 30 NO
GUROPTM_NAME1_DESC VARCHAR2 60 YES
GUROPTM_NAME2 VARCHAR2 61 YES
GUROPTM_CAPACITY VARCHAR2 1 YES
GUROPTM_TRG_NAME VARCHAR2 30 YES
GUROPTM_TRG_TYPE VARCHAR2 1 YES
GUROPTM_BLOCK_VALID VARCHAR2 30 YES
GUROPTM_ACTIVITY_DATE DATE 7 YES
GUROPTM_USER_ID VARCHAR2 30 NO
GUROPTM_FORM_TO_BE_CALLED VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 12
TABLE: PABAPPL
CREATOR: PAYROLL
Applicant Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PABAPPL_PIDM NUMBER 8 NO PIDM: Internal person identification number.
PABAPPL_DATE DATE 7 NO DATE: Date of application.
PABAPPL_FULL_PART_IND VARCHAR2 1 YES FULLTIME PARTTIME INDICATOR: Indicates whether the
applicant wishes to work parttime of fulltime.
PABAPPL_ESKL_CODE VARCHAR2 2 YES EEO SKILL CODE: EEO skill code associated with this
applicant.
PABAPPL_ASRC_CODE VARCHAR2 2 NO APPLICANT SOURCE CODE: Source where applicant found
out about job opening.
PABAPPL_DESIRED_SALARY NUMBER 11 2 YES DESIRED SALARY: Annual salary applicant desires.
PABAPPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
updated.
PABAPPL_REQ_NO VARCHAR2 10 YES REQUISITION NUMBER: Requisition number of the Position
Class and Position Number.
PABAPPL_POSN VARCHAR2 6 YES POSITION NUMBER: The position associated with this
applicant entry.
PABAPPL_PCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: Position Class associated with
this applicant entry.
PABAPPL_DESIRED_HOURLY NUMBER 11 2 YES DESIRED HOURLY RATE: Hourly rate applicant desires.
Date: 21-JUN-2004 Page: 13
TABLE: PABPFAC
CREATOR: PAYROLL
Position Requirements Factor of Importance Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PABPFAC_POSN VARCHAR2 6 NO POSITION NUBER.
PABPFAC_SKILL_FACTOR NUMBER 4 2 YES DEGREE FACTOR : 0 - 10 Rating of the factor of
importance of degrees in the requirements for the
position.
PABPFAC_DEGREE_FACTOR NUMBER 4 2 YES DEGREE FACTOR : 0 - 10 Rating of the factor of
importance of degrees in the requirements for the
position.
PABPFAC_EXAM_FACTOR NUMBER 4 2 YES EXAM FACTOR : 0 - 10 Rating of the factor of
importance of exams in the requirements for the
position.
PABPFAC_CERT_FACTOR NUMBER 4 2 YES CERTIFICATE FACTOR : 0 - 10 Rating of the factor of
importance of certificates in the requirements for the
position.
PABPFAC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 14
TABLE: PABREQU
CREATOR: PAYROLL
Position Requisition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PABREQU_REQ_NO VARCHAR2 10 NO REQUISITION NUMBER: Requisition Number of the
position.
PABREQU_REQS_CODE VARCHAR2 2 NO REQUISITION STATUS: Status of the requisition.
PABREQU_APPL_DATE DATE 7 NO APPLICANT DATE: Date the application was submitted.
PABREQU_POSN VARCHAR2 6 NO POSITION NUMBER: The position associated with this
requisition.
PABREQU_VACY_DATE DATE 7 YES VACANCY DATE: Date the position will be vacant.
PABREQU_POST_DATE DATE 7 YES POSTING DATE: Date the position is posted.
PABREQU_OPEN_DATE DATE 7 YES APPLICATION OPEN DATE: Date the application for the
position will be open.
PABREQU_CLOSE_DATE DATE 7 YES APPLICATION CLOSE DATE: Date the application for the
position will be closed.
PABREQU_HIRE_DATE DATE 7 YES HIRE DATE: Projected date of hire for this position.
PABREQU_APPR_DATE DATE 7 YES APPROVAL DATE: Date the position requisition was
approved.
PABREQU_APPR_PIDM NUMBER 8 YES APPROVERS PIDM: Internal identification number of the
person approving the position requisition.
PABREQU_RECR_PIDM NUMBER 8 YES RECRUITERS PIDM: Internal identification number of the
person recuriting for the position requisition.
PABREQU_RELOC_IND VARCHAR2 1 NO RELOCATION INDICATOR: Indicates if relocation
assistance is available or not.
PABREQU_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
PABREQU_COAS_CODE VARCHAR2 1 YES
PABREQU_ORGN_CODE VARCHAR2 6 YES
Date: 21-JUN-2004 Page: 15
TABLE: PARAPIN
CREATOR: PAYROLL
Applicant Interviewer Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARAPIN_PIDM NUMBER 8 NO Internal System ID number.
PARAPIN_REQ_NO VARCHAR2 10 YES REQUISITION NUMBER: Requisition Number of the position
associated with this applicant entry.
PARAPIN_POSN VARCHAR2 6 YES POSITION NUMBER: The position associated with this
applicant entry.
PARAPIN_PCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: Position Class associated with
this applicant entry.
PARAPIN_APPL_DATE DATE 7 NO APPLICANT DATE: Date the application was submitted.
PARAPIN_INTERVIEW_PIDM NUMBER 8 NO INTERVIEWER ID: Employee ID if the individual who
conducted the interview.
PARAPIN_INTERVIEW_DATE DATE 7 NO INTERVIEW DATE: Date of interview.
PARAPIN_INTERVIEW_TIME VARCHAR2 8 NO INTERVIEW TIME: Time of interview.
PARAPIN_COMMENT LONG YES COMMENT: A free form comment regarding this applicant.
PARAPIN_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 16
TABLE: PARAPST
CREATOR: PAYROLL
Applicant Status Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARAPST_PIDM NUMBER 8 NO Internal System ID number.
PARAPST_PCLS_CODE VARCHAR2 5 YES POSITION CLASS CODE: Position Class associated with
this Applicant entry.
PARAPST_POSN VARCHAR2 6 YES POSITION NUMBER: The position associated with this
applicant entry.
PARAPST_APPS_CODE VARCHAR2 2 NO APPLICANT STATUS CODE: Indicates Status of Applicant.
The code must be previously defined on the Applicant
Status Validation Form (PTVAPPS).
PARAPST_APPS_DATE DATE 7 NO APPLICANT STATUS DATE: The date the applicant status
was entered.
PARAPST_COMMENT LONG YES COMMENT: A free form comment regarding this Applicant
Status entry.
PARAPST_ACTIVITY_DATE DATE 7 NO Date of the last activity (insert or update) on this
record.
PARAPST_REQ_NO VARCHAR2 10 YES REQUISITION NUMBER: Requisition number of the Position
Class and Position Number.
PARAPST_APPL_DATE DATE 7 NO APPLICANT DATE: Date applicant submitted application.
PARAPST_SEQ_NO VARCHAR2 3 NO
Date: 21-JUN-2004 Page: 17
TABLE: PARCDES
CREATOR: PAYROLL
Position Classification Description Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARCDES_PCLS_CODE VARCHAR2 5 NO POSITION CLASS CODE: The position class associated
with this description.
PARCDES_CDES_CODE VARCHAR2 5 NO POSITION CLASS DESCRIPTION CODE: Position
Classification description code associated with this
position class.
PARCDES_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 18
TABLE: PARPCER
CREATOR: PAYROLL
Position Certifications Required Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPCER_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
certification.
PARPCER_CERT_CODE VARCHAR2 4 NO CERTIFICATION CODE: Certification code required for
this position.
PARPCER_CERT_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the Certification
is required or optional.
PARPCER_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 19
TABLE: PARPCMT
CREATOR: PAYROLL
Position Comments Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPCMT_POSN VARCHAR2 6 NO POSITION CODE: Position code.
PARPCMT_COMMENT LONG YES POSITION COMMENT: Detailed comment about the position.
PARPCMT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
Date: 21-JUN-2004 Page: 20
TABLE: PARPCON
CREATOR: PAYROLL
Position Area of Concentration Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPCON_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
degree/area of concentration combination.
PARPCON_DEGC_CODE VARCHAR2 6 NO DEGREE CODE: Degree code required for this position.
PARPCON_CONC_CODE VARCHAR2 4 NO AREAR OF CONCENTRATION CODE: Area of Concentration
code required for this position and degree.
PARPCON_CONC_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the Area of
Concentration is required or optional.
PARPCON_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 21
TABLE: PARPDEG
CREATOR: PAYROLL
Position Degree Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPDEG_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
degree.
PARPDEG_DEGC_CODE VARCHAR2 6 NO DEGREE CODE: Degree code required for this position.
PARPDEG_DEGC_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the degree is
required or optional.
PARPDEG_DLEV_REQR_IND VARCHAR2 1 YES REQUIRED/OPTIONAL IND: Indicates if the degree level
is required or optional.
PARPDEG_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 22
TABLE: PARPDES
CREATOR: PAYROLL
Position/Position Classification Description Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPDES_POSN VARCHAR2 6 NO POSITION NUMBER: The position associated with this
description.
PARPDES_CDES_CODE VARCHAR2 5 NO POSITION CLASS DESCRIPTION CODE: Position
Classification description code associated with this
position.
PARPDES_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 23
TABLE: PARPEND
CREATOR: PAYROLL
Position Endorsements Required Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPEND_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
endorsement.
PARPEND_CERT_CODE VARCHAR2 4 NO CERTIFICATION CODE: Certification code required for
this position.
PARPEND_ENDS_CODE VARCHAR2 2 NO ENDORSEMENT CODE: Endorsement code required for this
position.
PARPEND_ENDS_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the endorsement is
required or optional.
PARPEND_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 24
TABLE: PARPEXM
CREATOR: PAYROLL
Position Exams Required Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPEXM_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
exam.
PARPEXM_EXAM_CODE VARCHAR2 2 NO EXAM CODE: Exam code required for this position.
PARPEXM_EXAM_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the Exam is
required or optional.
PARPEXM_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 25
TABLE: PARPMAJ
CREATOR: PAYROLL
Position Major Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPMAJ_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
degree/major combination.
PARPMAJ_DEGC_CODE VARCHAR2 6 NO DEGREE CODE: Degree code required for this position.
PARPMAJ_MAJR_CODE VARCHAR2 4 NO MAJOR CODE: Major code required for this position and
degree.
PARPMAJ_MAJR_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the Major is
required or optional.
PARPMAJ_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 26
TABLE: PARPMIN
CREATOR: PAYROLL
Position Minor Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPMIN_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
degree/minor combination.
PARPMIN_DEGC_CODE VARCHAR2 6 NO DEGREE CODE: Degree code associated with this minor.
PARPMIN_MINR_CODE VARCHAR2 4 NO MINOR CODE: Minor code required for this position and
degree.
PARPMIN_MINR_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the minor is
required or optional.
PARPMIN_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 27
TABLE: PARPSKL
CREATOR: PAYROLL
Position Skills Required Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PARPSKL_POSN VARCHAR2 6 NO POSITION NUMBER: Position number associated with this
skill.
PARPSKL_SKIL_CODE VARCHAR2 6 NO SKILL CODE: Skill code required for this position.
PARPSKL_SKIL_REQR_IND VARCHAR2 1 NO REQUIRED/OPTIONAL IND: Indicates if the skill is
required or optional.
PARPSKL_SKLV_CODE VARCHAR2 3 YES SKILL LEVEL CODE: Skill Level code required for this
position.
PARPSKL_SKLV_REQR_IND VARCHAR2 1 YES REQUIRED/OPTIONAL IND: Indicates if the skill level is
required or optional.
PARPSKL_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 28
TABLE: PATRECR
CREATOR: PAYROLL
Temp table for Web for Executive Requisition/Application profile extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PATRECR_SOURCE CHAR 1 YES Identifies the original source of the data.
PATRECR_REQ_NUMBER VARCHAR2 10 NO Requisition number.
PATRECR_PIDM NUMBER 8 YES Internal Identification Number of the person.
PATRECR_CALENDAR_MONTH VARCHAR2 2 YES Calendar month of the select (MM).
PATRECR_CALENDAR_YEAR VARCHAR2 4 YES Calendar year of the select (YYYY).
PATRECR_SALARY_MIDPOINT NUMBER YES Salary midpoint amount for the position.
PATRECR_TIME_OPEN NUMBER YES Length of time in days that the position has been
open.
PATRECR_DESIRED_SALARY NUMBER 11 2 YES The desired salary amount of the applicant.
PATRECR_DESIRED_HOURLY NUMBER 11 2 YES The desired hourly amount of the applicant.
PATRECR_RECENT_LENGTH_SVC NUMBER YES The length of service for the applicants most recent
job.
PATRECR_RECENT_JOB_SALARY NUMBER YES The annual salary for the applicants most recent job.
PATRECR_REQ_STATUS VARCHAR2 2 NO The status of the requisition.
PATRECR_EMPLOYEE_CLASS VARCHAR2 2 NO The employee class of the available position.
PATRECR_POSITION_CLASS VARCHAR2 5 NO The position class of the available position.
PATRECR_FT_PT_STATUS VARCHAR2 1 NO The full time/part time indicator for the available
position.
PATRECR_SKILL_CODE VARCHAR2 2 YES The employee skill code of the available position.
PATRECR_FAC_STAFF_IND VARCHAR2 1 YES Faculty/staff indicator of the available position,
based on employee skill code.
PATRECR_MIN_DEGREE_LEVEL VARCHAR2 2 YES The minimum degree level required for the available
position.
PATRECR_EMPLOYER VARCHAR2 4 NO The employer code for the available position.
PATRECR_CHART_CODE VARCHAR2 1 YES The chart of accounts code for the available position.
PATRECR_DEPARTMENT VARCHAR2 6 YES The department code for the available position.
PATRECR_CURRENT_EMPL_IND VARCHAR2 1 YES Indicates whether the applicant is a current employee
of the institution (Y or N.)
PATRECR_ALUMNUS_IND VARCHAR2 1 YES Indicates whether the applicant is an alumnus of the
institution (Y or N.)
PATRECR_AGE NUMBER YES Age of the applicant.
PATRECR_ETHNIC_CODE VARCHAR2 2 YES Institutional ethnic code of the applicant.
PATRECR_GOVT_ETHNIC_CODE VARCHAR2 1 YES Governmental ethnic code of the applicant.
PATRECR_GENDER_CODE VARCHAR2 1 YES Gender code of the applicant.
PATRECR_TERMINAL_DEGREE VARCHAR2 6 YES Terminal degree code of the applicant.
PATRECR_TERMINAL_COLLEGE VARCHAR2 6 YES Terminal degree college code of the applicant.
PATRECR_VETERAN_IND VARCHAR2 1 YES Indicates if the applicant is a veteran (Y or N.)
PATRECR_CITY VARCHAR2 20 YES City of the applicant.
PATRECR_STATE_PROVINCE_CODE VARCHAR2 3 YES State or province code of the applicant.
PATRECR_NATION_CODE VARCHAR2 5 YES Nation code of the applicant.
PATRECR_DISABLED_IND VARCHAR2 1 YES Indicates if the applicant is disabled (Y or N.)
PATRECR_RECENT_EMPLOYER VARCHAR2 30 YES The employer for the applicants most recent job.
PATRECR_EXPERIENCE_TYPE VARCHAR2 2 YES The experience type code for the applicants most
recent job.
PATRECR_RECR_SOURCE VARCHAR2 2 YES Recruitment source of the applicant.
Date: 21-JUN-2004 Page: 29
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PATRECR_APPLICANT_IND VARCHAR2 1 YES Indicates whether any applicants have applied for the
job (Y or N.)
PATRECR_INT_OFFERED_IND VARCHAR2 1 YES Indicates whether any interviews have been offered for
the job (Y or N.)
PATRECR_INT_COMPLETED_IND VARCHAR2 1 YES Indicates whether any interviews have been completed
for the job (Y or N.)
PATRECR_EMPL_OFFERED_IND VARCHAR2 1 YES Indicates whether any employment offers have been made
for the job (Y or N.)
PATRECR_EMPL_ACCEPTED_IND VARCHAR2 1 YES Indicates whether any employment offers have been
accepted for the job (Y or N.)
PATRECR_EMPL_BEGUN_IND VARCHAR2 1 YES Indicates whether anyone has begun working in this job
(Y or N.)
PATRECR_USER VARCHAR2 30 NO ID of the user who inserted or
updated the record most
recently.
PATRECR_ACTIVITY_DATE DATE 7 NO Date the record was
inserted or updated.
Date: 21-JUN-2004 Page: 30
TABLE: PCBPERS
CREATOR: PAYROLL
Cobra Person Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PCBPERS_PIDM NUMBER 8 NO PIDM: The internal ID number of the COBRA Person.
PCBPERS_ORIG_BFCTR_PIDM NUMBER 8 YES ORIGINAL BENEFACTOR PIDM: The internal ID number of
the original employee who caused this person to become
eligible for COBRA Benefits.
PCBPERS_COBRA_BFCTR_PIDM NUMBER 8 NO COBRA BENEFACTOR PIDM: The internal ID number of the
employee or COBRA person who caused this person to
become eligible for COBRA.
PCBPERS_BREL_CODE VARCHAR2 1 NO RELATIONSHIP CODE: Specifies the relationship of the
COBRA Benefactor to the COBRA Person.
PCBPERS_OTHER_COV_IND VARCHAR2 1 NO OTHER COVERAGE INDICATOR: Specifies if the COBRA
person has other medical coverage.
PCBPERS_COBR_CODE VARCHAR2 2 NO COBRA REASON CODE: The reason the person is eligible
for COBRA. Must exist on the COBRA Rule Form
(PTRCOBR).
PCBPERS_ACCEPTED_IND VARCHAR2 1 NO COVERAGE ACCEPTED INDICATOR: Specifies if the COBRA
person has accepted coverage or not.
PCBPERS_QUALIFYING_DATE DATE 7 NO QUALIFYING DATE: Date the person qualifies for COBRA.
PCBPERS_COV_BEGIN_DATE DATE 7 NO COVERAGE BEGIN DATE: Date the COBRA Coverage Begins.
PCBPERS_COV_END_DATE DATE 7 NO COVERAGE END DATE: Date the COBRA Coverage ends.
PCBPERS_NOTIFIED_DATE DATE 7 YES NOTIFIED DATE: Date the Notification Letter was sent
to the COBRA Person.
PCBPERS_ELECTN_END_DATE DATE 7 YES ELECTION END DATE: The last date the person can elect
coverage.
PCBPERS_ENROLLMENT_DATE DATE 7 YES ENROLLMENT DATE: Date the person enrolls for COBRA
Coverage.
PCBPERS_NOTF_ENRL_END_DATE DATE 7 YES NOTIFICATION ENROLLMENT END DATE: Date the Post
Notification Letter was sent to the COBRA Person.
PCBPERS_NOTF_LATE_NOTC_DATE DATE 7 YES NOTIFICATION LATE NOTICE DATE: Date the Last Late
Notice Letter was sent to the COBRA Person.
PCBPERS_NOTF_TERMINATE_DATE DATE 7 YES NOTIFICATION TERMINATION DATE: Date the Termination
Letter was sent to the COBRA Person.
PCBPERS_NOTF_EXPIRE_DATE DATE 7 YES NOTIFICATION EXPIRATION DATE: Date the Pre-Expiration
Letter was sent to the COBRA Person
PCBPERS_ACTIVE_IND VARCHAR2 1 NO COVERAGE ACTIVE INDICATOR: Specifies if the Coverage
is active or not.
PCBPERS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date this record was last inserted
or changed.
Date: 21-JUN-2004 Page: 31
TABLE: PCRBCOV
CREATOR: PAYROLL
Cobra Beneficiary Coverage Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PCRBCOV_PIDM NUMBER 8 NO PIDM: The COBRA persons internal ID number.
PCRBCOV_CBEN_CODE VARCHAR2 3 NO COBRA BENEFIT CODE: The benefit/deduction code
associated with this record.
PCRBCOV_PLAN VARCHAR2 2 YES PLAN: Plan code.
PCRBCOV_SEQ_NO NUMBER 2 NO COBRA BENEFICIARY SEQUENCE NUMBER: Unique sequence
number identifing this beneficiary.
PCRBCOV_BEGIN_DATE DATE 7 NO BEGIN DATE: COBRA Beneficiary Coverage Begin Date.
PCRBCOV_END_DATE DATE 7 NO END DATE: COBRA Beneficiary Coverage End Date.
PCRBCOV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that this record was last
changed or inserted.
Date: 21-JUN-2004 Page: 32
TABLE: PCRBENE
CREATOR: PAYROLL
COBRA Dependent and Beneficiary Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PCRBENE_PIDM NUMBER 8 NO PIDM: The internal ID of the COBRA person.
PCRBENE_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: A number associated with each
Depentent/Beneficiary of the COBRA person.
PCRBENE_BENE_PIDM NUMBER 8 YES BENEFICIARY PIDM: The internal ID of the
Dependent/Beneficiary.
PCRBENE_BENE_LAST_NAME VARCHAR2 30 YES BENEFICIARY LAST NAME: The last name of the
Dependent/Beneficiary.
PCRBENE_BENE_FIRST_NAME VARCHAR2 15 YES BENEFICIARY FIRST NAME: The first name of the
Dependent/Beneficiary.
PCRBENE_BENE_MI VARCHAR2 15 YES BENEFICIARY MIDDLE INITIAL: The middle initial of the
Dependent/Beneficiary.
PCRBENE_BREL_CODE VARCHAR2 1 NO BENEFICIARY RELATIONSHIP CODE: The code describint the
relationship of the beneficiary to the COBRA person.
Must exist on the PTRBREL table.
PCRBENE_SEX_IND VARCHAR2 1 YES SEX INDICATOR: The sex of the Beneficiary/Dependent
PCRBENE_BIRTH_DATE DATE 7 YES BIRTH DATE: The birth date of the
Dependent/Beneficiary.
PCRBENE_COLLEGE_IND VARCHAR2 1 NO COLLEGE INDICATOR: An indicator used to determine
whether or not the Dependent/Beneficiary is currently
attending college.
PCRBENE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date this record was last changed
or inserted.
Date: 21-JUN-2004 Page: 33
TABLE: PCRCPAY
CREATOR: PAYROLL
Cobra Payment Administration Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PCRCPAY_PIDM NUMBER 8 NO PIDM: Internal ID number.
PCRCPAY_TRANS_IND VARCHAR2 1 NO TRANSACTION INDICATOR: Specifies if the Transaction is
a bill or payment.
PCRCPAY_TRANS_DATE DATE 7 NO TRANSACTION DATE: Date the Payment Record was
inserted. On a Bill, the transaction date indicates
the date the Bill is due without including the grace
period.
PCRCPAY_CBEN_CODE VARCHAR2 3 YES COBRA Benefit Code: System defined code for the COBRA
Benefit/Deduction.
PCRCPAY_PLAN VARCHAR2 2 YES PLAN: COBRA Benefit Plan.
PCRCPAY_AMOUNT NUMBER 11 2 NO AMOUNT: Amount on the Bill/Payment.
PCRCPAY_COMMENTS VARCHAR2 60 YES COMMENTS: Comments associated with the bill/payment.
PCRCPAY_DUE_DATE DATE 7 YES DUE DATE: Due Date of the Bill Including the Grace
Period.
PCRCPAY_HIST_IND VARCHAR2 1 NO HISTORY INDICATOR: Indicates if the record has been
interfaced to Finance or not.
PCRCPAY_CLOSE_IND VARCHAR2 1 NO CLOSE INDICATOR: Specifies if the Transaction has been
closed or not.
PCRCPAY_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date this record was last changed
or inserted.
Date: 21-JUN-2004 Page: 34
TABLE: PCRDEDN
CREATOR: PAYROLL
Cobra Person Benefit Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PCRDEDN_PIDM NUMBER 8 NO PIDM: Internal ID number.
PCRDEDN_SEQ_NO NUMBER 2 YES COBRA BENEFIT PRIORITY.
PCRDEDN_CBEN_CODE VARCHAR2 3 NO COBRA BENEFIT CODE.
PCRDEDN_PLAN VARCHAR2 2 YES COBRA BENEFIT PLAN.
PCRDEDN_BEGIN_DATE DATE 7 NO COBRA BENEFIT BEGIN DATE:
PCRDEDN_END_DATE DATE 7 NO COBRA BENEFIT END DATE.
PCRDEDN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification of the
record.
Date: 21-JUN-2004 Page: 35
TABLE: PDR1042
CREATOR: PAYROLL
Windstar Payment Information Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDR1042_LAST_NAME VARCHAR2 40 YES LAST NAME: This field defines the last name of person.
PDR1042_FIRST_NAME VARCHAR2 40 YES FIRST NAME: This field identifies the first name of
person.
PDR1042_MI VARCHAR2 40 YES MIDDLE NAME: This field identifies the middle name of
person.
PDR1042_SSN VARCHAR2 11 YES SSN: Social Security Number.
PDR1042_ID VARCHAR2 9 YES ID: This field defines the identification number used
to access person on-line.
PDR1042_BIRTH_DATE DATE 7 YES BIRTH DATE: Date of Birth.
PDR1042_TAX_YEAR NUMBER 4 YES TAX YEAR: Tax Year.
PDR1042_INCOME_CODE NUMBER 2 YES INCOME CODE: Income Code.
PDR1042_WITHHOLDING_RATE NUMBER 4 2 YES WITHHOLDING RATE: Withholding Rate.
PDR1042_INCOME_CODE_SUBTYPE VARCHAR2 1 YES INCOME CODE SUBTYPE: Income code subtype.
PDR1042_EXEMPTION_CODE NUMBER 1 YES EXEMPTION CODE: Exemption Code.
PDR1042_MAX_BENEFIT_AMOUNT NUMBER 9 2 YES MAX BENEFIT AMOUNT: Amount supplied only for treaty
benefits with a maximum.
PDR1042_RL_BEN_AMT_EXCEED_SW VARCHAR2 1 YES RL BEN AMT EXCEED IND: Retro Lose Benefit if Amount
Exceeded.
PDR1042_BEN_END_DATE DATE 7 YES BENEFIT END DATE: Date Benefit Ends.
PDR1042_RL_BEN_DATE_EXCEED_SW VARCHAR2 1 YES RETRO LOSE BENEFIT DATE EXCEEDED: Retro Lose Benefit
if Date Exceeded.
PDR1042_CURR_RESIDENCY_STATUS VARCHAR2 1 YES CURRENT RESIDENCY STATUS: Current Residency Status.
PDR1042_BECOME_RA_DATE DATE 7 YES BECOME RA DATE: Date Individual becomes RA.
PDR1042_TARGET_DEPARTURE_DATE DATE 7 YES TARGET DEPARTURE DATE: Ending Date on latest
Visa/Primary Activity.
PDR1042_TAX_RES_COUNTRY_CODE VARCHAR2 2 YES TAX RES COUNTRY CODE: IRS Codes.
PDR1042_TREATY_CHANGED_DATE DATE 7 YES TREATY CHANGED DATE: Date this Treaty Info updated.
PDR1042_EXEMPT_NRA_FICA_SW VARCHAR2 1 YES EXEMPT NRA FICA IND: Exempt (NRA) from FICA.
PDR1042_EXEMPT_STUDNT_FICA_SW VARCHAR2 1 YES EXEMPT STUDENT FICA INDICATOR: Exempt Student from
FICA.
PDR1042_ADD_WITHHOLDING_SW VARCHAR2 1 YES ADDITIONAL WITHHOLDING INDICATOR: Add Withholding for
NRA when no treaty.
PDR1042_ADD_WITHHOLDING_AMT NUMBER 4 YES ADDITIONAL WITHHOLDING AMOUNT: Amount of Additional
Withholding.
PDR1042_PERSONAL_EXEMPTION NUMBER 1 YES PERSONAL EXEMPTION: Personal Exemption.
PDR1042_ADD_EXEMPTION_ALLOWED NUMBER 2 YES ADDITIONAL EXEMPTION ALLOWED: Additional exemptions
allowed.
PDR1042_DAYS_IN_USA NUMBER 3 YES DAYS IN USA: Days in USA this Tax Year.
PDR1042_WITHHOLD_ALLOWANCE_SW VARCHAR2 1 YES WITHHOLD ALLOWANCE INDICATOR: Eligible for Withholding
Allowance.
PDR1042_TREATY_BEN_ALLOWED_SW VARCHAR2 1 YES TREATY BENEFIT ALLOWED INDICATOR: Treaty Benefits
Allowed.
PDR1042_TREATY_BEN_START_DATE DATE 7 YES TREATY BENEFIT START DATE: Treaty Benefit Start Date.
PDR1042_RA_EFFECTIVE_DATE DATE 7 YES RA EFFECTIVE DATE: RA Effective Date.
Date: 21-JUN-2004 Page: 36
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDR1042_STATE_CODE VARCHAR2 2 YES STATE CODE: State Code.
PDR1042_STATE_HONOR_TREATY_SW VARCHAR2 1 YES STATE HONOR TREATY INDICATOR: State Honors Treaty.
PDR1042_YTD_PAYMENTS NUMBER 9 2 YES YTD PAYMENTS: YTD Payments.
PDR1042_YTD_W2_PAYMENTS NUMBER 9 2 YES YTD W2 PAYMENTS: YTD W2 Payments.
PDR1042_YTD_FED_WH_W2 NUMBER 9 2 YES YTD FED WITHHOLDING W2: YTD Withholding (Federal) W2.
PDR1042_YTD_TREATY_WH_ALLWNCE NUMBER 9 2 YES YTD TREATY WITHHOLDING ALLOWANCE: YTD Withholding
Allowance (1042S).
PDR1042_YTD_TREATY_PMT NUMBER 9 2 YES YTD TREATY PAYMENT: YTD Treaty Payments (1042S).
PDR1042_YTD_TREATY_WH_AMT NUMBER 9 2 YES YTD TREATY WITHHELD AMOUNT: YTD Treaty Withheld Amts
(1042S).
PDR1042_RECORD_SOURCE VARCHAR2 3 YES RECORD SOURCE: Record Source (STU, SPT, CIT etc).
PDR1042_VISA_TYPE VARCHAR2 4 YES VISA TYPE: Visa Type.
PDR1042_J_SUB_TYPE VARCHAR2 2 YES J SUB TYPE: J Sub Type.
PDR1042_PRIMARY_ACTIVITY VARCHAR2 2 YES PRIMARY ACTIVITY: Primary Activity.
PDR1042_NON_US_COUNTRY_CODE VARCHAR2 2 YES NON US COUNTRY CODE: Non US Country Code.
PDR1042_CITIZEN_COUNTRY_CODE VARCHAR2 2 YES CITIZEN COUNTRY CODE: Citizenship Country Code.
PDR1042_CONST_ADDITIONAL_TAX NUMBER 7 2 YES CONSTANT ADDITIONAL TAX: Constant additional Tax.
PDR1042_ADD_WITHHOLDING_TYPE VARCHAR2 1 YES ADDITIONAL WITHHOLDING TYPE: Amount of additional
withholding type.
PDR1042_OTHER_TREATY_BEN NUMBER 9 2 YES OTHER TREATY BENEFIT: Treaty benefit enjoyed at
different institution in current tax year.
PDR1042_W4_SIGNED DATE 7 YES W4 SIGNED: W4 signed.
PDR1042_TREATY_FORM_SIGNED DATE 7 YES TREATY FORM SIGNED: Treaty form signed.
PDR1042_BEN_ESTIMATED_SW VARCHAR2 1 YES BENEFIT ESTIMATED INDICATOR: Treaty benefits
estimated.
PDR1042_EXEMPTION_CODE_2 VARCHAR2 2 YES EXEMPTION CODE 2: Exemption Code 2.
PDR1042_RECIPIENT_CODE NUMBER 2 YES RECIPIENT CODE: Recipient Code.
PDR1042_STATUS_TYPE VARCHAR2 1 YES STATUS TYPE: Record status; 0 = no errors, 1 = error.
PDR1042_STATUS_DESC VARCHAR2 50 YES STATUS DESC: Error messages.
Date: 21-JUN-2004 Page: 37
TABLE: PDRBCHS
CREATOR: PAYROLL
Beneficiary Coverage Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRBCHS_PIDM NUMBER 8 NO PIDM: Personal indentifcation code for an individual
tracked in the system.
PDRBCHS_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: The code assigned to the
benefit/deduction.
PDRBCHS_BENE_SEQ_NO NUMBER 2 NO Sequence number identifying the Dependent/Beneficiary.
PDRBCHS_BEGIN_DATE DATE 7 YES Benefit Coverage Begin Date.
PDRBCHS_END_DATE DATE 7 YES Benefit Coverage End Date.
PDRBCHS_OTHER_COV_IND VARCHAR2 1 YES Indicator which indicates whether Beneficiary is
otherwise covered.
PDRBCHS_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date of the budget transaction.
PDRBCHS_DELETED_IND VARCHAR2 1 NO DELETED INDICATOR: Indicates if the Benefits/Deduction
record has been deleted.
PDRBCHS_USER_ID VARCHAR2 30 NO USER ID: User or process
that updated record.
PDRBCHS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
Date: 21-JUN-2004 Page: 38
TABLE: PDRBCOV
CREATOR: PAYROLL
Beneficiary Coverage Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRBCOV_PIDM NUMBER 8 NO Internal ID number.
PDRBCOV_BDCA_CODE VARCHAR2 3 NO The Coverage Benefit/Deduction Code.
PDRBCOV_BENE_SEQ_NO NUMBER 2 NO The Sequence Number which ties in with the PDRBENE
Beneficiary Sequence number to identify the
Beneficiary.
PDRBCOV_BEGIN_DATE DATE 7 NO Benefit Coverage Begin Date.
PDRBCOV_END_DATE DATE 7 YES Benefit Coverage End Date.
PDRBCOV_OTHER_COV_IND VARCHAR2 1 YES Indicator which indicates whether Beneficiary is
otherwise covered.
PDRBCOV_ACTIVITY_DATE DATE 7 NO Date of the last activity (insert or update) on this
record.
Date: 21-JUN-2004 Page: 39
TABLE: PDRBDED
CREATOR: PAYROLL
Employee Deduction Repeating Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRBDED_PIDM NUMBER 8 NO PIDM: Internal System Indentification Number.
PDRBDED_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: The code which identifies the
benefit/deduction.
PDRBDED_ADD_REPL_IND VARCHAR2 1 YES ADD/REPLACE INDICATOR: Indicates whether the amount is
to be added to the employees normal deduction or
replaces the employees normal deduction.
PDRBDED_ADD_REPL_EMPL NUMBER 11 2 YES ADD/REPLACE EMPLOYEE: The employe amount to either add
to the normal deduction or replace the normal
deduction.
PDRBDED_ADD_REPL_EMPR NUMBER 11 2 YES ADD/REPLACE EMPLOYER: The employer amount to either
add to the normal employer deduction or replace the
employer deduction.
PDRBDED_ADD_REPL_TAX_BASE NUMBER 11 2 YES APPLICABLE GROSS: The applicable gross to be used with
the add/replace amount.
PDRBDED_ARR_STATUS VARCHAR2 1 YES ARREARS STATUS: The ststus of the arrears.
PDRBDED_ARR_BALANCE NUMBER 11 2 YES ARREARS BALANCE: The arrears balance due the employer.
PDRBDED_BOND_BALANCE NUMBER 11 2 YES BOND BALANCE: If the deduction is for savings bonds
this field contains the balance available toward the
purchase of a bond.
PDRBDED_BEGIN_DATE DATE 7 NO BENEFIT/DEDUCTION BEGIN DATE: The date the
benefit/deduction begins.
PDRBDED_END_DATE DATE 7 YES BENEFIT/DEDUCTION END DATE: The date the
benefit/deduction ends.
PDRBDED_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PDRBDED_ARR_RECOVER_MAX NUMBER 11 2 YES MAXIMUM ARREARS RECOVERY: The maximum amount of
arrears allowed to be recovered in a pay event.
PDRBDED_ADD_REPL_PICT_CODE VARCHAR2 2 YES The Payroll ID where this benefit/deduction override
should be applied.
Date: 21-JUN-2004 Page: 40
TABLE: PDRBDED_MBCVT_MPSERS2
CREATOR: PAYROLL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
B_RECTYPE VARCHAR2 1 YES
CDT_NEW_EMPLID VARCHAR2 9 YES
CDT_SSN VARCHAR2 9 YES
CDT_LASTNAME VARCHAR2 20 YES
CDT_FIRSTNAME VARCHAR2 15 YES
ADP_EMPLID VARCHAR2 11 YES
CVT_PDRBDED_PIDM NUMBER 8 YES
ADP_DEDCD VARCHAR2 3 YES
CVT_PDRBDED_BDCA_CODE VARCHAR2 3 YES
ADP_EFFDT DATE 7 YES
CVT_PDRBDED_BEGIN_DATE DATE 7 YES
ADP_DEDUCTION_END_DT DATE 7 YES
CVT_PDRBDED_END_DATE DATE 7 YES
CVT_PDRBDED_ACTIVITY_DATE DATE 7 YES
PEBEMPL_PIDM_EXISTS VARCHAR2 1 YES
ADP_EMPL_STATUS VARCHAR2 1 YES
ADP_PAYGROUP VARCHAR2 3 YES
ADP_EMPL_RCD_NBR VARCHAR2 4 YES
ADP_EFFSEQ VARCHAR2 4 YES
ADP_ACTION VARCHAR2 4 YES
ADP_ACTION_DT VARCHAR2 4 YES
ADP_ACTION_REASON VARCHAR2 4 YES
ADP_FULL_NAME VARCHAR2 40 YES
CVT_PERDTOT_APPL_GRS NUMBER 11 2 YES
CVT_PERDTOT_EMPL_AMT NUMBER 11 2 YES
CVT_PERDTOT_EMPR_AMT NUMBER 11 2 YES
CVT_PERDTOT_EMPR_CODE VARCHAR2 4 YES
CVT_PERDTOT_MONTH NUMBER 2 YES
CVT_PERDTOT_YEAR NUMBER 4 YES
ADP_QTRCD VARCHAR2 1 YES
ADP_DED_CLASS VARCHAR2 1 YES
ADP_BENEFIT_PLAN VARCHAR2 6 YES
GENL_GOAL_BAL NUMBER 10 2 YES
Date: 21-JUN-2004 Page: 41
TABLE: PDRBEHS
CREATOR: PAYROLL
Beneficiaries/Dependents Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRBEHS_PIDM NUMBER 8 NO PIDM: Personal indentifcation code for an individual
tracked in the system.
PDRBEHS_SEQ_NO NUMBER 2 NO Sequence number identifying the Dependent/Beneficiary.
PDRBEHS_BENE_PIDM NUMBER 8 YES Internal ID number of Dependent/Beneficiary. This may
be left NULL if the indi dual has not been established
on the system.
PDRBEHS_BENE_LAST_NAME VARCHAR2 30 YES Beneficiary Last Name. This will be NULL if the
Beneficiary PIDM column is filled.
PDRBEHS_BENE_FIRST_NAME VARCHAR2 15 YES Beneficiary First Name. This will be NULL if the
Beneficiary PIDM column is filled.
PDRBEHS_BENE_MI VARCHAR2 15 YES Beneficiary Middle Initial. This will be NULL if the
Beneficiary PIDM column is filled.
PDRBEHS_BREL_CODE VARCHAR2 1 NO RELATIONSHIP CODE: Code used to identify the
relationship of the beneficiary to the employee. The
relationship code must be previously defined on the
Beneficiary Relationship Rule Form (PTRBREL).
PDRBEHS_SEX_IND VARCHAR2 1 YES Indicates Gender of Beneficiary. This will be NULL if
the Beneficiary PIDM column is filled.
PDRBEHS_BIRTH_DATE DATE 7 YES Birth Date.
PDRBEHS_COLLEGE_IND VARCHAR2 1 NO COLLEGE INDICATOR; Indicates if the beneficiary is
presently attending college
PDRBEHS_SSN VARCHAR2 9 YES This field maintains person social security number.
PDRBEHS_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date of the budget transaction.
PDRBEHS_DELETED_IND VARCHAR2 1 NO DELETED INDICATOR: Indicates if the Benefits/Deduction
record has been deleted.
PDRBEHS_USER_ID VARCHAR2 30 NO USER ID: User or process
that updated record.
PDRBEHS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
Date: 21-JUN-2004 Page: 42
TABLE: PDRBENE
CREATOR: PAYROLL
Dependent and Beneficiary Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRBENE_PIDM NUMBER 8 NO Internal ID number.
PDRBENE_SEQ_NO NUMBER 2 NO Sequence number identifying the Dependent/Beneficiary.
PDRBENE_BENE_PIDM NUMBER 8 YES Internal ID number of Dependent/Beneficiary. This may
be left NULL if the indi dual has not been established
on the system.
PDRBENE_BENE_LAST_NAME VARCHAR2 30 YES Beneficiary Last Name. This will be NULL if the
Beneficiary PIDM column is fil d.
PDRBENE_BENE_FIRST_NAME VARCHAR2 15 YES Beneficiary First Name. This will be NULL if the
Beneficiary PIDM column is fi ed.
PDRBENE_BENE_MI VARCHAR2 15 YES Beneficiary Middle Initial. This will be NULL if the
Beneficiary PIDM column i filled.
PDRBENE_BREL_CODE VARCHAR2 1 NO RELATIONSHIP CODE: Code used to identify the
relationship of the beneficiary to the employee. The
relationship code must be previously defined on the
Beneficiary Relationship Rule Form (PTRBREL).
PDRBENE_SEX_IND VARCHAR2 1 YES Indicates Gender of Beneficiary. This will be NULL if
the Beneficiary PIDM col n is filled.
PDRBENE_BIRTH_DATE DATE 7 YES Birth Date of Beneficiary. This will be NULL if the
Beneficiary PIDM column is illed.
PDRBENE_COLLEGE_IND VARCHAR2 1 NO COLLEGE INDICATOR; Indicates if the beneficiary is
presently attending college
PDRBENE_ACTIVITY_DATE DATE 7 NO Date of the last activity (insert or update) on this
record.
PDRBENE_SSN VARCHAR2 9 YES Beneficiary Social Security Number.
Date: 21-JUN-2004 Page: 43
TABLE: PDRBFLX
CREATOR: PAYROLL
Flex Benefit Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRBFLX_PIDM NUMBER 8 NO PIDM: Internal person identification number.
PDRBFLX_FLEX_AMT NUMBER 11 2 YES FLEX AMOUNT: Employee available flex amount.
PDRBFLX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
updated.
Date: 21-JUN-2004 Page: 44
TABLE: PDRDEDN
CREATOR: PAYROLL
Employee Deduction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRDEDN_PIDM NUMBER 8 NO PIDM : Internal System Identification Number.
PDRDEDN_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: The code assigned to the
benefit/deduction.
PDRDEDN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The date the benefit/deduction becomes
effective.
PDRDEDN_STATUS VARCHAR2 1 NO STATUS: The status of the benefit/deduction.
PDRDEDN_REF_NO VARCHAR2 10 YES REFERENCE NUMBER: An optional alpha/numeric field.
PDRDEDN_AMOUNT1 NUMBER 11 2 YES AMOUNT 1: The first amount field for the
benefit/deduction. The use of this field is
determined by the calculation rule assigned to the
benefit/deduction.
PDRDEDN_AMOUNT2 NUMBER 11 2 YES AMOUNT 2: The second amount field for the
benefit/deduction. The use of this field is
determined by the calculation rule assigned to the
benefit/deduction.
PDRDEDN_AMOUNT3 NUMBER 11 2 YES AMOUNT 3: The third amount field for the
benefit/deduction. The use of this field is
determined by the calculation rule assigned to the
benefit/deduction.
PDRDEDN_AMOUNT4 NUMBER 11 2 YES AMOUNT 4: The fourth amount field for the
benefit/deduction. The use of this field is
determined by the calculation rule assigned to the
benefit/deduction.
PDRDEDN_OPT_CODE1 VARCHAR2 2 YES OPTION CODE 1: The first option code for the
benefit/deduction code. The use of this field is
determined by the calculation rule assigned to the
benefit/ deduction.
PDRDEDN_OPT_CODE2 VARCHAR2 2 YES OPTION CODE 2: The second option code for the
benefit/deduction. The use of this field is
determined by the calculation rule assigned to the
benefit/ deduction.
PDRDEDN_OPT_CODE3 VARCHAR2 2 YES OPTION CODE 3: The third option code for the
benefit/deduction. The use of this field is
determined by the calculation rule assigned to the
benefit/ deduction.
PDRDEDN_OPT_CODE4 VARCHAR2 2 YES OPTION CODE 4: The fourth option code for the
benefit/deduction. The use of option code is
determined by the calculation rule assigned to the
benefit/ deduction.
PDRDEDN_OPT_CODE5 VARCHAR2 2 YES OPTION CODE 5: The fifth option code for the
benefit/deduction code. The use of the field is
determined by the calculation rule assigned to the
benefit/ deduction code.
PDRDEDN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PDRDEDN_COVERAGE_DATE DATE 7 YES COVERAGE DATE; Set equal to benefit/deduction begin
date via the Employee Benefit/Deduction Setup Form.
Currently not utilized
Date: 21-JUN-2004 Page: 45
TABLE: PDRDEDN_MBCVT_MPSERS2
CREATOR: PAYROLL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
R_RECTYPE VARCHAR2 1 YES
CDT_NEW_EMPLID VARCHAR2 9 YES
CDT_SSN VARCHAR2 9 YES
CDT_LASTNAME VARCHAR2 20 YES
CDT_FIRSTNAME VARCHAR2 15 YES
ADP_EMPLID VARCHAR2 11 YES
CVT_PDRDEDN_PIDM NUMBER 8 YES
ADP_DEDCD VARCHAR2 3 YES
FED_FICA_STATUS_EE VARCHAR2 1 YES
CVT_PDRDEDN_BDCA_CODE VARCHAR2 3 YES
CVT_PDRDEDN_EFFECTIVE_DATE DATE 7 YES
CVT_PDRDEDN_COVERAGE_DATE DATE 7 YES
CVT_PDRDEDN_STATUS VARCHAR2 1 YES
CVT_PDRDEDN_REF_NO VARCHAR2 10 YES
FED_FWT_ADDL_AMT NUMBER 7 2 YES
STATE_SWT_ADDL_AMT NUMBER 7 2 YES
GENL_DED_ADDL_AMT NUMBER 10 2 YES
GENL_DED_RATE_PCT NUMBER 7 3 YES
CVT_PDRDEDN_AMOUNT1 NUMBER 11 2 YES
GENL_GOAL_AMT NUMBER 10 2 YES
CVT_PDRDEDN_AMOUNT2 NUMBER 11 2 YES
FED_FWT_MAR_STATUS VARCHAR2 1 YES
CVT_PDRDEDN_OPT_CODE1 VARCHAR2 2 YES
FED_FWT_ALLOWANCES NUMBER 4 YES
STATE_SWT_ALLOWANCES NUMBER 4 YES
CVT_PDRDEDN_OPT_CODE2 VARCHAR2 2 YES
CVT_PDRDEDN_ACTIVITY_DATE DATE 7 YES
PEBEMPL_PIDM_EXISTS VARCHAR2 1 YES
FED_EFFDT DATE 7 YES
FED_FWT_ADDL_PCT NUMBER 5 3 YES
FED_SPECIAL_FWT_STATUS VARCHAR2 1 YES
STATE_EFFDT DATE 7 YES
STATE_STATE VARCHAR2 2 YES
STATE_RESIDENT VARCHAR2 1 YES
STATE_NON_RES_DECLARED VARCHAR2 1 YES
STATE_SPECIAL_SWT_STATUS VARCHAR2 1 YES
STATE_SWT_MAR_STATUS VARCHAR2 1 YES
STATE_SWT_ADDL_ALLOWANCES NUMBER 4 YES
STATE_SWT_ADDL_PCT NUMBER 5 3 YES
GENL_EFFDT DATE 7 YES
GENL_EMPL_RCD_NBR NUMBER 4 YES
GENL_DED_CALC VARCHAR2 1 YES
GENL_DEDUCTION_END_DT DATE 7 YES
GENL_GOAL_BAL NUMBER 10 2 YES
GENL_GOAL_LIMIT_NBR VARCHAR2 1 YES
ADP_EMPL_STATUS VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 46
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ADP_PAYGROUP VARCHAR2 3 YES
ADP_EMPL_RCD_NBR VARCHAR2 4 YES
ADP_EFFSEQ VARCHAR2 4 YES
ADP_ACTION VARCHAR2 4 YES
ADP_ACTION_DT VARCHAR2 4 YES
ADP_ACTION_REASON VARCHAR2 4 YES
ADP_FULL_NAME VARCHAR2 40 YES
Date: 21-JUN-2004 Page: 47
TABLE: PDRF496
CREATOR: PAYROLL
F-496 REQUIRED DATA ELEMENTS TABLE.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRF496_FISC_YEAR NUMBER 4 NO FISCAL YEAR: Fiscal
year code.
PDRF496_PIDM NUMBER 8 NO PIDM: Internal identifier.
PDRF496_SSN VARCHAR2 9 NO SSN: Social Security Number.
PDRF496_LAST_NAME VARCHAR2 10 YES LAST NAME: Employee
last name.
PDRF496_FIRST_NAME VARCHAR2 8 YES FIRST NAME: Employee
first name.
PDRF496_MI VARCHAR2 2 YES MIDDLE INITIAL: Employee First
and Middle Initials.
PDRF496_MEMBER_CODE NUMBER 1 NO MEMBER CODE: Membership
Code.
PDRF496_ASSN_CODE NUMBER 3 YES ASSIGNMENT CODE: Employee
Job Assignment Code.
PDRF496_PAY_RATE NUMBER 9 3 YES PAY RATE: Pay Rate.
PDRF496_PAY_CODE NUMBER 1 YES PAY CODE: Pay Code.
PDRF496_ELIG_GRS NUMBER 7 2 YES ELIGIBLE GROSS:
Total Eligible Earning.
PDRF496_EMPL_CONT_RATE NUMBER 5 2 YES EMPLOYEE
CONTRIBUTION RATE: Employee Contribution
Code.
PDRF496_CONT_CODE NUMBER 1 YES CONTRIBUTION CODE:
Contribution Code.
PDRF496_EMPLOYEE_AMT NUMBER 6 2 YES EMPLOYEE AMOUNT:
Member Contribution Amount.
PDRF496_COUNTY_CODE VARCHAR2 4 NO COUNTY CODE:
County Code.
PDRF496_DISTRICT_CODE VARCHAR2 3 NO DISTRICT CODE:
District Code.
PDRF496_SERVICE_BEGIN NUMBER 8 YES SERVICE BEGIN:
Beginning of the service.
PDRF496_SERVICE_END NUMBER 8 YES SERVICE END:
Ending of the service.
PDRF496_EMPR_CONT_RATE NUMBER 5 2 YES EMPLOYER CONTRIBUTION
RATE: Employer Contribution
Rate.
PDRF496_EMPLOYER_AMT NUMBER 6 2 YES EMPLOYER AMOUNT:
Employer Contribution.
PDRF496_REPORT_IND VARCHAR2 1 NO REPORT INDICATOR:
Indicates if this deduction was
reported.
PDRF496_USERID VARCHAR2 30 NO USER ID: User or process
that updated record.
PDRF496_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:
Date of the action was initiated.
PDRF496_REPORT_NO VARCHAR2 2 NO REPORT NO; Numerical sequence of normal monthly report
numbered chronologically
PDRF496_EMPL_PRETAX_AMT NUMBER 6 2 YES STRS/PERS employee pretax deduction amount
Date: 21-JUN-2004 Page: 48
TABLE: PDRFBAL
CREATOR: PAYROLL
Employee Flexible Benefits Balance Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRFBAL_PLAN_YEAR NUMBER 4 NO Benefit Plan Year.
PDRFBAL_PIDM NUMBER 8 NO Employee Identification Number.
PDRFBAL_BDCA_CODE VARCHAR2 3 NO Flexible Spending Account code.
PDRFBAL_PLAN_CODE VARCHAR2 2 YES Flexible Spending Account plan code.
PDRFBAL_AMOUNT_AVAIL NUMBER 11 2 YES Total amount available for this account.
PDRFBAL_AMOUNT_SPENT NUMBER 11 2 YES Total amount spent for this account.
PDRFBAL_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 49
TABLE: PDRFCLM
CREATOR: PAYROLL
Employee Flexible Benefits Claims Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRFCLM_PIDM NUMBER 8 NO Employee Identification Number.
PDRFCLM_BDCA_CODE VARCHAR2 3 NO Flexible Spending Account code.
PDRFCLM_PLAN_CODE VARCHAR2 2 YES Flexible Spending Account plan code.
PDRFCLM_CLAIM_DATE DATE 7 NO Date of claim.
PDRFCLM_REF_NO VARCHAR2 10 YES Reference number of claim.
PDRFCLM_CLAIM_AMT NUMBER 11 2 YES Amount of claim that will be paid.
PDRFCLM_CLAIM_PAID NUMBER 11 2 YES Date of Last Modification of the Record.
PDRFCLM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of the last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 50
TABLE: PDRFLEX
CREATOR: PAYROLL
Employee Flexible Benefits Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRFLEX_PIDM NUMBER 8 NO Internal ID code.
PDRFLEX_BDCA_CODE VARCHAR2 3 NO Flexible Benefit Code.
PDRFLEX_PLAN_CODE VARCHAR2 2 YES Flexible Benefit Plan.
PDRFLEX_STATUS VARCHAR2 1 NO Status: The flexible benefit/deduction status.
PDRFLEX_START_DATE DATE 7 NO Start Date: The start date of the Benefit/Deduction
code.
PDRFLEX_END_DATE DATE 7 YES End Date: Then end date of the Benefit/Deduction code.
PDRFLEX_AMOUNT1 NUMBER 13 4 YES Amount 1
PDRFLEX_AMOUNT2 NUMBER 13 4 YES Amount 2
PDRFLEX_AMOUNT3 NUMBER 11 2 YES Amount 3
PDRFLEX_AMOUNT4 NUMBER 11 2 YES Amount 4
PDRFLEX_LIF_OVR_UDR_AMT NUMBER 11 2 YES Flexible Amount: This field holds the flexible amounts
for Life Insurance and the Overage/Underage code that
is created.
PDRFLEX_APPR_IND VARCHAR2 1 YES Approved Indicator.
PDRFLEX_PROCESS_IND VARCHAR2 1 YES Process Indicator: This field indicates if the
flexible deductions have been inserted into the
employee deduction table (PDRDEDN).
PDRFLEX_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 51
TABLE: PDRMR87
CREATOR: PAYROLL
MR-87 REQUIRED DATA ELEMENTS TABLE.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRMR87_BATCH_NO NUMBER 3 NO BATCH NUMBER: Batch number.
PDRMR87_PIDM NUMBER 8 NO PIDM: Internal Identifier.
PDRMR87_87TR_CODE NUMBER 2 NO 87TR CODE: 87 Transaction
Code.
PDRMR87_SSN VARCHAR2 9 NO SSN: Social Security Number.
PDRMR87_LAST_NAME VARCHAR2 13 YES LAST NAME: Employee
Last Name.
PDRMR87_FIRST_NAME VARCHAR2 12 YES FIRST NAME: Employee
First Name.
PDRMR87_MI VARCHAR2 2 YES MIDDLE INITIAL: Employee
Middle Initial.
PDRMR87_SEX_IND VARCHAR2 1 NO SEX INDICATOR: Employee
Sex Indicator.
PDRMR87_BIRTH_DATE DATE 7 YES BIRTH DATE: Employee
Birth Date.
PDRMR87_COUNTY_CODE VARCHAR2 2 NO COUNTY CODE: County
Code.
PDRMR87_DISTRICT_CODE VARCHAR2 3 NO DISTRICT CODE: District
Code.
PDRMR87_TYPE_CODE NUMBER 1 YES TYPE CODE: Type Code.
PDRMR87_EMPL_ID NUMBER 6 YES EMPLOYEE ID: Banner
Employee Number truncated to 6
numbers.
PDRMR87_EMPL_DATE DATE 7 YES EMPLOYMENT DATE:
Employment Date.
PDRMR87_FULL_TIME_IND VARCHAR2 1 YES FULL TIME
INDICATOR: Full time employee indicator.
PDRMR87_PART_TIME_IND VARCHAR2 1 YES PART TIME
INDICATOR: Part time employee indicator.
PDRMR87_SUBSTITUTE_IND VARCHAR2 1 YES SUBSTITUTE
INDICATOR: Indicates if employee is
substitute.
PDRMR87_REPORT_IND VARCHAR2 1 NO REPORT INDICATOR:
Indicates if this deduction was
reported.
PDRMR87_USERID VARCHAR2 30 NO USER ID: User or process
that updated record.
PDRMR87_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:
Date of the action was initiated.
Date: 21-JUN-2004 Page: 52
TABLE: PDRPERS
CREATOR: PAYROLL
California PERS Report of Payroll
Contributions Required Data Elements Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRPERS_PIDM NUMBER 8 NO PIDM: Personal indentifcation code for an individual
tracked in the system.
PDRPERS_COUNTY_CODE VARCHAR2 4 NO COUNTY CODE: County
Code.
PDRPERS_DISTRICT_CODE VARCHAR2 3 NO DISTRICT CODE: District
Code.
PDRPERS_SSN VARCHAR2 9 NO This field maintains person social security number.
PDRPERS_SERVICE_PERIOD NUMBER 5 YES
PDRPERS_LAST_NAME VARCHAR2 10 YES This field defines the last name of person.
PDRPERS_FIRST_NAME VARCHAR2 8 YES This field identifies the first name of person.
PDRPERS_MI VARCHAR2 1 YES This field identifies the middle name of person.
PDRPERS_GROUP NUMBER 5 YES GROUP: Employee group or assignment code.
PDRPERS_ELIGIBLE_GRS NUMBER 7 2 YES ELIGIBLE GROSS: Eligible earnings.
PDRPERS_PAY_RATE NUMBER 8 3 YES PAY RATE: Pay Rate.
PDRPERS_PAY_CODE NUMBER 2 YES PAY CODE: Pay code.
PDRPERS_POST_TAX_AMT NUMBER 6 2 YES PERS CONTRIBUTION AMOUNT; Amount deducted for PERS
post tax
PDRPERS_CONT_CODE NUMBER 2 YES Contribution Code.
PDRPERS_EMPL_CONT_RATE NUMBER 6 2 YES EMPLOYEE CONTRIBUTION RATE: Employee contribution
rate.
PDRPERS_WORK_SCHEDULE NUMBER 3 YES WORK SCHEDULE CODE; Normal Hours of work for this
employee class
PDRPERS_PRE_TAX_AMT NUMBER 6 2 YES PERS TAX DEFERRED MEMBER CONTRIBUTION AMOUNT; Amount
deducted for PERS pre tax plus employer contributed
amount
PDRPERS_REPORT_IND VARCHAR2 1 NO REPORT INDICATOR; Indicates if period has been
reported
PDRPERS_USERID VARCHAR2 30 NO USER ID: User or process
that updated record.
PDRPERS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
PDRPERS_BATCH_NO VARCHAR2 3 NO BATCH NUMBER: Batch number.
PDRPERS_SURVIVOR_AMT NUMBER 3 2 YES SURVIVOR CONTRIBUTION; Flat amount deduction for PERS
survivor option
PDRPERS_EMPR_CONT_RATE NUMBER 11 6 YES EMPLOYER CONTRIBUTION RATE: Employer contribution
rate.
Date: 21-JUN-2004 Page: 53
TABLE: PDRXPID
CREATOR: PAYROLL
Emp Dedn Excl Pay Id Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PDRXPID_PIDM NUMBER 8 NO PIDM: Internal ID number.
PDRXPID_BDCA_CODE VARCHAR2 3 NO DEDUCTION CODE: The deduction code for which an
excluded Pay ID is being defined.
PDRXPID_PICT_CODE VARCHAR2 2 NO PAY ID CODE: The Pay ID code which is being excluded
from processing for this deduction.
PDRXPID_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 54
TABLE: PEAPNHZ
CREATOR: PAYROLL
Health and Safety Position Hazard Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEAPNHZ_POSN VARCHAR2 6 NO POSITION: Position number associated with the hazard
code.
PEAPNHZ_HAZD_CODE VARCHAR2 4 NO HAZARD CODE: Hazard Code associated with the position.
PEAPNHZ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 55
TABLE: PEBEMPL
CREATOR: PAYROLL
Employee Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBEMPL_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PEBEMPL_EMPL_STATUS VARCHAR2 1 NO EMPLOYEE STATUS: The status of the employee.
PEBEMPL_COAS_CODE_HOME VARCHAR2 1 YES CHART OF ACCOUNTS CODE HOME: The home Chart of
Accounts Code for the employee.
PEBEMPL_ORGN_CODE_HOME VARCHAR2 6 NO HOME ORGANIZATION CODE: The home organization code of
the employee.
PEBEMPL_COAS_CODE_DIST VARCHAR2 1 YES CHART OF ACCOUNTS CODE DISTRIBUTION: The Chart of
Accounts Code to which this emplyees labor is
distributed.
PEBEMPL_ORGN_CODE_DIST VARCHAR2 6 NO ORGANIZATION CODE DISTRIBUTION: The organization code
used for labor distribution.
PEBEMPL_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: The employee grouping to which
the employee belongs.
PEBEMPL_LCAT_CODE VARCHAR2 2 NO LEAVE CATEGORY CODE: The leave category to which the
employee belongs.
PEBEMPL_BCAT_CODE VARCHAR2 2 NO BENEFIT CATEGORY CODE: The benefit category to which
the employee belongs.
PEBEMPL_FIRST_HIRE_DATE DATE 7 NO FIRST HIRE DATE: The date the employee was first
hired.
PEBEMPL_CURRENT_HIRE_DATE DATE 7 NO CURRENT HIRE DATE: The employees current date of hire.
PEBEMPL_ADJ_SERVICE_DATE DATE 7 NO ADJUSTED SERVICE DATE: Date used to determine years of
service for leave accrual if the First Hire Date and
Current Hire Date are not equal.
PEBEMPL_SENIORITY_DATE DATE 7 NO SENIORITY DATE: Currently not used by system.
Reserved for future use.
PEBEMPL_LREA_CODE VARCHAR2 2 YES LEAVE REASON CODE: A code identifying the reason of
the leave of absence for the employee.
PEBEMPL_LOA_BEG_DATE DATE 7 YES LEAVE OF ABSENCE BEGIN DATE: The begin date of a leave
of absence for the employee.
PEBEMPL_LOA_END_DATE DATE 7 YES LEAVE OF ABSENCE END DATE: The anticipated end date
for an employees leave of absence.
PEBEMPL_TREA_CODE VARCHAR2 2 YES TERMINATION REASON CODE: Code used to identify the
reason of termination.
PEBEMPL_TERM_DATE DATE 7 YES TERMINATION DATE: Termination date of the employee.
PEBEMPL_I9_FORM_IND VARCHAR2 1 YES I9 FORM INDICATOR: Indicates whether or not
immigration information has been received.
PEBEMPL_I9_DATE DATE 7 YES I9 DATE: The date immigration information was
received.
PEBEMPL_I9_EXPIRE_DATE DATE 7 YES I9 EXPIRATION DATE: The date the immigration
information expires.
PEBEMPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PEBEMPL_WKPR_CODE VARCHAR2 4 YES WKPR_CODE: Work Period Code
PEBEMPL_FLSA_IND VARCHAR2 1 NO FLSA INDICATOR: Used for Fair Labor Overtime
compensation. (C)ash, (A)ccrual or (N)o FLSA.
PEBEMPL_STGR_CODE VARCHAR2 2 YES STGR_CODE: Statistics Canada Grouping Code.
PEBEMPL_DAYS_IN_CANADA NUMBER 3 YES DAYS IN CANADA: Number of days employee worked in
Canada.
Date: 21-JUN-2004 Page: 56
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBEMPL_1042_RECIPIENT_CD VARCHAR2 2 YES 1042 RECIPIENT CODE: Identifies the type of individual
who is receiving this 1042 statement.
PEBEMPL_INTERNAL_FT_PT_IND VARCHAR2 1 NO Internal Part Time/Full Time Indicator, used for EEO
reporting.
PEBEMPL_DICD_CODE VARCHAR2 3 YES DISTRICT/DIVISION CODE: The district or division
associated with an employee.
PEBEMPL_EGRP_CODE VARCHAR2 4 YES EMPLOYEE GROUP CODE: An employee classification which
is broken down into employee classes.
PEBEMPL_IPEDS_SOFT_MONEY_IND VARCHAR2 1 YES IPEDS Soft Money Indicator.
PEBEMPL_FIRST_WORK_DATE DATE 7 YES The first day that employee worked.
PEBEMPL_LAST_WORK_DATE DATE 7 YES The last day that employee worked.
PEBEMPL_CALIF_PENSION_IND VARCHAR2 1 YES California Pension Indicator.
PEBEMPL_NRSI_CODE VARCHAR2 4 YES NRSI CODE:Non-resident Service Code.
PEBEMPL_SSN_LAST_NAME VARCHAR2 20 YES Social security last name used in regulatory.
PEBEMPL_SSN_FIRST_NAME VARCHAR2 15 YES Social security first name used in regulatory.
PEBEMPL_SSN_MI VARCHAR2 15 YES Social security middle name used in regulatory.
PEBEMPL_SSN_SUFFIX VARCHAR2 4 YES Social security name suffix used in regulatory.
PEBEMPL_JBLN_CODE VARCHAR2 6 YES LOCATION CODE: The Location to which the employee
belongs.
PEBEMPL_COLL_CODE VARCHAR2 2 YES COLLEGE CODE: The College to which the employee
belongs.
PEBEMPL_CAMP_CODE VARCHAR2 3 YES CAMPUS CODE: The Campus to which the employee belongs.
Date: 21-JUN-2004 Page: 57
TABLE: PEBGREV
CREATOR: PAYROLL
Grievance Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBGREV_NO NUMBER 8 NO GREVIANCE NUMBER: Unique identification number of this
grievance.
PEBGREV_DESC VARCHAR2 60 NO DESC: Brief description of the grievance.
PEBGREV_GRTP_CODE VARCHAR2 4 NO GRTP CODE: Grievance Type Code associated with the
grievance.
PEBGREV_ISTA_CODE VARCHAR2 1 NO ISTA CODE: Incident Status Code associated with the
grievance.
PEBGREV_ISTA_DATE DATE 7 NO ISTA DATE: Date the status was established.
PEBGREV_FILED_DATE DATE 7 NO FILED DATE: Date the grievance was filed.
PEBGREV_RESOLVED_DATE DATE 7 YES RESOLVED DATE: Date the grievance was resolved.
PEBGREV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 58
SEQUENCE: PEBGSEQ
CREATOR: PAYROLL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 34
Cache Size: 20
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 59
SEQUENCE: PEBHSEQ
CREATOR: PAYROLL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 5
Cache Size: 20
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 60
TABLE: PEBHSIN
CREATOR: PAYROLL
Health and Safety Incident Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBHSIN_NO NUMBER 8 NO NUMBER: Unique identification number associated with
this record.
PEBHSIN_DESC VARCHAR2 50 NO DESCRIPTION: Brief description of the incident.
PEBHSIN_INCIDENT_DATE DATE 7 NO INCIDENT DATE: The date the incident took place.
PEBHSIN_HSIL_CODE VARCHAR2 6 YES INCIDENT LOCATION CODE: Code associated with the
location of the incident.
PEBHSIN_ISTA_CODE VARCHAR2 1 NO STATUS: Indicates the status code of the incident.
PEBHSIN_ISTA_DATE DATE 7 NO STATUS DATE: Indicates the date that the status was
changed.
PEBHSIN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 61
SEQUENCE: PEBJSEQ
CREATOR: PAYROLL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999999999999999
Increment: 1
Last Number: 1
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 62
TABLE: PEBPAYM
CREATOR: PAYROLL
One-Time Payments Payment Method Information Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBPAYM_PIDM NUMBER 8 NO PIDM: Personal identification code for an individual
tracked in the system.
PEBPAYM_DOC_TYPE VARCHAR2 1 NO DOCUMENT TYPE: The document type. Valid values are:
(C)heck or (D)irect Deposit.
PEBPAYM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
PEBPAYM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
PEBPAYM_BANK_ROUT_NUM VARCHAR2 9 YES BANK ROUTING NO: The bank routing number of the
recipients bank.
PEBPAYM_BANK_ACCT_NUM VARCHAR2 17 YES BANK ACCOUNT NO: The account number of the recipients
account.
PEBPAYM_ACCT_TYPE VARCHAR2 1 YES ACCOUNT TYPE: The type of account for direct deposit
(checking or savings).
Date: 21-JUN-2004 Page: 63
TABLE: PEBROEC
CREATOR: PAYROLL
Record of Employment Information Base table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBROEC_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PEBROEC_PICT_CODE VARCHAR2 2 NO PAY PERIOD PAY IDENTIFICATION CODE.
PEBROEC_ISSUE_DATE DATE 7 NO ISSUE DATE: The date which the ROE is completed.
PEBROEC_PRINT_IND VARCHAR2 1 YES PRINT INDICATOR: When the print indicator is (N)o or
Null, perroec can be printed.
PEBROEC_SERIAL_NO_AMEND VARCHAR2 12 YES SERIAL NUMBER: Serial Number of Record of Employment
amended or replaced.
PEBROEC_REFERENCE_NO VARCHAR2 12 YES REFERENCE NUMBER: Used for to record employee file
reference such as payroll or badge number, if
applicable.
PEBROEC_LANGUAGE_IND VARCHAR2 1 NO LANGUAGE INDICATOR: The official language(French or
English) of the issuee.
PEBROEC_OCCUPATION VARCHAR2 40 NO OCCUPATION: An accurate description of the employee
usual occupation (two or more words). For example:
sales clerk, stock clerk, auto mechanic, contruction
labourer.
PEBROEC_FIRST_DAY_WORKED DATE 7 NO FIRST DAY WORKED: The actual day the employee started
to work.
PEBROEC_LAST_DAY_WORKED DATE 7 NO LAST DAY WORKED: The actual last date the employee
performed services. If the employee has reached age
65 and continues to work, enter the date of the last
day worked in the month in which the 65th birthday
occured.
PEBROEC_UI_PREMIUM_DATE DATE 7 NO UI PREMIUM DATE: The last day for which the employer
pay UI premiums for this employee. The date of the
interruption of earnings and the same as the last day
worked. Otherwise explain in the Comment section.
PEBROEC_FINAL_PAY_END_DATE DATE 7 NO FINAL PAY PERIOD ENDING DATE: Indicate the actual
ending date of the final regular pay period in which
the interruption of earnings occurred.
PEBROEC_VACATION_PAY NUMBER 11 2 YES VACATION PAY: The gross amount of vacation pay.
PEBROEC_FINAL_PAY_IND VARCHAR2 1 YES FINAL PAY PERIOD INDICATOR: Indicates whether the
reported insurable monies have been allocated to the
final pay period.
PEBROEC_LEAVE_START DATE 7 YES LEAVE START DATE: The date these payments start.
PEBROEC_LEAVE_DURATION NUMBER 3 YES LEAVE DURATION: The number of weeks or days for which
they are payable and the amount of these payments or
the percentage of salary to be paid.
PEBROEC_LEAVE_DURATION_IND VARCHAR2 1 YES LEAVE DURATION INDICATOR: Indicates for the (W)eekly
or (D)aily rate.
PEBROEC_LEAVE_AMOUNT NUMBER 11 2 YES LEAVE AMOUNT: Paid sick/maternity/paternity leave or
group wage-loss indemnitypayments after the last day
worked.
PEBROEC_ROER_CODE VARCHAR2 1 NO CODE A: Shortage of work, Code B: Strike or lock-out,
Code C: Return to school, Code D: Illness or injury,
Code E: Quit, Code F: Pregnancy/Adoption, Code G:
Retirement under age 65.
Date: 21-JUN-2004 Page: 64
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEBROEC_CONTACT_PIDM NUMBER 8 YES CONTACT PIDM: Internal System Identification Number of
the contact person.
PEBROEC_CONTACT_PH_AREA VARCHAR2 3 YES AREA CODE OF THE CONTACT PERSON.
PEBROEC_CONTACT_PH_NUMBER VARCHAR2 7 YES PHONE NUMBER OF THE CONTACT PERSON.
PEBROEC_CONTACT_PH_EXT VARCHAR2 4 YES EXTENSION PHONE NUMBER.
PEBROEC_RETURN_DATE DATE 7 YES RETURN DATE: The expected date of recall. This
usually occurs in case of illness or injury,
pregnancy, paternity or adoption leave or a temporary
layoff.
PEBROEC_RETURN_IND VARCHAR2 1 YES RETURN INDICATOR: Used for a possibility of returning
but the date is (U)nknown or if the employee will
(N)ot be returning.
PEBROEC_ISSUER_PIDM NUMBER 8 NO ISSUER PIDM: Internal System Identification Number of
the issuer.
PEBROEC_ISSUER_PH_AREA VARCHAR2 3 NO AREA CODE OF THE PHONE NUMBER OF THE ISSUER.
PEBROEC_ISSUER_PH_NUMBER VARCHAR2 7 NO PHONE NUMBER OF THE ISSUER.
PEBROEC_ISSUER_PH_EXT VARCHAR2 4 YES EXTENSION PHONE NUMBER OF THE ISSUER.
PEBROEC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PEBROEC_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification code.
Date: 21-JUN-2004 Page: 65
TABLE: PER1042
CREATOR: PAYROLL
1042S Information Upload Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PER1042_PIDM NUMBER 8 NO PIDM: Internal identification number of the person.
PER1042_ID VARCHAR2 9 NO ID: This field defines the identification number used
to access person on-line.
PER1042_INCOME_CODE VARCHAR2 2 NO INCOME CODE: The code which identifies the type of
income received in association with this 1042 record.
PER1042_EXEMPTION_CODE VARCHAR2 1 NO EXEMPTION CODE: Indicates a reason as to why these
dollars are exempt from taxation. 0=Not
Exempt,
1=Income effectively connected with US trade
or business, 2=Exempt, 3=Income is non-US sourced,
4=No withholding per treaty.
PER1042_WITHHOLDING_RATE NUMBER 7 2 NO TAX RATE: The value which indentifies the tax rate on
which the withholding is calculated in association
with this 1042 record.
PER1042_COUNTRY_CODE VARCHAR2 2 NO COUNTRY CODE: The code which identifies the country
for which tax treaty benefits and rates are based on
in association with this 1042 record.
PER1042_SSN VARCHAR2 9 YES SSN: Social Security Number.
PER1042_LAST_NAME VARCHAR2 60 YES LAST NAME: This field defines the last name of person.
PER1042_FIRST_NAME VARCHAR2 15 YES FIRST NAME: This field identifies the first name of
person.
PER1042_MI VARCHAR2 15 YES MIDDLE NAME: This field identifies the middle name of
person.
PER1042_BIRTH_DATE DATE 7 YES BIRTH DATE: Date of Birth.
PER1042_GROSS_INCOME_PAID NUMBER 11 2 YES GROSS INCOME PAID: The total amount paid.
PER1042_WITHHOLDING_ALLOW NUMBER 9 2 YES WITHHOLDING ALLOWANCE: The value which indentifies the
amount exempted from gross before the tax is
calculated in association with this 1042 record.
PER1042_WITHHELD_AMOUNT NUMBER 9 2 YES US FEDERAL TAX: Federal Tax With held.
PER1042_INCOME_CODE_SUBTYPE VARCHAR2 1 YES INCOME CODE SUBTYPE: Income code subtype associated
with the income code.
PER1042_CYCLE_DATE DATE 7 YES CYCLE DATE: Last payroll date
PER1042_TAX_YEAR VARCHAR2 4 YES TAX YEAR: Tax year.
PER1042_STATE_WH_AMOUNT NUMBER 11 2 YES STATE WITHHELD AMOUNT: State Withheld Amount.
PER1042_STATE_CODE VARCHAR2 2 YES STATE CODE: State Code.
PER1042_RECORD_STATUS VARCHAR2 1 YES RECORD STATUS: Records status Actual or Forecast Data.
PER1042_LAST_EARN_DATE DATE 7 YES LAST EARN DATE: Last payroll Date.
Date: 21-JUN-2004 Page: 66
TABLE: PERACTL
CREATOR: PAYROLL
Faculty Action Academic Title Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERACTL_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERACTL_EFFECTIVE_DATE DATE 7 NO Academic Title effective date.
PERACTL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
PERACTL_ORGN VARCHAR2 6 YES Organization code.
PERACTL_COAS_CODE VARCHAR2 1 YES Chart of accounts code.
PERACTL_POSN VARCHAR2 6 YES POSITION: The employee position number.
PERACTL_SUFF VARCHAR2 2 YES SUFFIX: A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERACTL_ACADEMIC_TITLE VARCHAR2 80 YES Academic Title.
PERACTL_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user who changed the record.
Date: 21-JUN-2004 Page: 67
TABLE: PERAHIS
CREATOR: PAYROLL
Employee Accommodation History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERAHIS_PIDM NUMBER 8 NO PIDM: Internal Person ID Number.
PERAHIS_POSN VARCHAR2 6 NO POSITION: Position code associated with the job
assignment.
PERAHIS_SUFF VARCHAR2 2 NO SUFFIX: The suffix associated with the position.
PERAHIS_REQUEST_DATE DATE 7 NO REQUEST_DATE: It is the date the information was
initiated on behalf of the staff member by the
department to provide the accommodation.
PERAHIS_DELETE_IND VARCHAR2 1 NO DELETED_IND: An indicator to determine whether the
corresponding rows have been deleted from the parent
table PEREACC or not. If this indicator is set to Y,
then, the parent records have been deleted.
PERAHIS_RQST_CODE VARCHAR2 4 NO RQST_CODE: Request Status is the status of the request
and indicates whether accommodation will be provided
or not.
PERAHIS_MEDI_CODE VARCHAR2 2 NO MEDICAL_CODE: Med Code is associated with the persons
medical condition/physical impairment.
PERAHIS_VERIFY_IND VARCHAR2 1 NO VERIFY_IND: An indicator to determine whether medical
verification has been received.
PERAHIS_MDEQ_CODE VARCHAR2 3 NO EQUIPMENT_CODE: Indicates which equipment is necessary
to respond to the medical conditions identified on
this table.
PERAHIS_USER_ID VARCHAR2 30 NO USER ID: User ID of the User who created or last
updated the record.
PERAHIS_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date the record was created or last
updated.
PERAHIS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the record was created or last
updated.
PERAHIS_ACST_CODE VARCHAR2 4 YES ACST_CODE: It is the status of the accommodation for
this job, example is Active.
PERAHIS_DISA_CODE VARCHAR2 2 YES DISA_CODE: The codes utilized here identify the nature
of a disability.
PERAHIS_BEGIN_DATE DATE 7 YES BEGIN_DATE: The beginning date the institution
provided the accommodation to the staff member.
PERAHIS_END_DATE DATE 7 YES END_DATE: The end date of the accommodation.
Date: 21-JUN-2004 Page: 68
TABLE: PERAPPT
CREATOR: PAYROLL
Faculty Appointment/Tenure History Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERAPPT_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERAPPT_ACTION_DATE DATE 7 NO Action Date.
PERAPPT_ORGN VARCHAR2 6 YES Organization Code.
PERAPPT_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERAPPT_POSN VARCHAR2 6 YES The employees position number.
PERAPPT_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERAPPT_BEGIN_DATE DATE 7 NO Appointment/Reappointment Begin Date.
PERAPPT_END_DATE DATE 7 YES Appointment/Reappointment End Date.
PERAPPT_APPT_EFF_DATE DATE 7 NO Appointment Effective Date.
PERAPPT_NEXT_DATE DATE 7 YES Appointment Next Review Date.
PERAPPT_TENURE_CODE VARCHAR2 2 YES Tenure Code.
PERAPPT_INITIAL_TENURE VARCHAR2 1 YES Initial Tenure record.
PERAPPT_TENURE_EFF_DATE DATE 7 YES Tenure Effective Date.
PERAPPT_TENURE_TRAC_BEGIN_DATE DATE 7 YES TENURE TRACKING BEGIN DATE: Indicates the date when
tenure tracking started.
PERAPPT_TENURE_REV_DATE DATE 7 YES Tenure Review Date.
PERAPPT_REVT_TENURE_CODE VARCHAR2 2 YES Tenure Review Code.
PERAPPT_REVT_REAPP_CODE VARCHAR2 2 YES Appointment Review Code.
PERAPPT_CREDIT NUMBER 5 2 YES Tenure Credit This Appointment.
PERAPPT_TERMINAL_APPT VARCHAR2 1 YES Terminal Appointment.
PERAPPT_DECISION_DEFER_DATE DATE 7 YES Decision Deferred to Date.
PERAPPT_DECISION VARCHAR2 1 YES Appointment decision.
PERAPPT_DECISION_DATE DATE 7 YES Date of Decision.
PERAPPT_COMMENT LONG YES Appointment Commnets.
PERAPPT_DISP_CODE VARCHAR2 6 YES Discipline Code.
PERAPPT_FTYP_CODE VARCHAR2 6 YES Faculty Type Code.
PERAPPT_PREV_GRT_TENR NUMBER 5 2 YES Previous Tenure grant.
PERAPPT_APPEAL_DATE DATE 7 YES Appeal Date.
PERAPPT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
PERAPPT_TENURE_FTE NUMBER 7 4 YES FULL-TIME EQUIVALENT OF TENURE: This field indicates
FTE of Tenure for employee by department granting
tenure.
PERAPPT_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user who changed the record.
Date: 21-JUN-2004 Page: 69
TABLE: PERASGN
CREATOR: PAYROLL
Employee Assignment Data Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERASGN_REPORT_DATE DATE 7 NO REPORT DATE: The current reporting date that the
report was run.
PERASGN_PIDM NUMBER NO PIDM: Persons internal unique ID number.
PERASGN_DICD_CODE VARCHAR2 3 YES DISTRICT/DIVISION CODE: The district or division
associated with an employee.
PERASGN_TERM_IDENTIFIER VARCHAR2 3 YES
PERASGN_SSN VARCHAR2 9 YES SSN: Persons social security number.
PERASGN_ASSIGN_TYPE VARCHAR2 2 YES ASSIGNMENT TYPE: A code which identifies the type of
assignment.
PERASGN_LEAVE_STATUS VARCHAR2 1 YES LEAVE STATUS: Indicates the status of the employee
leave assignment.
PERASGN_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The account code for this employee.
PERASGN_WEEKLY_HRS NUMBER YES WEEKLY HOURS: Average number of hours per week
employee is contracted to spend on assignment.
PERASGN_HOURLY_RATE NUMBER YES HOURLY RATE: Hourly rate on assignment.
PERASGN_TOT_ANNUAL_HRS NUMBER YES TOTAL ANNUAL HOURS: The total number of hours the
employee worked.
PERASGN_TOT_PAYMENT NUMBER YES TOTAL PAYMENT: The gross pay the employee received for
each assignment.
PERASGN_FTE NUMBER YES FTE: The number of FTEs for this employee.
PERASGN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date this row was updated.
PERASGN_REPORT_NO VARCHAR2 5 NO MIS REPORT IDENTIFIER: This field indicates Assignment
Report Identifier.
PERASGN_REPORT_IND VARCHAR2 1 NO MIS REPORT INDICATOR: This field indicates Assignment
Report Indicator.
PERASGN_USERID VARCHAR2 30 NO USER IDENTIFICATION: This field indicates User ID.
Date: 21-JUN-2004 Page: 70
TABLE: PERBARG
CREATOR: PAYROLL
Employee Bargaining Unit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERBARG_PIDM NUMBER 8 NO PIDM: Identification number associated with a person.
PERBARG_BARG_CODE VARCHAR2 2 NO BARGAINING UNIT CODE: Bargaining Unit Code associated
with this person.
PERBARG_BURE_CODE VARCHAR2 2 NO RELATIONSHIP STATUS: Identifies the relationship
status the employee has with the selected bargaining
unit.
PERBARG_BARG_SENIORITY_DATE DATE 7 YES BARGAINING UNIT SENIORITY DATE: Seniority Date
associated with this bargaining unit for this person.
PERBARG_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date on which the bargaining unit
became effective for this person.
PERBARG_END_DATE DATE 7 YES END DATE: Date on which the bargaining unit was no
longer associated with this person.
PERBARG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 71
TABLE: PERBFAC
CREATOR: PAYROLL
Faculty Information Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERBFAC_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERBFAC_PRIMARY_ACTIVITY VARCHAR2 1 NO Primary
activity:Administrative,Instractional,Research.
PERBFAC_PREV_INST_CREDIT NUMBER 5 2 YES Previous Institution Credit.
PERBFAC_AAUP_IND VARCHAR2 1 YES AAUP Member Indicator.
PERBFAC_BIRTH_STATE VARCHAR2 3 YES Birth State.
PERBFAC_DISP_CODE VARCHAR2 6 YES Primary Discipline Code.
PERBFAC_FTYP_CODE VARCHAR2 6 YES Faculty Type Code.
PERBFAC_ACADEMIC_TITLE VARCHAR2 80 YES Academic Title.
PERBFAC_EMERITUS_STATUS VARCHAR2 1 YES Emeritus Status.
PERBFAC_ORIG_BEGIN_DATE DATE 7 YES Original Appointment Begin Date.
PERBFAC_ORIG_END_DATE DATE 7 YES Original Appointment End Date.
PERBFAC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
PERBFAC_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user who changed the record.
Date: 21-JUN-2004 Page: 72
TABLE: PERBFML
CREATOR: PAYROLL
Family Medical Leave Act Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERBFML_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERBFML_YEAR_IND VARCHAR2 1 NO FMLA Year Indicator: Indicates type of FMLA year
period.
PERBFML_YEAR VARCHAR2 4 NO FMLA Year: Year for current FMLA data being entered.
PERBFML_YEAR_BEGIN DATE 7 NO FMLA Year Begin: Begin Date for FMLA Year.
PERBFML_YEAR_END DATE 7 NO FMLA Year End: End Date for FMLA Year.
PERBFML_UNIT_IND VARCHAR2 1 NO FMLA Unit Indicator: Indicates type of FMLA unit.
PERBFML_MAX_UNITS NUMBER 6 2 NO FMLA Max Units: Maximum number of FMLA units.
PERBFML_SPOUSE_IND VARCHAR2 1 NO FMLA Spouse Indicator: Indicates if spouse.
PERBFML_SPOUSE_PIDM NUMBER 8 YES SPOUSE PIDM: Internal ID number.
PERBFML_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the action was initiated.
Date: 21-JUN-2004 Page: 73
TABLE: PERCAPL
CREATOR: PAYROLL
Faculty Action Appeal Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERCAPL_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERCAPL_ACTION VARCHAR2 1 NO Faculty Action.
PERCAPL_ACTION_DATE DATE 7 NO Faculty Action Date.
PERCAPL_ORGN VARCHAR2 6 YES Organization Code.
PERCAPL_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERCAPL_POSN VARCHAR2 6 YES The employees position number.
PERCAPL_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERCAPL_ALVL_CODE VARCHAR2 6 NO Approval Code.
PERCAPL_USER_ID VARCHAR2 30 NO Reviewer ID.
PERCAPL_FACC_CODE VARCHAR2 4 YES Faculty Appeal Comment Code.
PERCAPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
Date: 21-JUN-2004 Page: 74
TABLE: PERCAPR
CREATOR: PAYROLL
Faculty Action Approval Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERCAPR_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERCAPR_ACTION VARCHAR2 1 NO Faculty Action.
PERCAPR_ACTION_DATE DATE 7 NO Faculty Action Date.
PERCAPR_ORGN VARCHAR2 6 YES Organization Code.
PERCAPR_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERCAPR_POSN VARCHAR2 6 YES The employees position number.
PERCAPR_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERCAPR_ALVL_CODE VARCHAR2 6 NO Approval Code.
PERCAPR_USER_ID VARCHAR2 30 NO Approval ID.
PERCAPR_FACC_CODE VARCHAR2 4 YES Faculty Approval Comment Code.
PERCAPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
Date: 21-JUN-2004 Page: 75
TABLE: PERCFML
CREATOR: PAYROLL
Family Medical Leave Act Leave Comments Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERCFML_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERCFML_YEAR_IND VARCHAR2 1 NO FMLA YEAR INDICATOR: Indicates type of FMLA year
period.
PERCFML_YEAR VARCHAR2 4 NO FMLA YEAR: Year for current FMLA data being entered.
PERCFML_YEAR_BEGIN DATE 7 NO FMLA YEAR BEGIN: Begin Date for FMLA Year.
PERCFML_YEAR_END DATE 7 NO FMLA YEAR END: End Date for FMLA Year.
PERCFML_BEGIN_DATE DATE 7 NO FMLA BEGIN DATE: Begin Date for FMLA leave.
PERCFML_END_DATE DATE 7 YES FMLA END DATE: End Date for FMLA leave.
PERCFML_COMMENT LONG YES COMMENT: Free form comments.
PERCFML_COMMENT_PIDM NUMBER 8 YES COMMENTER PIDM: Internal ID number.
PERCFML_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the action was initiated.
Date: 21-JUN-2004 Page: 76
TABLE: PERCOMM
CREATOR: PAYROLL
One-Time Payments Job Comments Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERCOMM_PIDM NUMBER 8 NO PIDM: Personal identification code for an individual
tracked in the system.
PERCOMM_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
PERCOMM_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
PERCOMM_COMMENTS VARCHAR2 1300 NO COMMENTS: Comments pertaining to the job record.
PERCOMM_ORIGINAL_USER_ID VARCHAR2 30 NO ORIGINAL USER IDENTIFICATION: User ID of the User who
created the record.
PERCOMM_ORIGINAL_ACTIVITY_DATE DATE 7 NO Date the record was created.
PERCOMM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
PERCOMM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 77
TABLE: PERDADJ
CREATOR: PAYROLL
Employee Defer Pay Adjustment Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDADJ_PIDM NUMBER 8 NO PIDM : Internal Identification Number associated with
a person.
PERDADJ_POSN VARCHAR2 6 NO POSITION NUMBER: Position Number of Job.
PERDADJ_SUFF VARCHAR2 2 NO SUFFIX: Suffix of Job.
PERDADJ_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Effective Date associated with the
job.
PERDADJ_ACCRUALS NUMBER 3 YES ACCRUALS: Number of Defer Pay Accruals for which the
adjusted values for Per Py Salary and Per Pay Defer
Amount Will be used.
PERDADJ_PER_PAY_SALARY NUMBER 11 2 NO ADJUSTED PER PAY SALARY : Adjusted Per Pay salary that
will be used for defer pay.
PERDADJ_PER_PAY_DEFER_AMT NUMBER 11 2 NO ADJUSTED PER PAY DEFER AMOUNT : Adjusted Per Pay Defer
Amount that will be used for defer pay.
PERDADJ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
PERDADJ_SYSTEM_CALC_IND VARCHAR2 1 NO SYSTEM CALCULATED INDICATOR: This field will be set to
'Y' whenever a record is inserted to PERDADJ by
existing functionality (NBPMASS, NBAJOBS, NOAEPAF
(Mass Apply)).
PERDADJ_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user who changed the record.
PERDADJ_COMMENT VARCHAR2 2000 YES COMMENT: This field stores user comments.
Date: 21-JUN-2004 Page: 78
TABLE: PERDAYH
CREATOR: PAYROLL
Time Entry Pay Period Days History Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDAYH_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERDAYH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PERDAYH_TIME_ENTRY_DATE DATE 7 NO TIME ENTRY DATE: Begin date of effective period.
PERDAYH_JOBS_STATUS VARCHAR2 1 YES JOBS STATUS: Status of job as of the time entry date.
PERDAYH_SHCD_CODE VARCHAR2 4 YES TIME ENTRY SHIFT CODE: Shift code that defines a shift
based on time in/out.
PERDAYH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 79
TABLE: PERDAYS
CREATOR: PAYROLL
Time Entry Pay Period Effective Date Breakdown Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDAYS_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERDAYS_TIME_ENTRY_DATE DATE 7 NO TIME ENTRY DATE: Begin date of effective period.
PERDAYS_JOBS_STATUS VARCHAR2 1 YES JOBS STATUS: Status of job as of the time entry date.
PERDAYS_SHCD_CODE VARCHAR2 4 YES TIME ENTRY SHIFT CODE: Shift code that defines a shift
based on time in/out.
PERDAYS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 80
TABLE: PERDEMO
CREATOR: PAYROLL
Table Description: CA MIS Demographic Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDEMO_REPORT_DATE DATE 7 NO REPORT DATE: The current reporting date that the
report was run.
PERDEMO_PIDM NUMBER NO PIDM: Personal indentifcation code for an individual
tracked in the system.
PERDEMO_DICD_CODE VARCHAR2 3 NO DISTRICT/DIVISION CODE: The district or division
associated with an employee.
PERDEMO_TERM_CODE VARCHAR2 3 NO TERM CODE: Term Identifier.
PERDEMO_SSN VARCHAR2 9 NO This field maintains person social security number.
PERDEMO_EMPL_IDENT_STATUS VARCHAR2 1 NO EMPLOYEE IDENTIFIER STATUS
PERDEMO_BIRTH_DATE NUMBER YES Birth Date
PERDEMO_GENDER VARCHAR2 1 YES GENDER:This field maintains the sex of person. Valid
values are: M - Male, F - Female, N - Unknown.
PERDEMO_ETHN_CODE VARCHAR2 2 YES ETHNIC CODE:This field specifies the ethnic group
associated with the ethnic code.
PERDEMO_CITZ_IND VARCHAR2 1 YES Citizenship Indicator
PERDEMO_MEDI_CODE VARCHAR2 1 YES This field identifies the disability type code which
describes the area affected by the handicap.
PERDEMO_EEO6_OCCUP_ACTIVITY VARCHAR2 1 YES EEO6 OCCUPATIONAL ACTIVITY: The EEO Ocupational
Activity as defined by U.S.Federal Goverment, for use
by institutions of higher education, for EEO
reporting.
PERDEMO_EGRP_CODE VARCHAR2 1 YES EMPLOYEE GROUP CODE: An employeeclassification which
is broken down into employee classes.
PERDEMO_EMPLOYMENT_STATUS VARCHAR2 1 YES STATUS OF EMPLOYMENT: Code which indicates the status
of employment.
PERDEMO_EMPLOYMENT_DATE NUMBER YES EMPLOYMENT DATE: Employment Date.
PERDEMO_CONTRACT_DURATION VARCHAR2 1 YES Duration of the contract.
PERDEMO_ANNUAL_SALARY NUMBER YES An Annual Salary.
PERDEMO_ANNUAL_STIPEND NUMBER YES ANNUAL STIPEND:Sum of all stipend earnings paid fiscal
year to date. Value "888888" if no stipends were
received.
PERDEMO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
PERDEMO_REPORT_NO VARCHAR2 5 NO MIS REPORT IDENTIFIER: This field indicates
Demographic Report Identifier.
PERDEMO_REPORT_IND VARCHAR2 1 NO MIS REPORT INDICATOR: This field indicates Demographic
Report Indicator.
PERDEMO_USERID VARCHAR2 30 NO MIS USER ID: This field indicates User ID.
Date: 21-JUN-2004 Page: 81
TABLE: PERDHIS
CREATOR: PAYROLL
Employee Deduction History Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDHIS_PIDM NUMBER 8 NO PIDM : Internal System Identification Number.
PERDHIS_EFFECTIVE_DATE DATE 7 NO DEDUCTION EFFECTIVE DATE: Date from which this record
was effective.
PERDHIS_BDCA_CODE VARCHAR2 3 NO BENEFIT CODE: System defined code for employee
benefit/deduction.
PERDHIS_STATUS VARCHAR2 1 YES DEDUTION STATUS: Status of the benefit/deduction.
Values (A)ctive, (W)aived, (T)erminated.
PERDHIS_ADD_REPL_IND VARCHAR2 1 YES ADD/REPLACE INDICATOR: Values (A)dd to the employee
normal deduction amount or (R)eplace the employee
normal deduction amount.
PERDHIS_ADD_REPL_EMPL NUMBER 11 2 YES ADD/REPLACE EMPLOYEE AMT: The employee amount to
either add to or replace the normal deduction.
PERDHIS_ADD_REPL_EMPR NUMBER 11 2 YES ADD/REPLACE EMPLOYER AMOUNT: The employer amount to
either add to or replace the normal deduction.
PERDHIS_ADD_REPL_TAX_BASE NUMBER 11 2 YES APPLICABLE GROSS: The applicable gross to be used with
the add/replace amount.
PERDHIS_ARR_STATUS VARCHAR2 1 YES ARREARS PROCESSING STATUS: Values (Y)es, arrears for
this deduction will be processed. (N)o arrears for
this deduction will not be processed.
PERDHIS_ARR_BALANCE NUMBER 11 2 YES ARREAR BALANCE: The arrear balance due the employer.
PERDHIS_BEGIN_DATE DATE 7 YES DEDUCTION BEGIN DATE: Date the deduction/benefit
began.
PERDHIS_END_DATE DATE 7 YES DEDUCTION END DATE: Date the deduction/benefit ends.
PERDHIS_REF_NO VARCHAR2 10 YES REFERENCE NUMBER: An optional alphanumeric free form
field.
PERDHIS_AMOUNT1 NUMBER 11 2 YES AMOUNT 1: The first amount field for the
benefit/deduction. The use of this field is
determined by the Calculation Rule assigned to this
deduction.
PERDHIS_AMOUNT2 NUMBER 11 2 YES AMOUNT 2: The second amount field for the
benefit/deduction. The use of this field is
determined by the Calculation Rule assigned to this
deduction.
PERDHIS_AMOUNT3 NUMBER 11 2 YES AMOUNT 3: The third amount field for the
benefit/deduction. The use of this field is
determined by the Calculation Rule assigned to this
deduction.
PERDHIS_AMOUNT4 NUMBER 11 2 YES AMOUNT 4: The fourth amount field for the
benefit/deduction. The use of this field is
determined by the Calculation Rule assigned to this
deduction.
PERDHIS_OPT_CODE1 VARCHAR2 2 YES OPTION CODE 1: The first option code for the benefit
code/deduction. The use of this field is determined
by the calculation rule assigned to the
benefit/deduction code.
PERDHIS_OPT_CODE2 VARCHAR2 2 YES OPTION CODE 2: The second option code for the benefit
code/deduction. The use of this field is determined
by the calculation rule assigned to the
benefit/deduction code.
Date: 21-JUN-2004 Page: 82
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDHIS_OPT_CODE3 VARCHAR2 2 YES OPTION CODE 3: The third option code for the benefit
code/deduction. The use of this field is determined
by the calculation rule assigned to the
benefit/deduction code.
PERDHIS_OPT_CODE4 VARCHAR2 2 YES OPTION CODE 4: The 4th option code for the benefit
code/deduction. The use of this field is determined
by the calculation rule assigned to the
benefit/deduction code.
PERDHIS_OPT_CODE5 VARCHAR2 2 YES OPTION CODE 5: The fifth option code for the benefit
code/deduction. The use of this field is determined
by the calculation rule assigned to the
benefit/deduction code.
PERDHIS_CALC_INS_SALA NUMBER 11 2 YES CALCULATED INSURANCE SALARY: The salary calculated in
the Life Insurance Calculation Process(pdplife) to
determine the employee life insurance coverage.
PERDHIS_USER_ID VARCHAR2 30 NO USER ID: ORACLE Id of the User whose modifications
resulted in the creation of this deduction history
record.
PERDHIS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERDHIS_ARR_RECOVER_MAX NUMBER 11 2 YES MAXIMUM ARREARS RECOVERY: The maximum amount of
arrears allowed to be recovered in a pay event.
PERDHIS_DELETED_IND VARCHAR2 1 NO DELETED INDICATOR: Indicates if the Benefits/Deduction
record has been deleted.
PERDHIS_CAPTURE_DATE DATE 7 NO CAPTURE DATE: The date of the budget transaction.
PERDHIS_OPEN_ENROLL_IND VARCHAR2 1 NO OPEN ENROLLMENT IND: This indicates if a record was
created from Open Enrollment through the Web. These
records will not be displayed in PDADEDN
PERDHIS_ADD_REPL_PICT_CODE VARCHAR2 2 YES The Payroll ID where this benefit/deduction override
should be applied.
Date: 21-JUN-2004 Page: 83
TABLE: PERDIRD
CREATOR: PAYROLL
Employee Direct Deposit Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDIRD_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERDIRD_BANK_CODE VARCHAR2 9 YES BANK CODE: The code of the bank to which the direct
deposit is to be sent.
PERDIRD_BANK_ACCT_NO VARCHAR2 17 YES BANK ACCOUNT NUMBER: The bank account number for the
direct deposit.
PERDIRD_PRIORITY NUMBER 2 NO PRIORITY: The priority in which the direct deposits
are to be distributed.
PERDIRD_AMOUNT NUMBER 11 2 YES DIRECT DEPOSIT AMOUNT: The amount of the direct
deposit.
PERDIRD_PERCENT NUMBER 5 2 YES PERCENT: The percent of net to be direct deposited.
PERDIRD_ACCT_TYPE VARCHAR2 1 YES DIRECT DEPOSIT ACCOUNT TYPE: The type of account for
direct deposit (savings or checking)
PERDIRD_STATUS VARCHAR2 1 NO STATUS: The status of the
direct deposit (live check,
or pre-notification, or inactive)
PERDIRD_DOC_TYPE VARCHAR2 1 NO DOCUMENT TYPE: The type of document (check or direct
deposit)
PERDIRD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 84
TABLE: PERDTOT
CREATOR: PAYROLL
Employee Monthly Benefit / Deduction Totals Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERDTOT_PIDM NUMBER 8 NO Person Identification Number for this record.
PERDTOT_YEAR NUMBER 4 NO Payroll Deduction Year; calendar year in which the
payroll deduction took place for this record.
PERDTOT_BDCA_CODE VARCHAR2 3 NO Benefit/Deduction Code that defines the deduction of
pay.
PERDTOT_MONTH NUMBER 2 NO Calendar month in which the payroll deduction took
place.
PERDTOT_EMPL_AMT NUMBER 11 2 YES Employee contribution amount toward the deduction.
PERDTOT_EMPR_AMT NUMBER 11 2 YES Employer contribution amount toward the deduction.
PERDTOT_APPL_GRS NUMBER 11 2 YES Total Gross Conpensation toward which deduction is
applicable.
PERDTOT_ACTIVITY_DATE DATE 7 NO Last insert or update of this record.
PERDTOT_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
Date: 21-JUN-2004 Page: 85
TABLE: PEREACC
CREATOR: PAYROLL
Employee Accommodation Tracking Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREACC_PIDM NUMBER 8 NO PIDM: Internal Person ID Number.
PEREACC_POSN VARCHAR2 6 NO POSITION: Position code associated with the job
assignment.
PEREACC_SUFF VARCHAR2 2 NO SUFFIX: The suffix associated with the position.
PEREACC_REQUEST_DATE DATE 7 NO REQUEST_DATE: It is the date the information was
initiated on behalf of the staff member by the
department to provide the accommodation.
PEREACC_RQST_CODE VARCHAR2 4 NO RQST_CODE: Request Status is the status of the request
and indicates whether accommodation will be provided
or not.
PEREACC_MEDI_CODE VARCHAR2 2 NO MEDICAL_CODE: Med Code is associated with the persons
medical condition/physical impairment.
PEREACC_VERIFY_IND VARCHAR2 1 NO VERIFY_IND: An indicator to determine whether medical
verification has been received.
PEREACC_MDEQ_CODE VARCHAR2 3 NO EQUIPMENT_CODE: Indicates which equipment is necessary
to respond to the medical conditions identified on
this table.
PEREACC_USER_ID VARCHAR2 30 NO USER ID: User ID of the User who created or last
updated the record.
PEREACC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the record was created or last
updated.
PEREACC_ACST_CODE VARCHAR2 4 YES ACST_CODE: It is the status of the accommodation for
this job, example is Active.
PEREACC_DISA_CODE VARCHAR2 2 YES DISA_CODE: The codes utilized here identify the nature
of a disability.
PEREACC_BEGIN_DATE DATE 7 YES BEGIN_DATE: The beginning date the institution
provided the accommodation to the staff member.
PEREACC_END_DATE DATE 7 YES END_DATE: The end date of the accommodation.
PEREACC_COMMENT VARCHAR2 2000 YES COMMENTS: Comments for the accommodation.
Date: 21-JUN-2004 Page: 86
TABLE: PEREARH
CREATOR: PAYROLL
Time Entry Earnings History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREARH_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PEREARH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PEREARH_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code.
PEREARH_SHIFT VARCHAR2 1 NO SHIFT: Shift associated with earnings.
PEREARH_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for earnings.
PEREARH_DEFAULT_HRS NUMBER 6 2 YES DEFAULT HOURS: Number of hours defaulted during
initial time extract.
PEREARH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 87
TABLE: PEREARI
CREATOR: PAYROLL
One-Time Payments Earn Code Information Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREARI_PIDM NUMBER 8 NO PIDM: Personal identification code for an individual
tracked in the system.
PEREARI_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
PEREARI_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
PEREARI_EARN_CODE VARCHAR2 3 NO EARN CODE: A code used to identify an earnings type.
PEREARI_HRS NUMBER 6 2 NO HOURS: Number of hours associated with the Earning
Code.
PEREARI_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
PEREARI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
PEREARI_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: Contains rate if special rate is
required for the earnings code as defined on the
PTREARN rule form.
Date: 21-JUN-2004 Page: 88
TABLE: PEREARN
CREATOR: PAYROLL
Time Entry Earnings Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREARN_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PEREARN_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings Code.
PEREARN_SHIFT VARCHAR2 1 NO SHIFT: Shift associated with earnings.
PEREARN_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for earnings.
PEREARN_DEFAULT_HRS NUMBER 6 2 YES DEFAULT HOURS: Number of hours defaulted during
initial time extract.
PEREARN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 89
TABLE: PEREEO1
CREATOR: PAYROLL
Required Fields Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREEO1_EMPR_CODE VARCHAR2 4 NO Employer Code: The Employer Identification Code.
PEREEO1_INST_NAME VARCHAR2 29 NO Name of Institution as printed on the EEO Report.
PEREEO1_ADDRESS VARCHAR2 34 NO First Line of the Institution's Address.
PEREEO1_CITY VARCHAR2 20 NO Name of the City (part of Institution's Address).
PEREEO1_CNTY_CODE VARCHAR2 5 NO County Code (part of Institution's Address).
PEREEO1_STAT_CODE VARCHAR2 3 NO State Code: (part of Institution's Address).
PEREEO1_ZIPC_CODE VARCHAR2 10 NO Zip Code (part of Institution's Address).
PEREEO1_CO_NO VARCHAR2 8 NO EEO COMPANY NUMBER: EEOC assigned unique
identification number for the company
PEREEO1_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of Last Modification of the
record.
Date: 21-JUN-2004 Page: 90
TABLE: PEREEO4
CREATOR: PAYROLL
Required Fields Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREEO4_EMPR_CODE VARCHAR2 4 NO Employer Code: The Employer Identification Code.
PEREEO4_INST_NAME VARCHAR2 30 YES Name of Institution as printed on the EEO Report.
PEREEO4_ADDRESS VARCHAR2 30 YES First Line of the Institution's Address.
PEREEO4_CITY VARCHAR2 20 YES Name of the City (part of Institution's Address).
PEREEO4_STAT_CODE VARCHAR2 3 YES State Code: (part of Institution's Address).
PEREEO4_CNTY_CODE VARCHAR2 5 YES County Code (part of Institution's Address).
PEREEO4_ZIPC_CODE VARCHAR2 10 YES Zip Code (part of Institution's Address).
PEREEO4_CONTROL_NO VARCHAR2 8 YES Control Number for the EEO Report.
PEREEO4_AUTH_OFFICIAL VARCHAR2 30 YES Authorized Official's Name.
PEREEO4_AUTH_TITLE VARCHAR2 30 YES Authorized Official's Title.
PEREEO4_NAME VARCHAR2 30 YES Name of Official Certifying the EEO Report.
PEREEO4_TITLE VARCHAR2 30 YES Title of Certifying Official.
PEREEO4_PHONE_NO VARCHAR2 12 YES Phone Number of the Certifying Official.
PEREEO4_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of Last Modification of the
record.
Date: 21-JUN-2004 Page: 91
TABLE: PEREEO5
CREATOR: PAYROLL
Required Fields Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREEO5_EMPR_CODE VARCHAR2 4 NO Employer Code: The Employer Identification Code.
PEREEO5_INST_NAME VARCHAR2 30 NO Name of Institution as printed on the EEO Report.
PEREEO5_ADDRESS VARCHAR2 30 NO First Line of the Institution's Address.
PEREEO5_CITY VARCHAR2 20 NO Name of the City (part of Institution's Address).
PEREEO5_STAT_CODE VARCHAR2 3 NO State Code: (part of Institution's Address).
PEREEO5_CNTY_CODE VARCHAR2 5 NO County Code (part of Institution's Address).
PEREEO5_ZIPC_CODE VARCHAR2 10 NO Zip Code (part of Institution's Address).
PEREEO5_NAME VARCHAR2 30 NO Name of Official Certifying the EEO Report.
PEREEO5_TITLE VARCHAR2 30 NO Title of Certifying Official.
PEREEO5_PHONE_NO VARCHAR2 12 NO Phone Number of the Certifying Official.
PEREEO5_DIST_OE_NO VARCHAR2 7 NO DISTRICT OE NUMBER: School District's OE number
assigned by the Department of Education.
PEREEO5_PAY_END_DATE DATE 7 NO PAY PERIOD END DATE : Pay Period End Date for
statistics on the District EEO Report.
PEREEO5_AGENCY_TYPE VARCHAR2 30 NO AGENCY TYPE: Type of Agency that operates the school
system.
PEREEO5_AWTHELD_IND VARCHAR2 1 NO Authority Witheld Ind; Values (Y)es, Withold Authority
To Publish Statistics or (N)o, Dont Withold Authority.
PEREEO5_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of Last Modification of the
record.
Date: 21-JUN-2004 Page: 92
TABLE: PEREEO6
CREATOR: PAYROLL
Required Fields Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREEO6_EMPR_CODE VARCHAR2 4 NO Employer Code: The Employer Identification Code.
PEREEO6_INST_NAME VARCHAR2 30 YES INSTITUTION NAME: Name of Institution as printed on
the EEO Report.
PEREEO6_ADDRESS VARCHAR2 25 YES INSTITUTION ADDRESS: First Line of the Institution's
Address.
PEREEO6_CITY VARCHAR2 25 YES CITY: Name of the City (part of Institution's
Address).
PEREEO6_STAT_CODE VARCHAR2 3 YES STATE CODE: (part of institution's address).
PEREEO6_CNTY_CODE VARCHAR2 5 YES County Code (part of Institution's Address).
PEREEO6_ZIPC_CODE VARCHAR2 10 YES ZIP CODE (part of Institution's Address).
PEREEO6_CONTROL_NO VARCHAR2 8 YES Control Number for the EEO Report.
PEREEO6_FICE_CD NUMBER 6 YES EEO FICE CODE: 6-digit numeric code assigned by the
Department of Education.
PEREEO6_SYSTEM_CD NUMBER 6 YES EEO SYSTEM CODE: EEOC assigned code to link all
campuses in a multicampus Installation.
PEREEO6_PARENT_INST VARCHAR2 25 YES EEO Parent Institution.
PEREEO6_RPT_COVERS_IND NUMBER 1 YES EEO REPORT COVERS INDICATOR: EEO Report Covers
Indicator; Specifies the kind of Installation the
report covers. Values are 1 = Single Campus; 2 = Main
Campus; 3 = Branch Campus; 4 = MultiCampus; 5 =
Institutional System; Null = Other.
PEREEO6_NAME VARCHAR2 30 YES NAME OF OFFICIAL CERTIFYING THE EEO REPORT.
PEREEO6_TITLE VARCHAR2 30 YES TITLE OF CERTIFYING OFFICIAL.
PEREEO6_PHONE_NO VARCHAR2 12 YES PHONE NUMBER OF THE CERTIFYING OFFICIAL.
PEREEO6_FED_CONTR_IND VARCHAR2 1 YES FEDERAL CONTRACTS INDICATOR: Indicator specifying if
Institution has federal contracts. Values are (Y)es
or (N)o.
PEREEO6_DON_CONTR_IND VARCHAR2 1 YES DONATED SERVICES//CONTRACTS INDICATOR: Indicator
specifying if institution has donated or contracted
services. Values are (Y)es or (N)o.
PEREEO6_STATE_SEQ_NO NUMBER 6 YES STATE SEQUENCE NUMBER: EEOC assigned unique id.
PEREEO6_UNIT_ID NUMBER 6 YES UNIT ID : IPEDS assigned unique id.
PEREEO6_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of Last Modification of the
record.
PEREEO6_SECTOR VARCHAR2 5 YES Sector Number Printed on the Report.
Date: 21-JUN-2004 Page: 93
TABLE: PEREEOT
CREATOR: PAYROLL
Magnetic Tape Reporting Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREEOT_LINENO NUMBER 4 NO LINE NUMBER: The line number of the report.
PEREEOT_TITLE VARCHAR2 30 YES CATEGORY TITLE;
PEREEOT_LINE_TOTAL_CNT NUMBER 6 YES TOTAL CATEGORY COUNT;
PEREEOT_LINE_MALE_CNT NUMBER 6 YES TOTAL MALE COUNT;
PEREEOT_LINE_M1_CNT NUMBER 5 YES MALE CATEGORY 1 COUNT;
PEREEOT_LINE_M2_CNT NUMBER 5 YES MALE CATEGORY 2 COUNT;
PEREEOT_LINE_M3_CNT NUMBER 5 YES MALE CATEGORY 3 COUNT;
PEREEOT_LINE_M4_CNT NUMBER 5 YES MALE CATEGORY 4 COUNT;
PEREEOT_LINE_M5_CNT NUMBER 5 YES MALE CATEGORY 5 COUNT;
PEREEOT_LINE_FEMALE_CNT NUMBER 6 YES TOTAL FEMALE COUNT;
PEREEOT_LINE_F1_CNT NUMBER 5 YES FEMALE CATEGORY 1 COUNT:
PEREEOT_LINE_F2_CNT NUMBER 5 YES FEMALE CATEGORY 2 COUNT;
PEREEOT_LINE_F3_CNT NUMBER 5 YES FEMALE CATEGORY 3 COUNT:
PEREEOT_LINE_F4_CNT NUMBER 5 YES FEMALE CATEGORY 4 COUNT.
PEREEOT_LINE_F5_CNT NUMBER 5 YES FEMALE CATEGORY 5 COUNT;
PEREEOT_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PEREEOT_EFUN_CODE VARCHAR2 2 YES EEO FUNCTION CODE;
PEREEOT_YEAR NUMBER 4 YES EEO REPORTING YEAR.
PEREEOT_TYPE_OF_REPORT_IND VARCHAR2 1 YES EEO-1 REPORT TYPE INDICATOR : values 1 - Single
Establishment, 2 - Consolidated Report, 3 -
Headquarters Unit Report, 4 - Individual establishment
Report, 5 - Special Report.
PEREEOT_SCHL_CODE VARCHAR2 6 YES SCHOOL CODE: School for which the data is being filed.
PEREEOT_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location for which the data is being
filed.
PEREEOT_EMPR_CODE VARCHAR2 4 YES EMPLOYER CODE: Employer for whom the data is being
filed.
PEREEOT_LINE_M6_CNT NUMBER 5 YES Number of Males in the Race/Ethnicity Unknown
Category.
PEREEOT_LINE_F6_CNT NUMBER 5 YES Number of Females in the Race/Ethnicity Unknown
Category.
PEREEOT_LINE_M0_CNT NUMBER 5 YES Number of Females in the Non-Resident Alien Category.
PEREEOT_LINE_F0_CNT NUMBER 5 YES Number of Females in the Non-Resident Alien Category.
Date: 21-JUN-2004 Page: 94
TABLE: PEREFML
CREATOR: PAYROLL
Employee FMLA Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREFML_PIDM NUMBER 8 NO PIDM: Internal ID number.
PEREFML_YEAR_IND VARCHAR2 1 NO FMLA YEAR INDICATOR: Indicates type of FMLA year
period.
PEREFML_YEAR VARCHAR2 4 NO FMLA YEAR: Year for current FMLA data being entered.
PEREFML_YEAR_BEGIN DATE 7 NO FMLA YEAR BEGIN: Begin Date for FMLA Year.
PEREFML_YEAR_END DATE 7 NO FMLA YEAR END: End Date for FMLA Year.
PEREFML_BEGIN_DATE DATE 7 NO FMLA BEGIN DATE: Begin Date for FMLA leave.
PEREFML_END_DATE DATE 7 YES FMLA END DATE: End Date for FMLA leave.
PEREFML_EARN_CODE VARCHAR2 3 NO FMLA Earnings Code: Earnings Code associated with the
FMLA Leave.
PEREFML_EARN_BEGIN_DATE DATE 7 NO FMLA EARN BEGIN DATE: Begin Date for FMLA leave
claimed.
PEREFML_EARN_END_DATE DATE 7 YES FMLA EARN END DATE: End Date for FMLA leave claimed
PEREFML_CLAIM_UNITS NUMBER 6 2 NO FMLA CLAIM UNITS: FMLA Units Claimed by employee.
PEREFML_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the action was initiated.
Date: 21-JUN-2004 Page: 95
TABLE: PEREHIS
CREATOR: PAYROLL
Employee History Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PEREHIS_PIDM NUMBER 8 NO PIDM: Internal ID number.
PEREHIS_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The effective date of the action that
caused this record to beadded to history.
PEREHIS_EMPL_STATUS VARCHAR2 1 YES EMPLOYMENT STATUS: The status of the employee within
the institution.
PEREHIS_HOME_ORGN VARCHAR2 6 YES HOME ORGANIZATION: The home or reporting organization
of the employee. This must be defined as a valid
organization via the PTVORGN or FTMORGN tables.
PEREHIS_ECLS_CODE VARCHAR2 2 YES EMPLOYEE CLASS: The employee classification that this
employee belonged to. This must exist on the PTRECLS
rule form.
PEREHIS_LCAT_CODE VARCHAR2 2 YES LEAVE CATEGORY: The leave category code that defines
this employees leave accrual rules and eligibilities.
These codes must be established on PTRLCAT rule form.
PEREHIS_BCAT_CODE VARCHAR2 2 YES BENEFIT CATEGORY CODE: The benefit/deduction
eligibility category. This must be defined on the
PTRBCAT rule form.
PEREHIS_CURRENT_HIRE_DATE DATE 7 YES CURRENT HIRE DATE: Most recent employement date.
PEREHIS_ADJ_SERVICE_DATE DATE 7 YES ADJUSTED SERVICE DATE;
PEREHIS_LREA_CODE VARCHAR2 2 YES LEAVE OF ABSENCE REASON CODE: Specifies the reason
that the employee is on leave. These codes are
established on the PTRLREA rule form.
PEREHIS_TREA_CODE VARCHAR2 2 YES TERMINATION REASON CODE: Specifies the reason that an
employee was terminated.These codes are established on
the PTRTREA rule form.
PEREHIS_USER_ID VARCHAR2 30 NO USER ID: User who made the change to the employees
record to cause this recordto be generated.
PEREHIS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PEREHIS_TERM_DATE DATE 7 YES Termination Date: Termination date of the employee.
PEREHIS_LOA_BEG_DATE DATE 7 YES Leave of Absence Begin Date: The begin date of a leave
of absence for the employee.
PEREHIS_LOA_END_DATE DATE 7 YES Leave of Absence End Date: The anticipated end date
for an employees leave of absence.
Date: 21-JUN-2004 Page: 96
TABLE: PERELBD
CREATOR: PAYROLL
Time Entry Labor Distribution Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERELBD_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERELBD_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code associated with this set of
labor distributions.
PERELBD_SHIFT VARCHAR2 1 NO SHIFT CODE: The shift associated with the earnings.
PERELBD_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for earnings.
PERELBD_TIME_ENTRY_DATE DATE 7 NO
PERELBD_SEQNO NUMBER 3 NO LABOR DISTRIBUTION SEQUENCE NUMBER: Internal sequence
number.
PERELBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Chart of accounts code as
defined on the BANNER Finance system.
PERELBD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE; Index defined in the BANNER
Finance system.
PERELBD_FUND_CODE VARCHAR2 6 YES FUND CODE: The Fund Code as defined in the BANNER
Finance system.
PERELBD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Code as defined in the BANNER
Finance system.
PERELBD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Account Code as defined in the BANNER
Finance system.
PERELBD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Program Code as defined in the BANNER
Finance system.
PERELBD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Activity Code as defined on the BANNER
Finance system.
PERELBD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location Code as defined in the BANNER
Finance system.
PERELBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
PERELBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
PERELBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Full account number for use
when interfacing to a finance system other than BANNER
Finance.
PERELBD_HRS NUMBER 6 2 YES Hours : Number of Earnings Hours Associated With the
Labor Distribution.
PERELBD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 97
TABLE: PERELBH
CREATOR: PAYROLL
Time Entry Earnings Labor Distribution Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERELBH_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERELBH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PERELBH_EARN_CODE VARCHAR2 3 NO EARN CODE: The earnings code associated with this set
of labor distributions.
PERELBH_SHIFT VARCHAR2 1 NO SHIFT CODE: The shift associated with the earnings.
PERELBH_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for the earnings.
PERELBH_TIME_ENTRY_DATE DATE 7 NO
PERELBH_SEQNO NUMBER 3 NO LABOR DISTRIBUTION SEQUENCE NUMBER: Internal sequence
number.
PERELBH_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Chart of accounts code as
defined on the BANNER Finance system.
PERELBH_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE; Index defined in the BANNER
Finance system.
PERELBH_FUND_CODE VARCHAR2 6 YES FUND CODE: The Fund Code as defined in the BANNER
Finance system.
PERELBH_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Code as defined in the BANNER
Finance system.
PERELBH_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Account Code as defined in the BANNER
Finance system.
PERELBH_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Program Code as defined in the BANNER
Finance system.
PERELBH_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Activity Code as defined on the BANNER
Finance system.
PERELBH_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location Code as defined in the BANNER
Finance system.
PERELBH_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
PERELBH_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
PERELBH_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Full account number for use
when interfacing to a finance system other than BANNER
Finance.
PERELBH_HRS NUMBER 6 2 YES Hours : Number of earnings hours associated with the
labor distribution.
PERELBH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 98
TABLE: PERETOT
CREATOR: PAYROLL
Employee Monthly Earnings Totals Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERETOT_PIDM NUMBER 8 NO Person Id foreign key.
PERETOT_YEAR NUMBER 4 NO Year key; four numbers.
PERETOT_MONTH NUMBER 2 NO Month key; two numbers.
PERETOT_HRS NUMBER 6 2 YES Total hours worked during the month.
PERETOT_GRS NUMBER 11 2 YES Total gross earnings during the month.
PERETOT_NET NUMBER 11 2 YES Total net earnings during the month.
PERETOT_ACTIVITY_DATE DATE 7 NO Creation or latest update time stamp on this record.
Date: 21-JUN-2004 Page: 99
TABLE: PERFACC
CREATOR: PAYROLL
Faculty Action Comments Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERFACC_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERFACC_ACTION VARCHAR2 1 NO Faculty Action.
PERFACC_ACTION_DATE DATE 7 NO Faculty Action Date.
PERFACC_ORGN VARCHAR2 6 YES Organization Code.
PERFACC_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERFACC_POSN VARCHAR2 6 YES The employees position number.
PERFACC_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERFACC_FACC_CODE VARCHAR2 4 YES Faculty Action Comment Code.
PERFACC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
Date: 21-JUN-2004 Page: 100
TABLE: PERFACL
CREATOR: PAYROLL
Position Control Faculty Load Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERFACL_PIDM NUMBER 8 YES PIDM: Internal system ID number.
PERFACL_POSN VARCHAR2 6 YES POSN: The position held by this employee.
PERFACL_SUFF VARCHAR2 2 YES Suffix.
PERFACL_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The date on which this change becomes
effective.
PERFACL_FTE NUMBER 5 2 YES FTE: The percentage of full time load associated with
this change.
PERFACL_CONTACT_HOURS NUMBER 5 2 YES CONTACT HOURS: Faculty contact hours are used to
calculate hourly instructor salaries.
PERFACL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or updated
Date: 21-JUN-2004 Page: 101
TABLE: PERFAPL
CREATOR: PAYROLL
Faculty Appeal Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERFAPL_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERFAPL_ACTION VARCHAR2 1 NO Faculty Action.
PERFAPL_ACTION_DATE DATE 7 NO Faculty Action Date.
PERFAPL_ORGN VARCHAR2 6 YES Organization Code.
PERFAPL_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERFAPL_POSN VARCHAR2 6 YES The employees position number.
PERFAPL_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERFAPL_ALVL_CODE VARCHAR2 6 NO Approval Code.
PERFAPL_USER_ID VARCHAR2 30 NO Reviewer ID.
PERFAPL_LAST_LEVEL_IND VARCHAR2 1 YES Appeal Last Level Indicator.
PERFAPL_APPR_DECISION VARCHAR2 1 YES Appeal Decision.
PERFAPL_APPR_DATE DATE 7 YES Appeal Decision Date.
PERFAPL_DEFERRAL_DATE DATE 7 YES Deferral Date.
PERFAPL_COMMENT LONG YES Appeal Comments.
PERFAPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
Date: 21-JUN-2004 Page: 102
TABLE: PERFAPR
CREATOR: PAYROLL
Faculty Approval Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERFAPR_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERFAPR_ACTION VARCHAR2 1 NO Faculty Action.
PERFAPR_ACTION_DATE DATE 7 NO Faculty Action Date.
PERFAPR_ORGN VARCHAR2 6 YES Organization Code.
PERFAPR_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERFAPR_POSN VARCHAR2 6 YES The employees position number.
PERFAPR_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERFAPR_ALVL_CODE VARCHAR2 6 NO Approval Code.
PERFAPR_USER_ID VARCHAR2 30 NO Approval ID.
PERFAPR_LAST_LEVEL_IND VARCHAR2 1 YES Approval Last Level Indicator.
PERFAPR_APPR_DECISION VARCHAR2 1 YES Approval Decision.
PERFAPR_APPR_DATE DATE 7 YES Approval Decision Date.
PERFAPR_DEFERRAL_DATE DATE 7 YES Approval Deferral Date.
PERFAPR_COMMENT LONG YES Approval Comments.
PERFAPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
Date: 21-JUN-2004 Page: 103
TABLE: PERFMLA
CREATOR: PAYROLL
Family Medical Leave Act Usage Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERFMLA_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERFMLA_YEAR_IND VARCHAR2 1 NO FMLA YEAR INDICATOR: Indicates type of FMLA year
period.
PERFMLA_YEAR VARCHAR2 4 NO FMLA YEAR: Year for current FMLA data being entered.
PERFMLA_YEAR_BEGIN DATE 7 NO FMLA YEAR BEGIN: Begin Date for FMLA Year.
PERFMLA_YEAR_END DATE 7 NO FMLA YEAR END: End Date for FMLA Year.
PERFMLA_BEGIN_DATE DATE 7 NO FMLA BEGIN DATE: Begin Date for FMLA leave.
PERFMLA_END_DATE DATE 7 YES FMLA END DATE: End Date for FMLA leave.
PERFMLA_STATUS VARCHAR2 2 NO FMLA STATUS: Status of FMLA.
PERFMLA_STATUS_DATE DATE 7 NO FMLA STATUS DATE: Date of status of FMLA.
PERFMLA_REQUEST_DATE DATE 7 NO FMLA REQUEST DATE: Date FMLA leave requested.
PERFMLA_ELIGIBLE_DATE DATE 7 YES FMLA ELIGIBLE DATE: Date of eligiblity notifications.
PERFMLA_APPROVAL_DATE DATE 7 YES FMLA APPROVAL DATE: Date of approval.
PERFMLA_APPROVE_PIDM NUMBER 8 YES APPROVAL PIDM: Internal ID number.
PERFMLA_FREA_CODE VARCHAR2 2 NO FMLA REASON CODE: FMLA Leave Reason code.
PERFMLA_BENEFIT_IND VARCHAR2 1 NO ELIGIBLE BENEFIT IND: FMLA eligible benefits
indicator.
PERFMLA_MED_CERT_IND VARCHAR2 1 NO MEDICAL CERTIFICATION RECEIVED: Medical certification
received indicator.
PERFMLA_MED_RECEIVED_DATE DATE 7 YES MEDICAL CERTIFICATION RECEIVED DATE: Date medical
certification received.
PERFMLA_FT_PT_STATUS VARCHAR2 2 YES FT/PT STATUS: Scheduled FT/PT status.
PERFMLA_SCHEDULE_RETURN_DATE DATE 7 YES RETURN DATE: Scheduled date of return.
PERFMLA_RETURN_FT_PT_STATUS VARCHAR2 2 YES FT/PT STATUS: Actual FT/PT status.
PERFMLA_ACTUAL_RETURN_DATE DATE 7 YES ACTUAL RETURN DATE: Actual date of return.
PERFMLA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the action was initiated.
Date: 21-JUN-2004 Page: 104
TABLE: PERGRDS
CREATOR: PAYROLL
Grievance Description Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERGRDS_GREV_NO NUMBER 8 NO Grievance Number: Identification number of the
grievance for this record.
PERGRDS_TEXT LONG YES Text: Free form text description of the grievance.
PERGRDS_ACTIVITY_DATE DATE 7 NO Activity Date: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 105
TABLE: PERGRPA
CREATOR: PAYROLL
Grievance Participants Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERGRPA_GREV_NO NUMBER 8 NO GREVIANCE NUMBER: Identification number of the
grievance this record
is associated with.
PERGRPA_PIDM NUMBER 8 NO PIDM: Identification number associated with a person.
PERGRPA_GRPT_CODE VARCHAR2 4 NO GRPT CODE: Participant Type Code associated with this
person.
PERGRPA_POSN VARCHAR2 6 YES POSITION: The person's position associated with the
grievance.
PERGRPA_SUFF VARCHAR2 2 YES SUFFIX: Suffix associated with the position.
PERGRPA_GRIEVANT_IND VARCHAR2 1 YES GRIEVANT INDICATOR: Indicates whether this person is
the grievant.
PERGRPA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 106
TABLE: PERGRRA
CREATOR: PAYROLL
Grievance Resulting Actions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERGRRA_GREV_NO NUMBER 8 NO GRIEVANCE NUMBER: Identification number of the
grievance this record
is associated with.
PERGRRA_GRSR_CODE VARCHAR2 4 NO GRSR CODE: Grievance Standard Result Code associated
with the grievance.
PERGRRA_GRSR_DATE DATE 7 NO GRSR DATE: Date on which the result occurred.
PERGRRA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 107
TABLE: PERGRRE
CREATOR: PAYROLL
Grievance Resolution Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERGRRE_GREV_NO NUMBER 8 NO Grievance Number: Identification number of the
grievance for this record.
PERGRRE_TEXT LONG YES Text: Free form text description of the resolution of
the grievance.
PERGRRE_ACTIVITY_DATE DATE 7 NO Activity Date: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 108
TABLE: PERHIRE
CREATOR: PAYROLL
Employee Hire Control Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHIRE_SESSIONID VARCHAR2 30 NO SESSION ID: Unique ORACLE defined Session
Identification Number.
PERHIRE_FORM_NAME VARCHAR2 10 NO FORM NAME
PERHIRE_BLOCK_NAME VARCHAR2 30 NO BLOCK NAME
PERHIRE_ITEM_NAME VARCHAR2 30 NO ITEM NAME
PERHIRE_VALUE VARCHAR2 80 YES Parameter value
PERHIRE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
updated.
Date: 21-JUN-2004 Page: 109
TABLE: PERHOUH
CREATOR: PAYROLL
Time Entry Hours Breakdown History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHOUH_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERHOUH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PERHOUH_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code.
PERHOUH_SHIFT VARCHAR2 1 NO SHIFT: Shift associated with earnings.
PERHOUH_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for the earnings.
PERHOUH_TIME_ENTRY_DATE DATE 7 NO TIME ENTRY DATE: Date of the hours breakdown.
PERHOUH_HRS NUMBER 6 2 YES HOURS: Number of hours associated with the earnings.
PERHOUH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 110
TABLE: PERHOUR
CREATOR: PAYROLL
Time Entry Hours Breakdown Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHOUR_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERHOUR_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code.
PERHOUR_SHIFT VARCHAR2 1 NO SHIFT: Shift associated with Earning Code.
PERHOUR_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for the earnings.
PERHOUR_TIME_ENTRY_DATE DATE 7 NO TIME ENTRY DATE: Date of the hours breakdown.
PERHOUR_HRS NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PERHOUR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 111
TABLE: PERHSCT
CREATOR: PAYROLL
Health and Safety Incident Costs Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSCT_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record
is associated with.
PERHSCT_PIDM NUMBER 8 NO PIDM: Identification number associated with a person.
PERHSCT_HSCR_CODE VARCHAR2 4 NO HSCR CODE: Cost Reason Code associated with this
person.
PERHSCT_COST NUMBER 12 2 NO COST: Dollar amount spent for this cost reason code
regarding this person
and incident.
PERHSCT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 112
TABLE: PERHSFC
CREATOR: PAYROLL
Health and Safety Incident Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSFC_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record is associated with.
PERHSFC_TEXT LONG YES TEXT: Free form text description.
PERHSFC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
updated.
Date: 21-JUN-2004 Page: 113
TABLE: PERHSID
CREATOR: PAYROLL
Incident Comments Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSID_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record is associated with.
PERHSID_TEXT LONG YES TEXT: Free form text description.
PERHSID_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or last
updated.
Date: 21-JUN-2004 Page: 114
TABLE: PERHSIH
CREATOR: PAYROLL
Health and Safety Incident Hazard Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSIH_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record is associated with.
PERHSIH_HAZD_CODE VARCHAR2 4 NO HAZARD CODE: Hazard Code associated with the incident.
PERHSIH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 115
TABLE: PERHSIM
CREATOR: PAYROLL
Health and Safety Incident Medical Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSIM_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record
is associated with.
PERHSIM_PIDM NUMBER 8 NO PIDM: Identification number associated with a person.
PERHSIM_HSME_CODE VARCHAR2 4 NO MEDICAL CODE: Medical Code associated with an illness
or injury.
PERHSIM_BEGIN_DATE DATE 7 NO BEGIN DATE: Date when the injury occurred or the
illness began (or was
diagnosed).
PERHSIM_END_DATE DATE 7 YES END DATE: Date when the injury or illness ceased to
be of consequence.
PERHSIM_PRIMARY_IND VARCHAR2 1 YES PRIMARY INDICATOR: Indicates whether it is the primary
illness or injury.
PERHSIM_HOURS_LOST NUMBER 5 1 YES HOURS LOST: Number of hours lost due to this illness
or injury.
PERHSIM_HOURS_WORK_RESTRICTED NUMBER 5 1 YES HOURS WORK RESTRICTED: Number of hours when the
employee's work is restricted
due to the illness or
injury.
PERHSIM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
PERHSIM_CLASSIFICATION_TYPE VARCHAR2 1 NO Classification: D = Death A = Away days from work J =
Job transfer or restriction O = Other recordable cases
N = None
PERHSIM_INJURY_ILLNESS_TYPE VARCHAR2 1 NO Injury and Illness Type: N = None I = Injuries S =
Skin disorders R = Respiratory conditions P =
Poisonings H = Hearing Loss A = All other illnesses
Date: 21-JUN-2004 Page: 116
TABLE: PERHSIP
CREATOR: PAYROLL
Health and Safety Incident Partys Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSIP_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record is associated with.
PERHSIP_PIDM NUMBER 8 NO PIDM: Identification number associated with a person.
PERHSIP_HSPC_CODE VARCHAR2 4 NO HSPC CODE: Party Classification Code associated with
this person.
PERHSIP_POSN VARCHAR2 6 YES POSITION: Position which the person was in during the
incident.
PERHSIP_SUFF VARCHAR2 2 YES SUFFIX: Suffix associated with the position that the
person was in during the incident.
PERHSIP_DISA_CODE VARCHAR2 6 YES DISABILITY CODE: Indicates if the person is on
disability and if so, what type of disability.
PERHSIP_WORK_COMP_IND VARCHAR2 1 YES WORKERS COMP INDICATOR: Indicates whether the person
received worker's compensation as a result of the
incident.
PERHSIP_OSHA_IND VARCHAR2 1 YES OSHA INDICATOR: Indicates whether the incident is OSHA
reportable for this person.
PERHSIP_LITG_CODE VARCHAR2 1 YES LITIGATION STATUS CODE: Indicates the status of
litigation for this person.
PERHSIP_LITG_DATE DATE 7 YES LITIGATION STATUS DATE: The date the litigation status
was established.
PERHSIP_DEAD_IND VARCHAR2 1 YES DEAD INDICATOR: Indicates if the referenced incident
caused the person to die.
PERHSIP_COMMENT LONG YES COMMENT: Brief comment regarding this person.
PERHSIP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
PERHSIP_OSHA_RPT_DISPLAY_TYPE VARCHAR2 1 NO OSHA Report Display: Determine what is displayed on
report; B = Both Name and Job Title O = Only Name J =
Job Title Only P = Privacy Case
Date: 21-JUN-2004 Page: 117
TABLE: PERHSIT
CREATOR: PAYROLL
Health and Safety Incident Type Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSIT_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record
is associated with.
PERHSIT_HSTC_CODE VARCHAR2 6 NO TYPE CODE: Health and Safety incident type code
associated with the incident.
PERHSIT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 118
TABLE: PERHSRA
CREATOR: PAYROLL
Health and Safety Incident Recommendations and Actions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERHSRA_HSIN_NO NUMBER 8 NO INCIDENT NUMBER: Identification number of the incident
this record is associated with.
PERHSRA_TEXT VARCHAR2 50 NO TEXT: Text associated with this recommendation or
action.
PERHSRA_SEQ_NO NUMBER 4 NO SEQUENCE NUMBER: Sequence number associated with this
record.
PERHSRA_RSTA_CODE VARCHAR2 1 NO STATUS: Status code of the recommendation or action.
PERHSRA_RSTA_DATE DATE 7 NO STATUS DATE: Date when the status was established.
PERHSRA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 119
TABLE: PERINDV
CREATOR: PAYROLL
Individual Information Upload Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERINDV_PIDM NUMBER 8 NO PIDM: Internal identification number of the person.
PERINDV_ID VARCHAR2 9 NO ID: This field defines the identification number used
to access person on-line.
PERINDV_SSN VARCHAR2 9 YES SSN: Social Security Number.
PERINDV_LAST_NAME VARCHAR2 60 YES LAST NAME: This field defines the last name of person.
PERINDV_FIRST_NAME VARCHAR2 15 YES FIRST NAME: This field identifies the first name of
person.
PERINDV_MI VARCHAR2 15 YES MIDDLE NAME: This field identifies the middle name of
person.
PERINDV_BIRTH_DATE DATE 7 YES BIRTH DATE: Date of Birth.
PERINDV_TITLE VARCHAR2 20 YES TITLE This field maintains the prefix (Mr, Mrs, etc)
used before person name.
PERINDV_SUFFIX VARCHAR2 20 YES SUFFIX: This field maintains the suffix (Jr, Sr, etc)
used after person name.
PERINDV_US_STREET_LINE1 VARCHAR2 30 YES US_STREET_LINE1: This field maintains the first line
of the address associated with person.
PERINDV_US_STREET_LINE2 VARCHAR2 30 YES US_STREET_LINE2: This field maintains the second line
of the address associated with person.
PERINDV_US_STREET_LINE3 VARCHAR2 30 YES US_STREET_LINE3: This field maintains the third line
of the address associated with person.
PERINDV_US_CITY VARCHAR2 20 YES US_CITY: This field maintains the city associated with
the address of person.
PERINDV_US_STATE VARCHAR2 2 YES US_STATE: This field maintains the state associated
with the address of person.
PERINDV_US_ZIP VARCHAR2 10 YES US_ZIP: This field maintains the zip code associated
with the address of person.
PERINDV_FR_STREET_LINE1 VARCHAR2 30 YES FR_STREET_LINE1: This field maintains the first line
of the foreign address associated with person.
PERINDV_FR_STREET_LINE2 VARCHAR2 30 YES FR_STREET_LINE2: This field maintains the second line
of the foreign address associated with person.
PERINDV_FR_STREET_LINE3 VARCHAR2 30 YES FR_STREET_LINE3: This field maintains the third line
of the foreign address associated with person.
PERINDV_FR_CITY VARCHAR2 20 YES FR_CITY: This field maintains the city associated with
the address of person.
PERINDV_FR_STATE VARCHAR2 2 YES FR_STATE: This field maintains the foreign state
associated with the address of person.
PERINDV_FR_ZIP VARCHAR2 10 YES FR_ZIP: This field maintains the foreign zip code
associated with the address of person.
PERINDV_FR_COUNTRY_CODE VARCHAR2 2 YES FR_COUNTRY_CODE: This field maintains the
nation/country associated with the address of person.
PERINDV_CITZ_COUNTRY_CODE VARCHAR2 2 YES CITZ_COUNTRY_CODE: This field maintains the
citizenship nation/country associated with the person.
PERINDV_TAX_RES_COUNTRY_CODE VARCHAR2 2 YES TAX_RES_COUNTRY_CODE: This field maintains the Tax
Residency nation/country associated with the person.
Date: 21-JUN-2004 Page: 120
TABLE: PERJACT
CREATOR: PAYROLL
Employee Job Activity Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJACT_PIDM NUMBER 8 NO PIDM: Persons internal unique ID number.
PERJACT_POSN VARCHAR2 6 NO POSITION NUMBER: Defines an employees position.
PERJACT_SUFF VARCHAR2 2 NO POSITION SUFFIX: Used with Position Number to make-up
an employees Job ID
PERJACT_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The date on which a job becomes
effective
PERJACT_DICD_CODE VARCHAR2 3 NO DISTRICT/DIVISION CODE: The district or division
associated with an employee.
PERJACT_JACT_CODE VARCHAR2 4 NO JOB ACTIVITY CODE: Identifies the activity or category
of an employees assignment.
PERJACT_ASTY_CODE VARCHAR2 4 NO ASSIGNMENT TYPE: A code which identifies the type of
assignment.
PERJACT_STD_HRS_PER_PAY NUMBER 6 2 NO STANDARD HOURS PER PAY: Standard number of hours in a
pay period.
PERJACT_PERCENT NUMBER 5 2 NO PERCENT: Percentage of the time spent in a
division/activity/type for the job.
PERJACT_FTE NUMBER 6 3 NO FTE: The number of FTEs for this employees job.
PERJACT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date this row was updated.
Date: 21-JUN-2004 Page: 121
TABLE: PERJBBG
CREATOR: PAYROLL
Jobs Bargaining Unit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJBBG_PIDM NUMBER 8 NO PIDM: Identification number associated with a person.
PERJBBG_BARG_CODE VARCHAR2 2 NO UNION CODE: Bargaining Unit Code associated with this
person.
PERJBBG_POSN VARCHAR2 6 NO POSITION: Position associated with this person and
bargaining unit.
PERJBBG_SUFF VARCHAR2 2 NO SUFFIX: Suffix associated with this position.
PERJBBG_JOB_SENIORITY_DATE DATE 7 NO JOB SENIORITY DATE: Seniority Date associated with
this position
for this person.
PERJBBG_BARG_EFFECTIVE_DATE DATE 7 NO BARGAINING UNIT EFFECTIVE DATE: Effective Date of the
bargaining unit record
with which this position is
associated.
PERJBBG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 122
TABLE: PERJFAC
CREATOR: PAYROLL
Job Point Factor Assignment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJFAC_POSN VARCHAR2 6 NO POSITION NUMBER: The position associated with this
point factor assignment.
PERJFAC_DATE DATE 7 NO DATE: Date of this point factor assignment.
PERJFAC_CFAC_CODE VARCHAR2 5 NO COMPENSABLE FACTOR CODE: Compensable factor code
associated with this position.
PERJFAC_CFAC_POINT NUMBER 5 NO COMPENSABLE FACTOR POINT: Job factor point for this
position and date.
PERJFAC_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 123
TABLE: PERJHIS
CREATOR: PAYROLL
Assignment History Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJHIS_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERJHIS_POSN VARCHAR2 6 YES POSITION: The employees position number.
PERJHIS_SUFF VARCHAR2 2 YES SUFFIX: A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same postion number.
PERJHIS_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: The date this change became effective.
PERJHIS_STATUS VARCHAR2 1 YES STATUS: The status of the employee in regards to this
assignment.
PERJHIS_ECLS_CODE VARCHAR2 2 YES EMPLOYEE CLASS CODE: The employee class used when
considering payroll rules associated with this
assignment.
PERJHIS_BEGIN_DATE DATE 7 YES BEGIN DATE: Date the job starts.
PERJHIS_END_DATE DATE 7 YES END DATE: Date the assignment ends.
PERJHIS_PAYID VARCHAR2 2 YES PAYROLL IDENTIFICATION CODE: The code used to
determine when to pay this assignment.
PERJHIS_SAL_TABLE VARCHAR2 2 YES SALARY TABLE: The table used to determine the
employees low, mid and max salary. This must be
established on the PTRSALA rule table.
PERJHIS_SAL_GRADE VARCHAR2 5 YES SALARY GRADE: The pay grade associated with the
employee. Grades must be established on the PTRSALA
rule form.
PERJHIS_SAL_STEP NUMBER 3 YES SALARY STEP: The step used to determine the employee
rate of pay. A step of zeros will require pay rates
or salaries to be entered. Steps other than zero must
be established on the PTRSALA rule table.
PERJHIS_HRS_DAY NUMBER 6 2 YES HOURS PER DAY: The average or standard hours worked
per day.
PERJHIS_REG_RATE NUMBER 11 6 YES REGULAR RATE: The employees hourly rate of pay.
PERJHIS_ASSGN_SALARY NUMBER 11 2 YES ASSIGNMENT SALARY: Per pay period salary.
PERJHIS_ANN_SALARY NUMBER 11 2 YES ANNUAL SALARY;
PERJHIS_USER_ID VARCHAR2 30 NO USER ID: The user id of the person who caused this
record to be generated by changing data on the
employees assignment record.
PERJHIS_ACTIVITY_DATE DATE 7 NO Date of last activity for this record.
PERJHIS_JCRE_CODE VARCHAR2 5 YES JOB CHANGE REASON CODE: Code to indicate why the
assignment record was changed Valid values for this
field are defined on the PTVJCRE validation form.
PERJHIS_EMPR_CODE VARCHAR2 4 YES EMPR_CODE: The Employer Identification Code.
PERJHIS_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location to which this position
belongs.
PERJHIS_SCHL_CODE VARCHAR2 6 YES SCHOOL CODE: School to which this position belongs.
PERJHIS_SUPERVISOR_PIDM NUMBER 8 YES SUPERVISOR PIDM: Identification number of the
supervisor for this job.
PERJHIS_SUPERVISOR_POSN VARCHAR2 6 YES SUPERVISOR POSN: The position number of the
supervisor.
PERJHIS_SUPERVISOR_SUFF VARCHAR2 2 YES SUPERVISOR SUFFIX: Suffix associated with the
supervisor's position.
Date: 21-JUN-2004 Page: 124
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJHIS_WKCP_CODE VARCHAR2 4 YES WKCP CODE: Workers' Compensation Classification Code
associated with
this job.
PERJHIS_JBLN_CODE VARCHAR2 6 YES JBLN CODE: Job Location Code associated with this job.
PERJHIS_PERS_CHG_DATE DATE 7 YES PERSONNEL CHANGE DATE: Date the change became
effective, regardless of
payroll.
PERJHIS_DEFER_BAL NUMBER 11 2 YES DEFERRED BALANCE: The amount of deferred pay
accumulated for this job.
PERJHIS_CONTRACT_TYPE VARCHAR2 1 YES CONTRACT TYPE: Indicates whether this is the
(P)rimary, (S)econdary, or (O)verload job.
PERJHIS_SALARY_ENCUMBRANCE NUMBER 11 2 YES SALARY ENCUMBRANCE: The amount of money that this
person will be paid in this job during the current
fiscal year.
PERJHIS_CONTRACT_BEGIN_DATE DATE 7 YES CONTRACT START DATE: Start date of the contract.
PERJHIS_CONTRACT_END_DATE DATE 7 YES CONTRACT END DATE: End date of the contract.
PERJHIS_STEP_INCR_MON VARCHAR2 2 YES STEP INCREASE MONTH: Month in which an automatic step
increase is to take place.
PERJHIS_STEP_INCR_DAY VARCHAR2 2 YES STEP INCREASE DAY: Day of the month in which an
automatic step increase is to take place.
PERJHIS_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Valued only when Banner
Finance is installed.
PERJHIS_ACCRUE_LEAVE_IND VARCHAR2 1 YES ACCRUE LEAVE INDICATOR: Determines whether Leave is
accured for this job.
PERJHIS_CIVIL_SERVICE_IND VARCHAR2 1 YES CIVIL SERVICE INDICATOR: Indicates if this assignment
is a civil service job.
PERJHIS_FRINGE_ENCUMBRANCE NUMBER 11 2 YES FRINGE ENCUMBRANCE: The cost of fringe benefits that
this person will be paid in this job during the
current fiscal year.
PERJHIS_DESC VARCHAR2 30 YES DESCRIPTION: Description associated with the code.
PERJHIS_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET CHART OF ACCOUNTS CODE: Used only if Banner
Finance is installed.
PERJHIS_ORGN_CODE_TS VARCHAR2 6 YES TIME SHEET ORGANIZATION: The organization to which the
time sheet for this job will be sent.
PERJHIS_APPT_PCT NUMBER 5 2 YES APPOINTMENT PERCENTAGE:
PERJHIS_FTE NUMBER 6 3 YES FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this Job.
PERJHIS_HRS_PAY NUMBER 6 2 YES HOURS PER PAY: The number of hours an employee filling
this job normally works in a pay period.
PERJHIS_SHIFT VARCHAR2 1 YES SHIFT: The normal shift assigned to this job.
PERJHIS_FACTOR NUMBER 3 1 YES PAY FACTOR: The number of pays per calendar year.
PERJHIS_PER_PAY_SALARY NUMBER 11 2 YES PER PAY SALARY: Used for deferred pay calculations.
PERJHIS_PAYS NUMBER 3 1 YES NUMBER OF PAYS PER YEAR: Used for deferred pay
calculations.
PERJHIS_PER_PAY_DEFER_AMT NUMBER 11 2 YES PER PAY DEFERRED AMOUNT: The amount deferred each pay
period for deferred pay calculation.
PERJHIS_SGRP_CODE VARCHAR2 6 YES SGRP_CODE: The Salary Group Code.
PERJHIS_LGCD_CODE VARCHAR2 4 YES LGCD_CODE: Longevity code.
PERJHIS_PCAT_CODE VARCHAR2 4 YES PREMIUM PAY CODE: Controls premium pay generation.
PERJHIS_DFPR_CODE VARCHAR2 4 YES DEFER PAY CODE: Identifies rules governing deferred
pay.
PERJHIS_ENCUMBRANCE_HRS NUMBER 6 2 YES ENCUMBRANCE HOURS: The number of encumbrance hours.
Date: 21-JUN-2004 Page: 125
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJHIS_CAPTURE_DATE DATE 7 YES CAPTURE DATE: The date of the transaction.
PERJHIS_TOTAL_ENCUMBRANCE_HRS NUMBER 6 2 YES The sum of the PERJHIS_ENCUMBRANCE_HRS associated with
this position for the fiscal year that contains this
record' effective date.
PERJHIS_TOTAL_CONTRACT_HRS NUMBER 6 2 YES TOTAL CONTRACT HOURS: The total number of hours
contracted for this job.
PERJHIS_TIME_ENTRY_METHOD VARCHAR2 1 YES Time Entry Method: P = Payroll, W = Web, D =
Departmental, T = Third Party.
PERJHIS_TIME_ENTRY_TYPE VARCHAR2 1 YES Time Entry Type: T = Time Sheet, E = Exception Time
Only, N = None.
PERJHIS_TIME_IN_OUT_IND VARCHAR2 1 YES Time In and Out Indicator : Indicates that employee
must report time in and time out.
PERJHIS_PROBATION_BEGIN_DATE DATE 7 YES PROBATIONARY BEGIN DATE: The begin date of the
Probationary Period.
PERJHIS_PROBATION_END_DATE DATE 7 YES PROBATIONARY END DATE: The end date of the
Probationary Period.
PERJHIS_PROBATION_UNITS NUMBER 3 YES PROBATION UNITS: Identifies the number of Probationary
Units.
PERJHIS_LCAT_CODE VARCHAR2 2 YES Leave Category Code: A code which identifies a group
of leave types.
PERJHIS_LEAV_REPT_METHOD VARCHAR2 1 YES Leave Report Entry Method: P = None, W = Leave Report
on the Web, D = Departmental Leave Report, T = Third
Party Leave Report.
PERJHIS_ELIGIBLE_DATE DATE 7 YES ELIGIBLE DATE : Eligible Date for the Increase MM/DD.
PERJHIS_COMMENT_DATE DATE 7 YES Comment Date: The date the comment was created.
PERJHIS_COMMENT_USER_ID VARCHAR2 30 YES Comment User Id: User who created or last modified the
comment.
PERJHIS_COMMENT VARCHAR2 1300 YES Comment: Comments about the job action.
PERJHIS_PICT_CODE_LEAV_REPT VARCHAR2 2 YES Leave Report Payd ID: The pay ID associated with a
leave report or leave request
Date: 21-JUN-2004 Page: 126
TABLE: PERJLBD
CREATOR: PAYROLL
One-Time Payments Job Labor Distribution Information Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJLBD_PIDM NUMBER 8 NO PIDM: Personal identification code for an individual
tracked in the system.
PERJLBD_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
PERJLBD_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
PERJLBD_PERCENT NUMBER 5 2 NO PERCENT: Percent of pay to be applied to this labor
distribution.
PERJLBD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
PERJLBD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
PERJLBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Chart of Accounts code.
Valued only if Banner Finance is installed.
PERJLBD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX: Account Index. Valued only if Banner
Finance is installed.
PERJLBD_FUND_CODE VARCHAR2 6 YES FUND CODE: Fund. Valued only if Banner Finance is
installed.
PERJLBD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Organization. Valued only if
Banner Finance is installed.
PERJLBD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Account. Valued only if Banner Finance
is installed.
PERJLBD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Program. Valued only if Banner Finance
is installed.
PERJLBD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Activity. Valued only if Banner
Finance is installed.
PERJLBD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location. Valued only if Banner
Finance is installed.
PERJLBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
PERJLBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
PERJLBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Free form account code to allow
update of an accounting system other than Banner
Finance.
Date: 21-JUN-2004 Page: 127
TABLE: PERJLEV
CREATOR: PAYROLL
Employee Leave Balances by Jobs Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJLEV_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERJLEV_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
PERJLEV_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
PERJLEV_LEAV_CODE VARCHAR2 4 NO LEAVE CODE: The code identifying which type of leave
it is. The code must be previously defined on the
Leave Codes Rule Form (PTRLEAV).
PERJLEV_BEGIN_BALANCE NUMBER 6 2 NO LEAVE BEGINNING BALANCE: The leave balance at the
beginning of the year.
PERJLEV_ACCRUED NUMBER 6 2 NO LEAVE ACCRUED: Amount of Leave Accrued.
PERJLEV_TAKEN NUMBER 6 2 NO LEAVE TAKEN: The amount of leave taken this year.
PERJLEV_DATE_AVAIL DATE 7 NO Date leave will become available for employee.
PERJLEV_HRS_BANKED NUMBER 6 2 NO Number of hours banked for employee's leaves.
PERJLEV_USER_ID VARCHAR2 30 NO The unique identification of the user who changed the
record.
PERJLEV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 128
TABLE: PERJLHS
CREATOR: PAYROLL
History of Employee Leave Balances by Jobs Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJLHS_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERJLHS_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
PERJLHS_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
PERJLHS_LEAV_CODE VARCHAR2 4 NO LEAVE CODE: The code identifying which type of leave
it is. The code must be previously defined on the
Leave Codes Rule Form (PTRLEAV).
PERJLHS_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the change became effective to
this record.
PERJLHS_USER_ID VARCHAR2 30 NO USER ID : Oracle ID of user who changed the record.
PERJLHS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERJLHS_BEGIN_BALANCE NUMBER 6 2 YES LEAVE BEGINNING BALANCE: The leave balance at the
beginning of the year.
PERJLHS_ACCRUED NUMBER 6 2 YES LEAVE ACCRUED: Amount of Leave Accrued.
PERJLHS_TAKEN NUMBER 6 2 YES LEAVE TAKEN: The amount of leave taken this year.
PERJLHS_DATE_AVAIL DATE 7 YES Date leave will become available for employee.
PERJLHS_HRS_BANKED NUMBER 6 2 YES Number of hours banked for employee's leaves.
PERJLHS_CHANGE_REASON VARCHAR2 60 YES CHANGE REASON : Reason for changing the record.
Date: 21-JUN-2004 Page: 129
TABLE: PERJOBH
CREATOR: PAYROLL
Time Entry Jobs History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJOBH_SEQNO NUMBER 12 NO SEQUENCE NUMBER: Internal System Identification Number
for a time entry document.
PERJOBH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PERJOBH_YEAR VARCHAR2 4 NO PAY PERIOD YEAR.
PERJOBH_PICT_CODE VARCHAR2 2 YES PAY PERIOD PAY ID CODE.
PERJOBH_PAYNO NUMBER 3 YES PAY PERIOD PAYROLL NUMBER.
PERJOBH_MONTH NUMBER 2 YES Reserved for future use.
PERJOBH_ACTION_IND VARCHAR2 1 NO ACTION: Action of employee; T = report time R =
request leave.
PERJOBH_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERJOBH_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
PERJOBH_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
PERJOBH_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET ORGANIZATION CHART OF ACCOUNTS CODE: BANNER
FINANCE system defined Chart of Accounts Code under
which the Time Sheet Department is created.
PERJOBH_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE.
PERJOBH_STATUS_IND VARCHAR2 1 NO STATUS: Indicates status of time sheet or leave
request.
PERJOBH_JOB_TITLE VARCHAR2 30 YES JOB TITLE.
PERJOBH_SHIFT VARCHAR2 1 NO
PERJOBH_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: Employee Class Code.
PERJOBH_TIME_ENTRY_METHOD VARCHAR2 1 NO TIME ENTRY METHOD: Method of time entry; P = Payroll W
= Web D = Departmental T = Third Party.
PERJOBH_TIME_ENTRY_TYPE VARCHAR2 1 NO TIME ENTRY TYPE: Type of time reported; T = time sheet
E = exception time only.
PERJOBH_TIME_IN_OUT_IND VARCHAR2 1 NO TIME IN/OUT INDCATOR: Indicates that employee must
report time in and time out.
PERJOBH_ACAT_CODE VARCHAR2 6 YES APPROVAL CATEGORY CODE: Approval category.
PERJOBH_COMMENT VARCHAR2 2000 YES COMMENT: Comment about the time entry document.
PERJOBH_COMMENT_DATE_TIME DATE 7 YES COMMENT DATE AND TIME: The date and time the comment
was made.
PERJOBH_COMMENT_CONFID_IND VARCHAR2 1 NO CONFIDENTIALITY INDICATOR: Indicates that employee
cannot see the comment.
PERJOBH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERJOBH_LCAT_CODE VARCHAR2 2 YES LEAVE CATEGORY CODE: A code identifies a group of
leave types (Leave Codes) which can be assigned to an
employee.
Date: 21-JUN-2004 Page: 130
TABLE: PERJOBI
CREATOR: PAYROLL
One-Time Payments Job Information Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJOBI_PIDM NUMBER 8 NO PIDM: Personal identification code for an individual
tracked in the system.
PERJOBI_POSN VARCHAR2 6 NO POSITION: The Position to which this job is attached.
PERJOBI_SUFF VARCHAR2 2 NO SUFFIX: The Suffix attached to the job.
PERJOBI_STATUS_IND VARCHAR2 1 NO STATUS INDICATOR: Status of the Record. Valid values
are: C - Created, A- Applied.
PERJOBI_REG_RATE NUMBER 11 6 NO REGULAR RATE: The regular hourly rate for this job.
PERJOBI_WORK_BEGIN_DATE DATE 7 NO WORK BEGIN DATE: Date that work began.
PERJOBI_WORK_END_DATE DATE 7 NO WORK END DATE: Date that work ended.
PERJOBI_PAYROLL_DATE DATE 7 NO PAYROLL DATE: Date corresponding to what pay cycle the
payment will be made.
PERJOBI_YEAR VARCHAR2 4 NO CALENDAR YEAR: The calendar year in which the pay
period falls.
PERJOBI_PICT_CODE VARCHAR2 2 NO PAY IDENTIFICATION CODE: Identification code for this
payroll.
PERJOBI_PAYNO NUMBER 3 NO PAY NUMBER: The pay of the year.
PERJOBI_ORIGINAL_USER_ID VARCHAR2 30 NO ORIGINAL USER IDENTIFICATION: User ID of the User who
created the record.
PERJOBI_ORIGINAL_ACTIVITY_DATE DATE 7 NO Date the record was created.
PERJOBI_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: User ID of the User who created
or last updated the record.
PERJOBI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
PERJOBI_TITLE VARCHAR2 30 YES JOB TITLE: Title of the job. Defaults from the
Position Title if left blank.
PERJOBI_TRANSACTION_NO NUMBER 15 YES TRANSACTION NUMBER: A number that is system generated
for approval transactions.
PERJOBI_APPLIED_USER_ID VARCHAR2 30 YES APPLIED USER IDENTIFICATION: User ID of the User who
applied the record.
PERJOBI_APPLIED_ACTIVITY_DATE DATE 7 YES Date the record was applied.
Date: 21-JUN-2004 Page: 131
TABLE: PERJOBP
CREATOR: PAYROLL
Employee Job Progression Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJOBP_PIDM NUMBER 8 NO PERJOBP_PIDM: Internal ID number.
PERJOBP_JOBP_CODE VARCHAR2 5 NO PERJOBP_JOBP_CODE: Job Progression Code.
PERJOBP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the PERJOBP table.
PERJOBP_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who inserted or updated the record.
Date: 21-JUN-2004 Page: 132
TABLE: PERJOBS
CREATOR: PAYROLL
Time Entry Jobs Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJOBS_SEQNO NUMBER 12 NO SEQUENCE NUMBER: Internal System Identification Number
for a time entry document.
PERJOBS_YEAR VARCHAR2 4 NO PAY PERIOD YEAR.
PERJOBS_PICT_CODE VARCHAR2 2 YES PAY PERIOD PAY ID CODE.
PERJOBS_PAYNO NUMBER 3 YES PAY PERIOD PAYROLL NUMBER.
PERJOBS_MONTH NUMBER 2 YES Reserve for future use.
PERJOBS_ACTION_IND VARCHAR2 1 NO ACTION: Action of employee; T = report time R =
request leave.
PERJOBS_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERJOBS_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
PERJOBS_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
PERJOBS_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET ORGANIZATION CHART OF ACCOUNTS CODE: BANNER
FINANCE system defined Chart of Accounts Code under
which the Time Sheet Department is created.
PERJOBS_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE.
PERJOBS_STATUS_IND VARCHAR2 1 NO STATUS: Indicates status of time sheet or leave
request.
PERJOBS_JOB_TITLE VARCHAR2 30 YES JOB TITLE.
PERJOBS_SHIFT VARCHAR2 1 NO JOB SHIFT.
PERJOBS_ECLS_CODE VARCHAR2 2 NO EMPLOYEE CLASS CODE: Employee Class Code.
PERJOBS_TIME_ENTRY_METHOD VARCHAR2 1 NO TIME ENTRY METHOD: Method of time entry; P = Payroll W
= Web D = Departmental T = Third Party.
PERJOBS_TIME_ENTRY_TYPE VARCHAR2 1 NO TIME ENTRY TYPE: Type of time reported; T = time sheet
E = exception time only.
PERJOBS_TIME_IN_OUT_IND VARCHAR2 1 NO TIME IN/OUT INDCATOR: Indicates that employee must
report time in and time out.
PERJOBS_ACAT_CODE VARCHAR2 6 YES APPROVAL CATEGORY CODE: Approval category.
PERJOBS_COMMENT VARCHAR2 2000 YES COMMENT: Comment about the time entry document.
PERJOBS_COMMENT_DATE_TIME DATE 7 YES COMMENT DATE AND TIME: The date and time that the
comment was made.
PERJOBS_COMMENT_CONFID_IND VARCHAR2 1 NO CONFIDENTIALITY INDICATOR: Indicates that employee
cannot see the comment.
PERJOBS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERJOBS_LCAT_CODE VARCHAR2 2 NO LEAVE CATEGORY CODE: A code identifies a group of
leave types (Leave Codes) which can be assigned to an
employee.
PERJOBS_APPT_PCT NUMBER 5 2 YES APPOINTMENT PERCENTAGE: Appointment Percentage.
PERJOBS_FTE NUMBER 6 3 YES FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this Job.
PERJOBS_HRS_DAY NUMBER 6 2 YES HOURS PER DAY: The number of hours an employee filling
this job normally works in a day.
Date: 21-JUN-2004 Page: 133
TABLE: PERJTOT
CREATOR: PAYROLL
Employee Monthly Job Totals Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERJTOT_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERJTOT_YEAR NUMBER 4 NO YEAR:
PERJTOT_POSN VARCHAR2 6 NO POSITION: The position number of the assignment.
PERJTOT_SUFF VARCHAR2 2 NO SUFFIX; The suffix associated with the assignment.
PERJTOT_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: The earnings code that these totals are
associated with. They must have been established on
the PTREARN rule form.
PERJTOT_MONTH NUMBER 2 NO MONTH:
PERJTOT_HRS NUMBER 6 2 YES HOURS: The total hours for this earnings code during
this month.
PERJTOT_GRS NUMBER 11 2 YES GROSS: The gross earnings for this earnings code and
month.
PERJTOT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (update or
insert) on this record.
PERJTOT_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
Date: 21-JUN-2004 Page: 134
TABLE: PERLEAV
CREATOR: PAYROLL
Employee Leave Balances Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERLEAV_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERLEAV_LEAV_CODE VARCHAR2 4 NO LEAVE CODE: The code identifying which type of leave
it is. The code must be previously defined on the
Leave Codes Rule Form (PTRLEAV).
PERLEAV_BEGIN_BALANCE NUMBER 6 2 NO LEAVE BEGINNING BALANCE: The leave balance at the
beginning of the year.
PERLEAV_ACCRUED NUMBER 6 2 NO LEAVE ACCRUED: Amount of Leave Accrued.
PERLEAV_TAKEN NUMBER 6 2 NO LEAVE TAKEN: The amount of leave taken this year.
PERLEAV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERLEAV_DATE_AVAIL DATE 7 NO Date leave will become available for employee.
PERLEAV_HRS_BANKED NUMBER 6 2 NO Number of hours banked for employee's leaves.
Date: 21-JUN-2004 Page: 135
TABLE: PERLHIS
CREATOR: PAYROLL
History Employee Leave Balances Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERLHIS_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERLHIS_LEAV_CODE VARCHAR2 4 YES LEAVE CODE: The code identifying which type of leave
it is. The code must be previously defined on the
Leave Codes Rule Form (PTRLEAV).
PERLHIS_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: Date the change became effective to
this record.
PERLHIS_BEGIN_BALANCE NUMBER 6 2 YES LEAVE BEGINNING BALANCE: The leave balance at the
beginning of the year.
PERLHIS_ACCRUED NUMBER 6 2 YES LEAVE ACCRUED: Amount of Leave Accrued.
PERLHIS_TAKEN NUMBER 6 2 YES LEAVE TAKEN: The amount of leave taken this year.
PERLHIS_DATE_AVAIL DATE 7 YES Date leave will become available for employee.
PERLHIS_HRS_BANKED NUMBER 6 2 YES Number of hours banked for employee's leaves.
PERLHIS_CHANGE_REASON VARCHAR2 60 YES CHANGE REASON : Reason for changing the record.
PERLHIS_USER_ID VARCHAR2 30 NO USER ID : Oracle ID of user who changed the record.
PERLHIS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 136
TABLE: PERLVTK
CREATOR: PAYROLL
Employee Leave Hours Taken Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERLVTK_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERLVTK_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings Code.
PERLVTK_LEAV_CODE VARCHAR2 4 NO LEAVE CODE: The code identifying the type of leave.
PERLVTK_USER_ID VARCHAR2 30 NO USER ID: The unique identification of the user who
changed the record.
PERLVTK_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERLVTK_HRS NUMBER 6 2 YES LEAVE HOURS TAKEN: The number of hours taken.
Date: 21-JUN-2004 Page: 137
TABLE: PERNASG
CREATOR: PAYROLL
Employee Assignment Data Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERNASG_REPORT_NO VARCHAR2 5 NO MIS REPORT IDENTIFIER: This field indicates Assignment
Report Identifier.
PERNASG_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERNASG_POSN VARCHAR2 6 NO POSITION NUMBER: Defines an employees position.
PERNASG_SUFF VARCHAR2 2 NO POSITION SUFFIX: Used with Position Number to make-up
an employees Job ID.
PERNASG_POSN_STATUS VARCHAR2 1 NO JOB STATUS: The status of the job. Valid values are:
A-active, B-leave without pay with benefits, L -leave
without pay without benefits, F-leave with full pay
and benefits, P-leave with partial pay a nd benefits,
T-terminated.
PERNASG_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The Date that the Jobs record becomes
effective.
PERNASG_SOURCE VARCHAR2 1 NO RECORD SOURCE: Valid values are: 1-instructional
faculty from SIRASGN, 2-non-instructional faculty from
SIRNIST,3-instructional faculty leaves from
SIRLVAS,4-non-instructional faculty leaves from
SIRNLVA,5-non-faculty employees.
PERNASG_REPORT_IND VARCHAR2 1 NO MIS REPORT INDICATOR: This field indicates Assignment
Report Indicator.
PERNASG_USER_ID VARCHAR2 30 NO USER ID: User Identification Number.
PERNASG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (update or
insert) on this record.
PERNASG_REPORT_DATE DATE 7 NO REPORT DATE: The current reporting date that the
report was run.
PERNASG_TERM_CODE VARCHAR2 6 YES TERM CODE: Term of the faculty member assignment.
PERNASG_CRN VARCHAR2 5 YES COURSE REFERENCE NUMBER: The course reference of the
course that the instructor was assigned to.
PERNASG_CATEGORY VARCHAR2 2 YES ASSIGNMENT CATEGORY: The session indicator associated
with the assignment.
PERNASG_NIST_CODE VARCHAR2 4 YES NIST CODE: The non-instructional type code.
PERNASG_COLL_CODE VARCHAR2 2 YES COLLEGE CODE: The non-instructional college code.
PERNASG_DEPT_CODE VARCHAR2 4 YES DEPARTMENT CODE: The non-instructional department
code.
PERNASG_DICD_CODE VARCHAR2 3 YES DISTRICT/DIVISION CODE: The district or division
associated with an employee.
PERNASG_TERM_IDENTIFIER VARCHAR2 3 YES TERM IDENTIFIER: A Parameter entered during PEPAEXT
process runtime.
PERNASG_SSN VARCHAR2 9 YES SSN: Persons social security number.
PERNASG_ASSIGN_TYPE VARCHAR2 2 YES ASSIGNMENT TYPE: A code which identifies the type of
assignment.
PERNASG_LEAVE_STATUS VARCHAR2 1 YES LEAVE STATUS: Indicates the status of the employee
leave assignment.
PERNASG_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: The account code for this employee.
PERNASG_WEEKLY_HRS NUMBER 5 2 YES WEEKLY HOURS: Average number of hours per week
employee is contracted to spend on assignment.
Date: 21-JUN-2004 Page: 138
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERNASG_HOURLY_RATE NUMBER 11 6 YES HOURLY RATE: Hourly rate on assignment..
PERNASG_FTE NUMBER 6 3 YES FTE: The number of FTEs for this employee.
Date: 21-JUN-2004 Page: 139
TABLE: PERPADV
CREATOR: PAYROLL
Pay Advance Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERPADV_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERPADV_POSN VARCHAR2 6 NO POSITION NUMBER: Position associated with the Pay
Advance table.
PERPADV_SUFF VARCHAR2 2 NO SUFF: Suffix attached to the position number.
PERPADV_ADVANCE_ACTIVE_IND VARCHAR2 1 NO Advance Active Indicator: Valid values are (Y)es or
(N)o.
PERPADV_ADVANCE_AMT NUMBER 11 2 YES Advance Amount: The amount of the pay advance.
PERPADV_ADVANCE_BALANCE NUMBER 11 2 YES Advance Balance: Balance remaining on the advanced
amount.
PERPADV_ACTIVITY_DATE DATE 7 NO Date of Last Modification of the Record.
Date: 21-JUN-2004 Page: 140
TABLE: PERPCRE
CREATOR: PAYROLL
Employee Canadian Pension Credit Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERPCRE_YEAR NUMBER 4 NO CALENDAR YEAR.
PERPCRE_EMPR_CODE VARCHAR2 4 NO EMPLOYER CODE.
PERPCRE_PIDM NUMBER 8 NO PIDM : Internal Identification Number associated with
a person.
PERPCRE_BDCA_CODE VARCHAR2 3 NO DEDUCTION CODE.
PERPCRE_BDPL_CODE VARCHAR2 2 YES BENEFIT/DEDUCTION PLAN CODE: Identifies the Plan
associated with the benefit defined.
PERPCRE_PENSION_CREDIT NUMBER 11 2 NO PENSION CREDIT : A measure of the value of benefits
accruing to an employee under the pension plan. Each
benefit provision of an RPP (Registered Pension Plan)
or DPSP (Deferred Profit Sharing Plan) produces a
pension credit for the participating employee.
PERPCRE_CREDIT_OVERRIDE NUMBER 11 2 YES PENSION CREDIT OVERRIDE : The value to override the
calculated pension credit must be entered in this
field. If this field has a value, the system uses the
override value in the calculation of the Pension
Adjustment.
PERPCRE_PENSION_SERVICE NUMBER 6 2 NO PENSIONABLE SERVICE : Pensionable service of employee.
Maximum value is 1.
PERPCRE_SERVICE_OVERRIDE NUMBER 6 2 YES PENSIONABLE SERVICE OVERRIDE: The value to override
the calculated pensionable service must be enterd in
this field. If this field has a value, then the
system uses this value in the calculation of the
Pension Credit.
PERPCRE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 141
TABLE: PERRANK
CREATOR: PAYROLL
Faculty Rank History Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERRANK_PIDM NUMBER 8 NO PIDM:Internal ID number.
PERRANK_ACTION_DATE DATE 7 NO Action Date.
PERRANK_ORGN VARCHAR2 6 YES Organization code as defined by the BANNER Finance
system.
PERRANK_COAS_CODE VARCHAR2 1 YES Chart of accounts code as defined by the Banner
Finance system.
PERRANK_POSN VARCHAR2 6 YES POSITION: The employees position number.
PERRANK_SUFF VARCHAR2 2 YES SUFFIX: A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERRANK_BEGIN_DATE DATE 7 NO Rank Effective Date.
PERRANK_NEXT_DATE DATE 7 YES Rank next Review Date.
PERRANK_INITIAL VARCHAR2 1 YES Rank Initial Record.
PERRANK_RANK_CODE VARCHAR2 2 YES Rank Code.
PERRANK_DECISION VARCHAR2 1 YES Decision for Rank.
PERRANK_DECISION_DATE DATE 7 YES Decision Date for Rank.
PERRANK_DECISION_DEFER_DATE DATE 7 YES Decision Deferred to Date.
PERRANK_COMMENT LONG YES RANK Comments.
PERRANK_ACADEMIC_TITLE VARCHAR2 80 YES Academic Title.
PERRANK_EMERITUS_STATUS VARCHAR2 1 YES Emeritue Status.
PERRANK_APPEAL_DATE DATE 7 YES Appeal Date.
PERRANK_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:Date the record was inserted or updated.
PERRANK_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user who changed the record.
Date: 21-JUN-2004 Page: 142
TABLE: PERRCMT
CREATOR: PAYROLL
Record of Employment Comments Information table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERRCMT_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERRCMT_PICT_CODE VARCHAR2 2 NO COMMENT PAYROLL IDENTIFICATION CODE.
PERRCMT_ISSUE_DATE DATE 7 NO ISSUE DATE: The date on which the ROE is completed.
PERRCMT_COMMENT VARCHAR2 40 NO COMMENT: Used for explaining why the date in Last Day
Worked differs from the the date in Unemployment
Insurance Premiums Payable Up To and extra space for
the Payments or benefits other than regular pay paid
and excluded ROE.
PERRCMT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERRCMT_SEQ_NO NUMBER 2 NO SEQ_NO: Sequence number.
PERRCMT_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
Date: 21-JUN-2004 Page: 143
TABLE: PERREVW
CREATOR: PAYROLL
Employee Review Type Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERREVW_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERREVW_REVT_CODE VARCHAR2 2 NO REVIEW TYPE CODE: A code identifying the type of
review. The code must be previously defined on the
Review Code Valication Form (PTVREVT).
PERREVW_REVT_DATE DATE 7 NO REVIEW TYPE DATE: The date this review type is due for
completion.
PERREVW_REVT_COMPLETE VARCHAR2 1 YES REVIEW TYPE COMPLETE: Code used to identify if this
review type has been completed.
PERREVW_REVT_RATING VARCHAR2 6 YES REVIEW TYPE RATING: A user defined rating system for
completed review types.
PERREVW_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date of last activity (insert or
update) on this record.
PERREVW_REVIEWER_PIDM NUMBER 8 YES REVIEWER PIDM: The internal ID of person responsible
for the review.
PERREVW_COMMENT LONG YES COMPLETED DATE: This field indicates the date the
review was completed.
PERREVW_COMPLETED_DATE DATE 7 YES COMMENT: Free form comments.
Date: 21-JUN-2004 Page: 144
TABLE: PERRHOL
CREATOR: PAYROLL
Record of Employment Holiday Information table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERRHOL_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERRHOL_PICT_CODE VARCHAR2 2 NO HOLIDAY PAYROLL IDENTIFICATION CODE.
PERRHOL_ISSUE_DATE DATE 7 NO HOLIDAY ISSUE DATE: The date on which the ROE is
completed.
PERRHOL_HOLIDAY_DATE DATE 7 NO HOLIDAY DATE: Statutory holiday pay, paid or payable,
is considered to be earnings for the purpose of
calculation UI benefits. Enter the later of datesthan
Last Day Worked and UI Premiums Payable Up To.
PERRHOL_HOLIDAY_PAY NUMBER 11 2 NO HOLIDAY PAY: Statutory holiday pay, paid or payable,
is considered to be earnings for the purpose of
calculating UI benefits. Enter the holiday amountthat
occur after the later of dates, Last Day Worked and UI
Premiums Payable.
PERRHOL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERRHOL_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
Date: 21-JUN-2004 Page: 145
TABLE: PERROTH
CREATOR: PAYROLL
Record of Employment Other Monies Information table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERROTH_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PERROTH_PICT_CODE VARCHAR2 2 NO OTHER MONIES PAYROLL IDENTIFICATION CODE.
PERROTH_ISSUE_DATE DATE 7 NO OTHER MONIES ISSUE DATE: The date on which the ROE is
completed.
PERROTH_OTHER_MONIES_NOTE VARCHAR2 15 NO OTHER MONIES NOTE: The description of paid or payable
in contemplation of, on,or after the separation from
employment.
PERROTH_OTHER_MONIES_AMT NUMBER 11 2 NO OTHER MONIES AMOUNT: Paid or payable in contemplation
of, on, or after the separation from employment.
PERROTH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PERROTH_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
Date: 21-JUN-2004 Page: 146
TABLE: PERROUH
CREATOR: PAYROLL
Time Entry Routing Queue History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERROUH_JOBS_SEQNO NUMBER 12 NO SEQUENCE NUMBER: Internal time entry sequence number.
PERROUH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PERROUH_APPR_SEQNO NUMBER 3 NO SEQUENCE NUMBER: Designates the order in which the
approvers take action.
PERROUH_APPR_POSN VARCHAR2 6 NO APPROVER POSITION: The position of the approver.
PERROUH_APPR_PIDM NUMBER 8 YES APPROVER PIDM: The internal ID number of the approver.
PERROUH_APPR_ACTION_IND VARCHAR2 1 NO ACTION INDICATOR: Action of the approver.
PERROUH_MANDATORY_APPR_IND VARCHAR2 1 YES MANDATORY APPROVER INDICATOR: Indicates that this user
must approve the time entry.
PERROUH_ACTION_PIDM NUMBER 8 YES ACTION PIDM: The internal ID number of the person who
actually approved (original approver, proxy, or
superuser).
PERROUH_QUEUE_STATUS_IND VARCHAR2 1 NO QUEUE STATUS IND: The indicator for the queue status
of the approver.
PERROUH_STATUS_DATE_TIME DATE 7 NO STATUS DATE TIME: The status date/time of the
approver"s action in the queue.
PERROUH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 147
TABLE: PERROUT
CREATOR: PAYROLL
Time Entry Routing Queue Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERROUT_JOBS_SEQNO NUMBER 12 NO SEQUENCE NUMBER: Internal System Identification Number
for a time entry document.
PERROUT_APPR_SEQNO NUMBER 3 NO SEQUENCE NUMBER: Designates the order in which the
approvers take action.
PERROUT_APPR_POSN VARCHAR2 6 NO APPROVER POSITION: The position of the approver.
PERROUT_APPR_PIDM NUMBER 8 YES APPROVER PIDM: The internal id number of the approver.
PERROUT_APPR_ACTION_IND VARCHAR2 1 NO ACTION INDICATOR: Action of the approver.
PERROUT_MANDATORY_APPR_IND VARCHAR2 1 YES MANDATORY APPROVER INDICATOR: Indicates that this user
must approve the time entry.
PERROUT_ACTION_PIDM NUMBER 8 YES ACTION PIDM: The internal ID number of the person who
actually approved (original approver, proxy, or
superuser).
PERROUT_QUEUE_STATUS_IND VARCHAR2 1 NO QUEUE STATUS IND: The indicator for the queue status
of the approver.
PERROUT_STATUS_DATE_TIME DATE 7 NO STATUS DATE TIME: The status date/time of the
approver"s action in the queue.
PERROUT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 148
TABLE: PERSABB
CREATOR: PAYROLL
Faculty Sabbatical/Other Leaves History Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERSABB_PIDM NUMBER 8 NO PIDM: Internal ID number.
PERSABB_ACTION_DATE DATE 7 NO Action Date.
PERSABB_ORGN VARCHAR2 6 YES Organization Code.
PERSABB_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERSABB_POSN VARCHAR2 6 YES The employees position number.
PERSABB_SUFF VARCHAR2 2 YES A field added to the ID number/position number
combination to allow one employee to hold two jobs
with the same position number.
PERSABB_BEGIN_DATE DATE 7 NO Leave Requested From Date.
PERSABB_END_DATE DATE 7 YES Leave Requested To Date.
PERSABB_NEXT_DATE DATE 7 YES Next Eligibility Date.
PERSABB_LREA_CODE VARCHAR2 2 YES Leave Code.
PERSABB_SBTY_CODE VARCHAR2 4 YES Sabbatical Code.
PERSABB_LREA_CODE_NEXT VARCHAR2 2 YES Next Leave Code.
PERSABB_DECISION_DEFER_DATE DATE 7 YES Decision Deferred To Date.
PERSABB_DEFER_BEGIN DATE 7 NO Approved Leave Begin Date.
PERSABB_DEFER_END DATE 7 YES Approved Leave End Date.
PERSABB_DECISION VARCHAR2 1 YES Leave Decision.
PERSABB_DECISION_DATE DATE 7 YES Date of Decision.
PERSABB_COMMENT LONG YES Faculty Leave Comments.
PERSABB_TRANS_NO NUMBER 15 YES Faculty Leave Transaction Number.
PERSABB_COMM_FULL_DUE_DATE DATE 7 YES Fulfillment Due Date.
PERSABB_COMM_FULL_DATE DATE 7 YES Fulfillment Date.
PERSABB_APPEAL_DATE DATE 7 YES Appeal Date.
PERSABB_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was inserted or
updated.
PERSABB_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user who changed the record.
Date: 21-JUN-2004 Page: 149
TABLE: PERSAHS
CREATOR: PAYROLL
Employee Seniority Adjustment History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERSAHS_PIDM NUMBER NO PERSAHS_PIDM: Internal ID number.
PERSAHS_PCLS_CODE VARCHAR2 5 NO PERSAHS_PCLS_CODE: Position Class code.
PERSAHS_CAPTURE_DATE_TIME DATE 7 NO PERSAHS_CAPTURE_DATE_TIME: Date and time the record
was changed.
PERSAHS_SARC_CODE VARCHAR2 4 NO PERSAHS_SARC_CODE: Adjustment reason code.
PERSAHS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the PERSAHS table.
PERSAHS_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the
record.
PERSAHS_ADJUSTED_HRS NUMBER 10 2 YES PERSAHS_ADJUSTED_HRS: Number of hours manually changed
to an employee's seniority hours
PERSAHS_SENIORITY_HRS NUMBER 11 2 YES PERSAHS_SENIORITY_HRS: Sum of earned hours plus manual
hours credited for seniority in a position class code
by job progression.
PERSAHS_DATE_IN_CLASS DATE 7 YES PERSAHS_DATE_IN_CLASS: Date employee is associated
with position class.
PERSAHS_COMMENTS VARCHAR2 2000 YES PERSAHS_COMMENTS: Comments related to the adjustment
of seniority hours or date in class.
Date: 21-JUN-2004 Page: 150
TABLE: PERSNBL
CREATOR: PAYROLL
Employee Seniority Balance Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERSNBL_PIDM NUMBER NO PERSNBL_PIDM: Internal ID number.
PERSNBL_PCLS_CODE VARCHAR2 5 NO PERSNBL_PCLS_CODE: Position Class code.
PERSNBL_SENIORITY_HRS NUMBER 11 2 NO PERSNBL_SENIORITY_HRS: Sum of earned hours plus manual
hours credited for seniority in a position class code
by job progression.
PERSNBL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the PERSNBL table.
PERSNBL_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the
record.
PERSNBL_EARNED_HRS NUMBER 11 2 YES PERSNBL_EARNED_HRS: Sum of earned hours accruing
seniority.
PERSNBL_DATE_IN_CLASS DATE 7 YES PERSNBL_DATE_IN_CLASS: Date employee is associated
with position class.
Date: 21-JUN-2004 Page: 151
TABLE: PERSTAN
CREATOR: PAYROLL
Employee Statistics Annual Salary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERSTAN_PIDM NUMBER 8 NO PIDM: Persons internal unique ID number.
PERSTAN_ANNUAL_SALARY NUMBER 11 2 YES ANNUAL SALARY: An employees Statistical Annual Salary.
PERSTAN_ANNUAL_SALARY_DATE DATE 7 YES ANNUAL SALARY DATE: The date an employees Statistical
Annual Salary was calculated.
PERSTAN_PROJECTED_ANN_SALARY NUMBER 11 2 YES PROJECTED ANNUAL SALARY: An employees Statistical
Annual Salary with an estimated increase.
PERSTAN_PROJECTED_SALARY_DATE DATE 7 YES PROJECTED ANNUAL SALARY DATE: The date an employees
Projected Statistical Annual Salary was calculated.
PERSTAN_PEND_NEGOTIATIONS_IND VARCHAR2 1 YES PENDING NEGOTIATIONS INDICATOR: Indicates whether or
not the Projected Statistical Annual Salary is based
on pending negotiations.
PERSTAN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date this row was updated.
Date: 21-JUN-2004 Page: 152
TABLE: PERTETH
CREATOR: PAYROLL
Time Entry Transaction History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERTETH_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERTETH_SEQNO NUMBER 3 NO SEQUENCE NUMBER: Internal time entry event history
sequence number.
PERTETH_TRANS_TYPE_IND VARCHAR2 1 NO TRANSACTION TYPE: Type of transaction performed on
time entry document: S = submitted, R = returned for
correction, A = approved, O = originated.
PERTETH_TRANS_ROLE_IND VARCHAR2 1 NO TRANSACTION ROLE INDICATOR: The role of the person who
made the transaction.
PERTETH_TRANS_PIDM NUMBER 8 NO TRANSACTION PIDM: Internal ID number of person who
took action on time entry document.
PERTETH_TRANS_DATE_TIME DATE 7 NO TRANSACTION DATE TIME: Date and time of transaction on
time entry document.
PERTETH_TRANS_SOURCE_IND VARCHAR2 1 NO TRANSACTION SOURCE: Where transaction took place: W =
web, D= departmental.
PERTETH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PERTETH_TRANS_PROXY_FOR_PIDM NUMBER 8 YES PROXY FOR PIDM: Internal ID number of the proxy for
person.
Date: 21-JUN-2004 Page: 153
TABLE: PERTITH
CREATOR: PAYROLL
Time In/Out History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERTITH_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERTITH_TETH_SEQNO NUMBER 3 NO TIME ENTRY TRANSACTION SEQUENCE NUMBER: Internal
one-up sequence number.
PERTITH_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code.
PERTITH_TIME_ENTRY_DATE DATE 7 NO BEGIN DATE: Date that the hours breakdown period
begins.
PERTITH_TIME_IN VARCHAR2 4 NO TIME IN: Started work at this time of the day.
PERTITH_TIME_OUT VARCHAR2 4 NO TIME IN: Ended work at this time of the day.
PERTITH_SHIFT VARCHAR2 1 YES SHIFT: Shift associated with earnings.
PERTITH_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: Special rate for the earnings.
PERTITH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 154
TABLE: PERTITO
CREATOR: PAYROLL
Time Entry Hours Breakdown Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERTITO_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PERTITO_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code.
PERTITO_TIME_ENTRY_DATE DATE 7 NO BEGIN DATE: Date that the hours breakdown period
begins.
PERTITO_TIME_IN VARCHAR2 4 NO TIME IN: Started work at this time of the day.
PERTITO_TIME_OUT VARCHAR2 4 NO TIME IN: Ended work at this time of the day.
PERTITO_SHIFT VARCHAR2 1 YES SHIFT: Shift associated with earnings.
PERTITO_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: Special rate for the earnings.
PERTITO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
Date: 21-JUN-2004 Page: 155
TABLE: PERTWFA
CREATOR: PAYROLL
Temporary Table for Work Force Analysis Reports
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERTWFA_COAS_CODE VARCHAR2 1 YES Chart of Accounts Code.
PERTWFA_ORGN_CODE VARCHAR2 6 YES Organization Code.
PERTWFA_PGRP_CODE VARCHAR2 4 YES Position Group
PERTWFA_JOB_TITLE VARCHAR2 30 YES Job Title.
PERTWFA_PIDM NUMBER 8 YES Pidm of person.
PERTWFA_SALARY NUMBER 11 2 YES Annual Salary
PERTWFA_RATE NUMBER 11 6 YES Regular Rate
PERTWFA_SEX VARCHAR2 1 YES Sex.
PERTWFA_ETHNIC1 VARCHAR2 1 YES Count of employees having eeoc code of 1.
PERTWFA_ETHNIC2 VARCHAR2 1 YES Count of employees having eeoc code of 2.
PERTWFA_ETHNIC3 VARCHAR2 1 YES Count of employees having eeoc code of 3.
PERTWFA_ETHNIC4 VARCHAR2 1 YES Count of employees having eeoc code of 4.
PERTWFA_ETHNIC5 VARCHAR2 1 YES Count of employees having eeoc code of 5.
PERTWFA_JOBS_POSN VARCHAR2 6 YES Position from the nbrjobs record.
PERTWFA_JOBS_SUFF VARCHAR2 2 YES Suffix of the position from the nbrjobs record.
PERTWFA_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: Date the record was inserted or last
updated.
PERTWFA_ETHNIC6 VARCHAR2 1 YES Count of employees having eeoc code of 6.
Date: 21-JUN-2004 Page: 156
TABLE: PERXJOB
CREATOR: PAYROLL
Jobs Excluded From the EEO-5 Report Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PERXJOB_PIDM NUMBER 8 NO PIDM : Internal Identification Number associated with
a person.
PERXJOB_SCHL_CODE VARCHAR2 6 NO SCHOOL CODE : School to which excluded job belongs.
PERXJOB_POSN VARCHAR2 6 NO POSITION NUMBER: Position Number of Excluded Job.
PERXJOB_SUFF VARCHAR2 2 NO SUFFIX: Suffix of Excluded Job.
PERXJOB_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 157
TABLE: PETDEGR
CREATOR: PAYROLL
temp table Web for Executive Degree profile extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETDEGR_SOURCE CHAR 1 YES Identifies the original source of the data.
PETDEGR_PIDM NUMBER 8 NO Internal Identification Number of the person.
PETDEGR_CALENDAR_MONTH VARCHAR2 2 YES Calendar month of the select (MM).
PETDEGR_CALENDAR_YEAR VARCHAR2 4 YES Calendar year of the select (YYYY).
PETDEGR_EMPLOYER VARCHAR2 4 YES Employer code for the employee.
PETDEGR_DIVISION VARCHAR2 3 YES Division code for the employee.
PETDEGR_CHART_CODE VARCHAR2 1 YES Chart of accounts code for the home organization of
the employee.
PETDEGR_DEPARTMENT VARCHAR2 6 YES Organization code for the home organization of the
employee.
PETDEGR_GENDER_CODE VARCHAR2 1 YES Gender of the employee.
PETDEGR_ETHNIC_CODE VARCHAR2 2 YES Institutional ethnicity code of the employee.
PETDEGR_GOVT_ETHNIC_CODE VARCHAR2 1 YES Governmental ethnicity code of the employee.
PETDEGR_EMPLOYEE_STATUS VARCHAR2 1 YES The status of the employee - Active, Terminated,
Leave, etc.
PETDEGR_EMPLOYEE_CLASS VARCHAR2 2 YES The employee class of the employee.
PETDEGR_EMPLOYEE_SKILL_CODE VARCHAR2 2 YES The primary skill code of the employee, based on
either the IPEDS report indicator, or for the primary
position.
PETDEGR_EMPLOYEE_GROUP VARCHAR2 4 YES Employee group of the employee.
PETDEGR_FAC_STAFF_IND VARCHAR2 1 YES Faculty or staff indicator (F or S), based on the
employee skill code.
PETDEGR_TIME_STATUS VARCHAR2 1 YES Full-time or part-time internal status indicator.
PETDEGR_AGE NUMBER YES Age of the employee.
PETDEGR_DEGREE_CODE VARCHAR2 6 YES Degree code for this degree.
PETDEGR_TERMINAL_DEGREE_IND VARCHAR2 1 YES Indicates if this degree is the terminal degree of the
employee (Y or N).
PETDEGR_MAJOR_CODE VARCHAR2 4 YES Major code for this degree (multiple records may exist
for the degree.)
PETDEGR_NUMBER_OF_DEGREES NUMBER YES Number of degrees the employee has.
PETDEGR_USER VARCHAR2 30 NO ID of the user who inserted or
updated the record most
recently.
PETDEGR_ACTIVITY_DATE DATE 7 NO Date the record was
inserted or updated.
Date: 21-JUN-2004 Page: 158
TABLE: PETEDIR
CREATOR: PAYROLL
Employee Directory Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETEDIR_PIDM NUMBER 8 NO Employee Pidm
PETEDIR_LAST_NAME VARCHAR2 60 NO LAST NAME: Employee's last name.
PETEDIR_FIRST_NAME VARCHAR2 15 NO FIRST NAME: Employee's first name.
PETEDIR_DISPLAY_ORGN_IND VARCHAR2 1 NO DISPLAY ORGN INDICATOR: D
isplay employee's
organization indicator Y or N.
PETEDIR_DISPLAY_TITLE_IND VARCHAR2 1 NO DISPLAY JOB TITLE INDICA
TOR: Display employee's job
title indicator Y or N.
PETEDIR_TELE_OFFICE_IND VARCHAR2 1 NO OFFICE TELEPHONE INDICATOR: Office telephone indicator
(Y)es/(N)o will be stored.
PETEDIR_TELE_PR_IND VARCHAR2 1 NO PERMANENT TELEPHONE INDICATOR: Permanent telephone
indicator (Y)es/(N)o will be stored.
PETEDIR_TELE_FAX_IND VARCHAR2 1 NO FAX CODE INDICATOR: Fax code.indicator (Y)es/(N)o will
be stored.
PETEDIR_EMAIL_IND VARCHAR2 1 NO EMAIL ADDRESS INDICATOR: Email address indicator
(Y)es/(N)o will be stored.
PETEDIR_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
PETEDIR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the PETEDIR table.
PETEDIR_MI VARCHAR2 15 YES MIDDLE NAME: Employee's middle name.
PETEDIR_PREF_FIRST_NAME VARCHAR2 15 YES PREFERRED FIRST NAME: Employee's preferred first name.
PETEDIR_NAME_PREFIX VARCHAR2 20 YES PREFIX OF NAME: Employee's name prefix such as Mr.,
Ms, etc.
PETEDIR_NAME_SUFFIX VARCHAR2 20 YES SUFFIX OF NAME: Employee's name suffix such as Jr, Sr,
etc.
PETEDIR_SEARCH_LAST_NAME VARCHAR2 60 YES SEARCH LAST NAME: Employee's last name search.
PETEDIR_SEARCH_FIRST_NAME VARCHAR2 15 YES SEARCH FIRST NAME: Employee's first name search.
PETEDIR_SOUNDEX_LAST_NAME CHAR 4 YES SEARCH SOUND INDEX LAST NAME: Employee's last name
sound index search.
PETEDIR_SOUNDEX_FIRST_NAME CHAR 4 YES SEARCH SOUND INDEX FIRST NAME: Employee's first name
sound index search.
PETEDIR_OFFICE_STREET_LINE1 VARCHAR2 30 YES OFFICE ADDRESS LINE 1: Office address first line.
PETEDIR_OFFICE_STREET_LINE2 VARCHAR2 30 YES OFFICE ADDRESS LINE 2: Office address second line.
PETEDIR_OFFICE_STREET_LINE3 VARCHAR2 30 YES OFFICE ADDRESS LINE 3: Office address third line.
PETEDIR_OFFICE_CITY VARCHAR2 20 YES OFFICE CITY: Office city name.
PETEDIR_OFFICE_STAT_CODE VARCHAR2 3 YES OFFICE STATE CODE: Office address state code.
PETEDIR_OFFICE_ZIP VARCHAR2 10 YES OFFICE ZIP CODE: Office address zip code.
PETEDIR_OFFICE_NATN_DESC VARCHAR2 30 YES OFFICE NATION: Office address country name.
PETEDIR_PR_STREET_LINE1 VARCHAR2 30 YES PERMANENT STREET ADDRESS 1: Permanent address first
line.
PETEDIR_PR_STREET_LINE2 VARCHAR2 30 YES PERMANENT STREET ADDRESS 2: Permanent address second
line.
PETEDIR_PR_STREET_LINE3 VARCHAR2 30 YES PERMANENT STREET ADDRESS 3: Permanent address third
line.
Date: 21-JUN-2004 Page: 159
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETEDIR_PR_CITY VARCHAR2 20 YES PERMANENT CITY: Permanent address city name
PETEDIR_PR_STAT_CODE VARCHAR2 3 YES PERMANENT STATE CODE: Permanent address state code
PETEDIR_PR_ZIP VARCHAR2 10 YES PERMANENT ZIP CODE: Permanent address zip code
PETEDIR_PR_NATN_DESC VARCHAR2 30 YES PERMANENT NATION: Permanent address country name.
PETEDIR_ADDR_ASOF_DATE DATE 7 YES ADDRESS AS OF DATE: Address as of date.
PETEDIR_EMP_PER_PAGE NUMBER 6 YES NUMBER OF EMPLOYEES PER PAGE: Number of employees per
web page.
Date: 21-JUN-2004 Page: 160
TABLE: PETJOBS
CREATOR: PAYROLL
Time Entry Temporary Jobs Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETJOBS_SESSION_ID VARCHAR2 30 NO SESSION ID: Oracle session ID.
PETJOBS_USER_ID VARCHAR2 30 NO USER ID: Oracle user ID.
PETJOBS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PETJOBS_SEQNO NUMBER 15 YES SEQUENCE NUMBER: Internal System Identification Number
for a time entry document.
PETJOBS_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PETJOBS_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
PETJOBS_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
PETJOBS_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET ORGANIZATION CHART OF ACCOUNTS CODE: BANNER
FINANCE system defined Chart of Accounts Code under
which the Time Sheet Department is created.
PETJOBS_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE.
PETJOBS_STATUS_IND VARCHAR2 1 YES STATUS: Indicates status of time sheet or leave
request.
PETJOBS_JOB_TITLE VARCHAR2 30 YES JOB TITLE.
PETJOBS_SHIFT VARCHAR2 1 YES JOB SHIFT.
PETJOBS_ECLS_CODE VARCHAR2 2 YES EMPLOYEE CLASS CODE: Employee Class Code.
PETJOBS_TIME_ENTRY_METHOD VARCHAR2 1 YES TIME ENTRY METHOD: Method of time entry; P = Payroll W
= Web D = Departmental T = Third Party.
PETJOBS_TIME_ENTRY_TYPE VARCHAR2 1 YES TIME ENTRY TYPE: Type of time reported; T = time sheet
E = exception time only.
PETJOBS_TIME_IN_OUT_IND VARCHAR2 1 YES TIME IN/OUT INDCATOR: Indicates that employee must
report time in and time out.
PETJOBS_ACAT_CODE VARCHAR2 6 YES APPROVAL CATEGORY CODE: Approval category.
PETJOBS_LCAT_CODE VARCHAR2 2 YES LEAVE CATEGORY CODE: A code identifies a group of
leave types (Leave Codes) which can be assigned to an
employee.
PETJOBS_SECURITY_IND VARCHAR2 1 YES
PETJOBS_JOBS_EFFECTIVE_DATE DATE 7 YES JOBS EFFECTIVE DATE: Effective date of job when the
status is Not Started.
Date: 21-JUN-2004 Page: 161
TABLE: PETJTLE
CREATOR: PAYROLL
Employee Job Title Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETJTLE_PIDM NUMBER 8 NO EMPLOYEE PIDM: System generated unique identification
number.
PETJTLE_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE: Employee's time sheet
organization code.
PETJTLE_CONTRACT_TYPE VARCHAR2 1 NO CONTRACT TYPE: Employee's job contract type.
PETJTLE_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
PETJTLE_ACTIVITY_DATE DATE 7 NO Activity Date: The date that the information for the
row was inserted or updated in the PETJTLE table.
PETJTLE_ORGN_TITLE VARCHAR2 35 YES ORGANIZATION DESCRIPTION: Employee's department
description.
PETJTLE_JOB_DESC VARCHAR2 30 YES JOB DESCRIPTION: Employee's job description.
Date: 21-JUN-2004 Page: 162
TABLE: PETTIME
CREATOR: PAYROLL
Time Entry Hours Breakdown Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETTIME_JOBS_SEQNO NUMBER 12 NO JOBS SEQUENCE NUMBER: Internal time entry sequence
number.
PETTIME_EARN_CODE VARCHAR2 3 NO EARN CODE: Earnings code.
PETTIME_SHIFT VARCHAR2 1 NO SHIFT: Shift associated with Earning Code.
PETTIME_SPECIAL_RATE NUMBER 12 6 NO SPECIAL RATE: Special rate for the earnings.
PETTIME_HRS_1 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_2 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_3 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_4 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_5 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_6 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_7 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_8 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_9 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_10 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_11 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_12 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_13 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_14 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_15 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_16 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_17 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_18 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_19 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_20 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
Date: 21-JUN-2004 Page: 163
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETTIME_HRS_21 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_22 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_23 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_24 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_25 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_26 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_27 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_28 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_29 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_30 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
PETTIME_HRS_31 NUMBER 6 2 YES HOURS: Number of hours associated with the Earning
Code.
Date: 21-JUN-2004 Page: 164
TABLE: PETWEMP
CREATOR: PAYROLL
temp table for Web for Executive Employee/Appointment profile extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETWEMP_SOURCE CHAR 1 YES Identifies the original source of the data.
PETWEMP_FISCAL_YEAR VARCHAR2 4 YES Fiscal year code (YYYY).
PETWEMP_FISCAL_PERIOD VARCHAR2 2 YES Fiscal period code, based on the HR fiscal year begin
date (assumes 12-period fiscal year.)
PETWEMP_PIDM NUMBER 8 NO Internal Identification Number of the person.
PETWEMP_YEARS_OF_SERVICE NUMBER YES Number of years worked in the institution.
PETWEMP_EMPLOYER VARCHAR2 4 YES Employer code for the employee.
PETWEMP_DIVISION VARCHAR2 3 YES Division code for the employee.
PETWEMP_CHART_CODE VARCHAR2 1 YES Chart of accounts code for the home organization of
the employee.
PETWEMP_DEPARTMENT VARCHAR2 6 YES Organization code for the home organization of the
employee.
PETWEMP_EMPLOYEE_GROUP VARCHAR2 4 YES Employee group of the employee.
PETWEMP_EMPLOYEE_STATUS VARCHAR2 1 YES The status of the employee - Active, Terminated,
Leave, etc.
PETWEMP_EMPLOYEE_CLASS VARCHAR2 2 YES The employee class of the employee.
PETWEMP_TIME_STATUS VARCHAR2 1 YES Full-time or part-time internal status indicator.
PETWEMP_GENDER_CODE VARCHAR2 1 YES Gender of the employee.
PETWEMP_ETHNIC_CODE VARCHAR2 2 YES Institutional ethnicity code of the employee.
PETWEMP_GOVT_ETHNIC_CODE VARCHAR2 1 YES Governmental ethnicity code of the employee.
PETWEMP_AGE NUMBER YES Age of the employee.
PETWEMP_TERMINAL_DEGREE VARCHAR2 6 YES Degree code of the terminal degree of the employee.
PETWEMP_NUMBER_OF_DEGREES NUMBER YES Number of degrees the employee has.
PETWEMP_HIGHEST_TENURE VARCHAR2 2 YES Highest tenure code for the employee.
PETWEMP_FACULTY_RANK VARCHAR2 2 YES Faculty rank of the employee.
PETWEMP_BENEFIT_CONTRIB NUMBER YES Cumulative benefit contribution made by the employer
for this employee for the fiscal year.
PETWEMP_LEAVE_VALUE NUMBER YES Value of the accrued leave for the employee, based on
the hourly rate of the primary position.
PETWEMP_JOB_EMPLOYER VARCHAR2 4 YES Employer code for this job.
PETWEMP_JOB_CHART_CODE VARCHAR2 1 YES Chart of accounts code for the time sheet organization
for this job.
PETWEMP_JOB_DEPARTMENT VARCHAR2 6 YES Organization code for the time sheet organization for
this job.
PETWEMP_JOB_EMPLOYEE_CLASS VARCHAR2 2 YES Employee class of this job.
PETWEMP_IPEDS_REPT_IND VARCHAR2 1 NO Indicates whether this job is reported to ipeds(Y or
N.)
PETWEMP_JOB_SKILL_CODE VARCHAR2 2 YES Skill Code for this job.
PETWEMP_JOB_FAC_STAFF_IND VARCHAR2 1 YES Faculty or staff indicator (F or S), based on the job
skill code.
PETWEMP_POSITION VARCHAR2 6 NO Position code for this job.
PETWEMP_SUFFIX VARCHAR2 2 NO Position suffix for this job.
PETWEMP_POSITION_CLASS VARCHAR2 5 NO Position class code for this job.
PETWEMP_JOB_STATUS VARCHAR2 1 YES Status code for this job - Active, Leave, Terminated,
etc.
Date: 21-JUN-2004 Page: 165
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PETWEMP_CONTRACT_TYPE VARCHAR2 1 NO Contract type code for this job - (P)rimary,
(S)econdary, or (O)verload.
PETWEMP_APPT_PERCENT NUMBER 5 2 YES Appointment percentage for this job.
PETWEMP_YEARS_IN_POSITION NUMBER YES Number of years the employee has been in this
position.
PETWEMP_ANNUAL_SALARY NUMBER 11 2 YES Annual Salary for this job.
PETWEMP_REGULAR_GROSS NUMBER YES Fiscal YTD gross pay for regular earnings.
PETWEMP_OVERTIME_GROSS NUMBER YES Fiscal YTD gross pay for overtime earnings.
PETWEMP_OTHER_GROSS NUMBER YES Fiscal YTD gross pay for other earnings.
PETWEMP_SALARY_FTE NUMBER YES FTE for this job if the job is salaried (otherwise
zero.)
PETWEMP_HOURLY_FTE NUMBER YES FTE for this job if the job is hourly (otherwise
zero.)
PETWEMP_ENCUMB_AMOUNT NUMBER 11 2 NO Encumbrance amount for this job.
PETWEMP_USER VARCHAR2 30 NO ID of the user who insert or modify the record most
recently.
PETWEMP_ACTIVITY_DATE DATE 7 NO Date the record was insertedor updated.
Date: 21-JUN-2004 Page: 166
TABLE: PHR1042
CREATOR: PAYROLL
1042 REPORTING TABLE
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHR1042_YEAR VARCHAR2 4 NO YEAR: The year associated with this 1042 record.
PHR1042_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The payroll
identification code of the pay event associated with
this 1042 record.
PHR1042_PAYNO NUMBER 3 NO PAYROLL NUMBER: The payroll number of the pay event
associated with this 1042 record.
PHR1042_PIDM NUMBER 8 NO PIDM: The internal ID number associated with this 1042
record.
PHR1042_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: The sequence number of the pay event
associated with this 1042 record.
PHR1042_EMPR_CODE VARCHAR2 4 NO EMPLOYER CODE: The employer code associated with this
1042 record.
PHR1042_INCOME_CD VARCHAR2 2 NO INCOME CODE: The code which identifies the type of
income received in association with this 1042 record.
PHR1042_COUNTRY_CD VARCHAR2 2 NO COUNTRY CODE: The code which identifies the country
for which tax treaty benefits and rates are based on
in association with this 1042 record.
PHR1042_TAX_RATE NUMBER 7 4 NO TAX RATE: The value which indentifies the tax rate on
which the withholding is calculated in association
with this 1042 record.
PHR1042_EXEMPTION_CD VARCHAR2 1 NO EXEMPTION CODE: Indicates a reason as to why these
dollars are exempt from taxation. 0=Not Exempt,
1=Income effectively connected with US trade or
business, 2=Exempt, 3=Income is non-US sourced, 4=No
withholding per treaty.
PHR1042_GRADUATED_TAX_IND VARCHAR2 1 NO GRADUATED TAX INDICATOR: Indicates whether the tax
rate associated with this 1042 record is graduated or
not.
PHR1042_GROSS_INCOME_PAID NUMBER 11 2 YES GROSS INCOME PAID: The total amount paid.
PHR1042_WITHHOLDING_ALLOW NUMBER 9 2 YES WITHHOLDING ALLOWANCE: The value which indentifies the
amount exempted from gross before the tax is
calculated in association with this 1042 record.
PHR1042_US_FEDERAL_TAX NUMBER 9 2 YES US FEDERAL TAX:
PHR1042_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: Date when the record was inserted or
last modified.
PHR1042_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: Benefit/Deduction Code in
Association with This 1042 Record.
PHR1042_ALLOWANCE_TAKEN NUMBER 9 2 YES ALLOWANCE AMOUNT TAKEN: The Value which Indentifies
the Amount Taken from Allowance in Association with
This 1042 Record.
PHR1042_INCOME_CD_SUB_TYPE VARCHAR2 1 YES INCOME CODE SUB TYPE: This field indicates income code
sub type associated with the income code.
Date: 21-JUN-2004 Page: 167
TABLE: PHRACCR
CREATOR: PAYROLL
Current Leave Accruals Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRACCR_YEAR VARCHAR2 4 NO YEAR: The year associated with the current pay period.
PHRACCR_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id associated
with the current pay period.
PHRACCR_PAYNO NUMBER 3 NO PAY NUMBER: The pay number associated with the current
payroll.
PHRACCR_PIDM NUMBER 8 NO PIDM; Internal ID number.
PHRACCR_LEAV_CODE VARCHAR2 4 NO LEAVE CODE: Leave Code being accrued/taken during the
pay period.
PHRACCR_CURR_ACCR NUMBER 6 2 YES CURRENT ACCRUAL: The number of hours accrued during
the current pay period.
PHRACCR_CURR_TAKEN NUMBER 6 2 YES CURRENT TAKEN: The number of hours taken during the
current pay period.
PHRACCR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PHRACCR_BANK_IND VARCHAR2 1 YES Indicates if hours accrued are to be banked.
PHRACCR_CALC_GEN_IND VARCHAR2 1 YES PHPCALC GENERATED IND: Contains value of Y when record
was generated by PHPCALC.
Date: 21-JUN-2004 Page: 168
TABLE: PHRATND
CREATOR: PAYROLL
Pay History Attendance Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRATND_YEAR VARCHAR2 4 NO Pay Period Year.
PHRATND_PICT_CODE VARCHAR2 2 NO Pay Period Payroll ID.
PHRATND_PAYNO NUMBER 3 NO Pay Period Pay Number.
PHRATND_COAS_CODE_TS VARCHAR2 1 YES Timesheet Chart of Accounts Code
PHRATND_ORGN_CODE_TS VARCHAR2 6 NO Timesheet Organization Code.
PHRATND_TS_ROSTER_IND VARCHAR2 1 NO Timesheet Roster Indicator.
PHRATND_PIDM NUMBER 8 NO Internal Person ID number.
PHRATND_POSN VARCHAR2 6 NO The Job Position Number.
PHRATND_SUFF VARCHAR2 2 NO Job Position Suffix.
PHRATND_EFFECTIVE_DATE DATE 7 NO The Effective date pulled from the associated PHRJOBS
record.
PHRATND_EARN_CODE VARCHAR2 3 NO The Earnings Code for which Attendance data is being
tracked.
PHRATND_ATND_DATE DATE 7 NO The Date of absence.
PHRATND_HOURS NUMBER 6 2 NO The number of hours the employee was absent on this
day.
PHRATND_LEAV_REASON VARCHAR2 30 YES Free form reason as to why the employee was absent.
PHRATND_ACTIVITY_DATE DATE 7 NO Date of the last activity (insert or update) on this
record.
Date: 21-JUN-2004 Page: 169
TABLE: PHRBKTP
CREATOR: PAYROLL
Payroll Bank Tape Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRBKTP_DOC_NO VARCHAR2 9 NO DOC NO: Document (check) number.
PHRBKTP_CHECK_DATE DATE 7 YES CHECK DATE: The date the check was issued.
PHRBKTP_BANK_PROC_DATE DATE 7 YES BANK PROC DATE: The date that the bank processed the
check
PHRBKTP_TAPE_DATE DATE 7 YES TAPE DATE: The date that the bank created the recon
tape.
PHRBKTP_AMT NUMBER 11 2 NO AMT: The amount that the check was cashed for.
PHRBKTP_DESC VARCHAR2 30 YES DESC: The payee of the check.
PHRBKTP_RECON_IND VARCHAR2 1 YES RECON IND: An (R) in this field indicates that the
check has been reconciled,
an (E) indicates that the
check numbers match but the amounts are in error,
a
(P) indicates that the bank paid a check that is not
recorded in BANNER.
PHRBKTP_RECON_DATE DATE 7 YES RECOCILED DATE: The Date the Check Was Reconciled.
PHRBKTP_INTERNAL_DOC_NO VARCHAR2 9 YES INTERNAL DOC NO: The document number attached by the
bank.
PHRBKTP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date on which this record was
created or updated
Date: 21-JUN-2004 Page: 170
TABLE: PHRDEDN
CREATOR: PAYROLL
Pay History Deduction Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRDEDN_YEAR VARCHAR2 4 NO YEAR; The year associated with this payroll.
PHRDEDN_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id code
associated with this payroll.
PHRDEDN_PAYNO NUMBER 3 NO PAYROLL NUMBER; The pay number associated with this
payroll.
PHRDEDN_PIDM NUMBER 8 NO PIDM: Internal ID number.
PHRDEDN_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER; The internal sequence number
associated with this pay event.
PHRDEDN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE; The effective date associated with the
deduction for this pay period.
PHRDEDN_STATUS VARCHAR2 1 NO STATUS OF THE DEDUCTION: Values (A)ctive, (W)aived,
and (T)erminated.
PHRDEDN_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CODE: History Benefit/Deduction
Code.
PHRDEDN_EMPLOYEE_AMT NUMBER 11 2 YES EMPLOYEE DEDUCTION AMOUNT.
PHRDEDN_EMPLOYER_AMT NUMBER 11 2 YES EMPLOYER DEDUCTION AMOUNT.
PHRDEDN_APPLICABLE_GROSS NUMBER 11 2 YES EMPLOYEE APPLICABLE GROSS AMOUNT.
PHRDEDN_ARREAR_TAKEN NUMBER 11 2 YES ARREARAGE TAKEN; The amount of arrearage generated
during this pay period.
PHRDEDN_ARREAR_RECOVERED NUMBER 11 2 YES ARREARAGE RECOVERED: The amount of arrearage recovered
this pay period.
PHRDEDN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PHRDEDN_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
Date: 21-JUN-2004 Page: 171
TABLE: PHRDIRD
CREATOR: PAYROLL
Direct Deposit table to hold amounts from tape
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRDIRD_YEAR VARCHAR2 4 NO PAY PERIOD YEAR.
PHRDIRD_PICT_CODE VARCHAR2 2 NO PAY PERIOD PAY ID CODE.
PHRDIRD_PAYNO NUMBER 3 NO PAY PERIOD PAY NUMBER.
PHRDIRD_COMPANY_NAME VARCHAR2 25 NO INSTITUTION NAME: Name of the Institution sending the
Direct Deposit Tape.
PHRDIRD_ITEM_CNT NUMBER 8 NO ITEM COUNT: Total Number of Direct Deposits in the Pay
Period.
PHRDIRD_DOLLAR_AMT NUMBER 12 2 NO DOLLAR AMOUNT: Total of all the direct deposit amounts
in the pay period.
PHRDIRD_HASH_TOTAL NUMBER 10 NO HASH TOTAL: Accumlation of TR/ABAs less the check
digit (position 4-11 only of detail 6 records),
excluding addenda records, in batch.
PHRDIRD_PAY_DATE DATE 7 NO PAY PERIOD CHECK DATE.
PHRDIRD_ACTIVITY_DATE DATE 7 NO ACTIVTY DATE: Date of last activity (insert or update)
on this record.
Date: 21-JUN-2004 Page: 172
TABLE: PHRDOCM
CREATOR: PAYROLL
Document Number Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRDOCM_YEAR VARCHAR2 4 NO YEAR: The year of the payroll that generated the
documents.
PHRDOCM_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id that generated
the document.
PHRDOCM_PAYNO NUMBER 3 NO PAYROLL NUMBER: The number of the payroll that
generated the document.
PHRDOCM_PIDM NUMBER 8 NO PIDM: Internal ID number.
PHRDOCM_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: The sequence number of this pay
event.
PHRDOCM_DOC_TYPE VARCHAR2 1 NO DOCUMENT TYPE; Indicates whether the document is a
check or a direct deposit notification.
PHRDOCM_PRIORITY NUMBER 2 NO PRIORITY: The sequence that the documents are
generated in.
PHRDOCM_DOC_NO VARCHAR2 9 NO DOCUMENT NUMBER: The check or direct deposit notice
number.
PHRDOCM_DOC_DATE DATE 7 NO DOCUMENT DATE: Date of the check or direct deposit
notification.
PHRDOCM_NET NUMBER 11 2 YES NET AMOUNT: The amount of the check or direct deposit.
PHRDOCM_BANK_CODE VARCHAR2 9 YES BANK CODE; Specifies the bank where the money is to be
deposited. This must be established on the GXADIRD
form.
PHRDOCM_BANK_ACCT_NO VARCHAR2 17 YES BANK ACCOUNT NUMBER: The bank account number for the
direct deposit.
PHRDOCM_ACCT_TYPE VARCHAR2 1 YES DIRECT DEPOSIT ACCOUNT TYPE: The type of account for
direct deposit (savings or checking).
PHRDOCM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PHRDOCM_RECON_IND VARCHAR2 1 YES RECON IND: Bank reconciliation indicator. When a
check is reconciled this
field will be valued with an
(R)
PHRDOCM_RECON_DATE DATE 7 YES RECON DATE: Reconciliation date. The date from the
bank statement on which
the check was reconciled.
PHRDOCM_REISSUE_IND VARCHAR2 1 NO Reissue Indicator: Indicates if this document should
be reissued.
Date: 21-JUN-2004 Page: 173
TABLE: PHREARN
CREATOR: PAYROLL
Pay History Earnings Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHREARN_YEAR VARCHAR2 4 NO YEAR: The year associated with the payroll.
PHREARN_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE.
PHREARN_PAYNO NUMBER 3 NO PAYROLL NUMBER: The number of the current payroll for
this pay id.
PHREARN_COAS_CODE_TS VARCHAR2 1 YES CHART OF ACCOUNTS CODE: BANNER FINANCE system defined
chart of accounts code under which the time sheet
department is defined.
PHREARN_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE.
PHREARN_TS_ROSTER_IND VARCHAR2 1 NO TIME SHEET/ROSTER INDICATOR: Indicates the type of
time reporting document is generated for this
employee.
PHREARN_PIDM NUMBER 8 NO PIDM: Internal person ID number.
PHREARN_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Sequence of pay event.
PHREARN_POSN VARCHAR2 6 NO POSITION: Position code associated with the earnings.
PHREARN_SUFF VARCHAR2 2 NO SUFFIX: The suffix associated with the position.
PHREARN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The effective date associated with the
assignment.
PHREARN_EARN_CODE VARCHAR2 3 NO History Earnings Code.
PHREARN_SHIFT VARCHAR2 1 NO SHIFT: Shift associated with Earning Code.
PHREARN_GEN_IND VARCHAR2 1 NO SYSTEM GENERATED INDICATOR: Used to indicate those
earnings that are generatedand may need to be
re-generated when processing a second time through
proof or calc.
PHREARN_HRS NUMBER 6 2 YES HOURS: Number of hours asssociated with the Earning
Code.
PHREARN_UPDATE_HRS NUMBER 6 2 YES UPDATED HOURS: Field used by the Leave Accrual Process
(phpprof) when determining dock pay.
PHREARN_RATE NUMBER 12 6 YES RATE: Rate of pay for this earnings code.
PHREARN_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: Contains rate if special rate is
required for the earnings code as defined on the
PTREARN rule form.
PHREARN_AMT NUMBER 12 2 YES AMOUNT: Amount Associated with the Earn Code.
PHREARN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PHREARN_TS_ENTRY_SEQ NUMBER 2 YES Earn Code Time Entry Sequence : Order in Which The
Earn Codes are displayed in PHAHOUR (Online Time Entry
Form).
PHREARN_TS_PRINT_SEQ NUMBER 2 YES Earn Code Print Sequence : Order in Which The Earn
Codes are printed on checks, timesheets and the
Payroll Register.
PHREARN_REDISTRIBUTION_IND VARCHAR2 1 YES REDISTRIBUTION INDICATOR: Indicates when earnings have
been redistributed.
PHREARN_DEEMED_HRS NUMBER 6 2 YES DEEMED HOURS: Reportable hours for Canadian Employment
Insurance.
PHREARN_ACCRUE_SENIORITY_IND VARCHAR2 1 NO ACCRUE SENIORITY INDICATOR:This indicator will denote
whether the earned hours will be included in the
seniority hours.
Date: 21-JUN-2004 Page: 174
TABLE: PHRELBD
CREATOR: PAYROLL
Pay History L/D Override Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRELBD_YEAR VARCHAR2 4 NO YEAR: The year associated with this payroll.
PHRELBD_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE:
PHRELBD_PAYNO NUMBER 3 NO PAYROLL NUMBER:
PHRELBD_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET CHART OF ACCOUNTS CODE: Chart of accounts
associated with the employees time sheet organization.
PHRELBD_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE:
PHRELBD_TS_ROSTER_IND VARCHAR2 1 NO TIME SHEET/ROSTER INDICATOR:
PHRELBD_PIDM NUMBER 8 NO PIDM: The internal ID number.
PHRELBD_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: The sequence number of this pay
event.
PHRELBD_POSN VARCHAR2 6 NO POSITION NUMBER: The position associated with the
earnings that this labor distribution applies to.
PHRELBD_SUFF VARCHAR2 2 NO SUFFIX: The suffix relating to the employees position.
PHRELBD_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The effective date of the job
assignment.
PHRELBD_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: The earnings code associated with this
set of labor distributions.
PHRELBD_SHIFT VARCHAR2 1 NO SHIFT CODE: The shift associated with the earnings
code.
PHRELBD_GEN_IND VARCHAR2 1 NO SYSTEM GENERATED INDICATOR : Values are (Y)es or (N)o.
PHRELBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Chart of accounts code as
defined on the BANNER Finance system.
PHRELBD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE; Index defined in the BANNER
Finance system.
PHRELBD_FUND_CODE VARCHAR2 6 YES FUND CODE: The Fund Code as defined in the BANNER
Finance system.
PHRELBD_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Code as defined in the BANNER
Finance system.
PHRELBD_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Account Code as defined in the BANNER
Finance system.
PHRELBD_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Program Code as defined in the BANNER
Finance system.
PHRELBD_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Activity Code as defined on the BANNER
Finance system.
PHRELBD_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location Code as defined in the BANNER
Finance system.
PHRELBD_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
PHRELBD_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
PHRELBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Full account number for use
when interfacing to a finance system other than BANNER
Finance.
PHRELBD_PERCENT NUMBER 5 2 NO LABOR DISTRIBUTION PERCENTAGE: The percentage of the
earnings code amount to be charged to this labor
distribution.
Date: 21-JUN-2004 Page: 175
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRELBD_HRS NUMBER 6 2 YES Hours : Number of Earnings Hours Associated With the
Labor Distribution.
PHRELBD_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE NUMBER: Encumbrance Number Associated with
the Labor Distribution.
PHRELBD_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE SEQUENCE NUMBER: Encumbrance Sequence
Number Associated with the Labor Distribution.
PHRELBD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PHRELBD_REDISTRIBUTION_AMT NUMBER 11 2 YES REDISTRIBUTION AMOUNT: Amount of redistributed
dollars.
Date: 21-JUN-2004 Page: 176
TABLE: PHRELBD_TEMP
CREATOR: PAYROLL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRELBD_YEAR VARCHAR2 4 YES
PHRELBD_PICT_CODE VARCHAR2 2 YES
PHRELBD_PAYNO NUMBER 3 YES
PHRELBD_COAS_CODE_TS VARCHAR2 1 YES
PHRELBD_ORGN_CODE_TS VARCHAR2 6 YES
PHRELBD_TS_ROSTER_IND VARCHAR2 1 YES
PHRELBD_PIDM NUMBER 8 YES
PHRELBD_SEQ_NO NUMBER 2 YES
PHRELBD_POSN VARCHAR2 6 YES
PHRELBD_SUFF VARCHAR2 2 YES
PHRELBD_EFFECTIVE_DATE DATE 7 YES
PHRELBD_EARN_CODE VARCHAR2 3 YES
PHRELBD_SHIFT VARCHAR2 1 YES
PHRELBD_GEN_IND VARCHAR2 1 YES
PHRELBD_COAS_CODE VARCHAR2 1 YES
PHRELBD_ACCI_CODE VARCHAR2 6 YES
PHRELBD_FUND_CODE VARCHAR2 6 YES
PHRELBD_ORGN_CODE VARCHAR2 6 YES
PHRELBD_ACCT_CODE VARCHAR2 6 YES
PHRELBD_PROG_CODE VARCHAR2 6 YES
PHRELBD_ACTV_CODE VARCHAR2 6 YES
PHRELBD_LOCN_CODE VARCHAR2 6 YES
PHRELBD_PROJ_CODE VARCHAR2 8 YES
PHRELBD_CTYP_CODE VARCHAR2 2 YES
PHRELBD_ACCT_CODE_EXTERNAL VARCHAR2 60 YES
PHRELBD_PERCENT NUMBER 5 2 YES
PHRELBD_HRS NUMBER 6 2 YES
PHRELBD_ENCD_NUM VARCHAR2 8 YES
PHRELBD_ENCD_SEQ_NUM NUMBER 4 YES
PHRELBD_ACTIVITY_DATE DATE 7 YES
PHRELBD_REDISTRIBUTION_AMT NUMBER 11 2 YES
Date: 21-JUN-2004 Page: 177
TABLE: PHRERRL
CREATOR: PAYROLL
Pay History Error Log Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRERRL_YEAR VARCHAR2 4 NO YEAR: Year associated with the payroll.
PHRERRL_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE:
PHRERRL_PAYNO NUMBER 3 NO PAYROLL NUMBER.
PHRERRL_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET CHART OF ACCOUNTS: Code defined on the
BANNER Finance system that is associated with this pay
event.
PHRERRL_ORGN_CODE_TS VARCHAR2 6 YES TIME SHEET ORGANIZATION CODE:
PHRERRL_TS_ROSTER_IND VARCHAR2 1 YES TIME SHEET/ROSTER INDICATOR: Indicates type of time
entry document is employedby this employee.
PHRERRL_PIDM NUMBER 8 NO PIDM: Internal ID number.
PHRERRL_SEQ_NO NUMBER 2 YES SEQUENCE NUMBER: The sequence of the pay event within
this pay id/payroll number.
PHRERRL_POSN VARCHAR2 6 YES POSITION NUMBER: Only on assignment or earnings code
errors.
PHRERRL_SUFF VARCHAR2 2 YES SUFFIX: The suffix of the job assignment in error.
PHRERRL_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: The effective date of the job
assignment in error. This will be null if it is a
deduction based error.
PHRERRL_STATUS VARCHAR2 1 YES STATUS: The status of the job assignment in error.
PHRERRL_ECLS_CODE VARCHAR2 2 YES EMPLOYEE CLASS CODE: The employee class on the
assignment in question. This will be null if it is a
deduction based error.
PHRERRL_DISP VARCHAR2 2 YES DISPOSITION: The disposition of the pay event.
PHRERRL_EARN_CODE VARCHAR2 3 YES EARN CODE: If the error relates to an earn code, it is
kept here. This will be null if the error is on a
deduction.
PHRERRL_BDCA_CODE VARCHAR2 3 YES BENEFIT/DEDUCTION CODE: The deduction code in error.
This will be null if theerror is associated with a job
or earnings.
PHRERRL_LEAV_CODE VARCHAR2 4 YES LEAVE CODE: Contains the leave code, for leave related
errors only.
PHRERRL_BASE_SAL_HRS NUMBER 6 2 YES BASE SALARY HOURS: The base salary hours associated
with the job assignment in error. This will be null
if the error is associated with a deduction.
PHRERRL_SALARY_RATE NUMBER 11 6 YES SALARY: Salary associated with the assignment in
error.
PHRERRL_PER_PAY_SALARY NUMBER 11 2 YES PER PAY PERIOD SALARY: Salary for assignment errors
only.
PHRERRL_CONTRACT_TYPE VARCHAR2 1 YES CONTRACT TYPE: The contract type associated with the
assignment in error. Thiswill be null for deduction
errors.
PHRERRL_ID_SEQ VARCHAR2 9 YES ID SEQUENCE: The ID of the person in error.
PHRERRL_LAST_NAME_SEQ VARCHAR2 30 YES LAST NAME:
PHRERRL_FIRST_NAME_SEQ VARCHAR2 15 YES EMPLOYEES FIRST NAME:
PHRERRL_SHIFT VARCHAR2 1 YES SHIFT CODE; Shift code associated with the earnings in
error.
Date: 21-JUN-2004 Page: 178
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRERRL_HRS NUMBER 6 2 YES HOURS: The number of hours on an erroneous earnings
code.
PHRERRL_UPDATE_HRS NUMBER 6 2 YES UPDATE HOURS: The number of hours associated with the
earnings code in error.
PHRERRL_RATE NUMBER 12 6 YES RATE OF PAY: Rate of pay associated with the
assignment in error.
PHRERRL_SPECIAL_RATE NUMBER 12 6 YES SPECIAL RATE: Associated with the earnings code in
error.
PHRERRL_AMT NUMBER 12 2 YES AMOUNT: The amount associated with the erroneous
record.
PHRERRL_ADJS_SEQ_NO NUMBER 2 YES SEQUENCE NUMBER: The sequence of the pay event.
PHRERRL_COMMENT VARCHAR2 100 YES COMMENT: A description of the error.
PHRERRL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date of last activity (insert or
update) on this record.
PHRERRL_TIME_ENTRY_ACTION_IND VARCHAR2 1 YES Time Entry Action: T = Time Sheet, R = Request Leave
PHRERRL_TIME_ENTRY_DATE DATE 7 YES Time Entry Date
Date: 21-JUN-2004 Page: 179
TABLE: PHRFLSA
CREATOR: PAYROLL
Fair Labor Standards Act Overtime reporting Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRFLSA_YEAR VARCHAR2 4 NO YEAR: The year associated with the payroll.
PHRFLSA_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id code
associated with this payroll.
PHRFLSA_PAYNO NUMBER 3 NO PAYROLL NUMBER: The pay number associated with this
payroll.
PHRFLSA_PIDM NUMBER 8 NO PIDM: Internal person ID number.
PHRFLSA_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Sequence Number Associated with FLSA
Work Period.
PHRFLSA_BEGIN_DATE DATE 7 NO BEGIN DATE: Date when the FLSA Work period began
PHRFLSA_END_DATE DATE 7 NO END DATE: Date when the FLSA Work period ends
PHRFLSA_PERIOD_MAX_NON_OT_HRS NUMBER 5 2 NO MAX NON OT HRS FOR THE PERIOD: The number of hours
beyond which the employee must be compensated for
working overtime
PHRFLSA_HRS_ADD NUMBER 6 2 YES FLSA HOURS ADD: Hours worked during FLSA Work Period.
PHRFLSA_HRS_REDUCE NUMBER 6 2 YES FLSA HOURS REDUCE: Reduces number of hours worked
during FLSA Work Period.
PHRFLSA_AMT_ADD NUMBER 11 2 YES FLSA DOLLARS REDUCE: Gross FLSA dollars that reduce
the FLSA dollars included in overtime rate
calculation.
PHRFLSA_AMT_REDUCE NUMBER 11 2 YES AMOUNT REDUCED: Gross FLSA Dollars that Reduce the
FLSA Dollars Included in Overtime Rate Calculation.
PHRFLSA_DAILY_OT_HRS NUMBER 6 2 YES FLSA DAILY OVERTIME HOURS: The number of hours over
the daily FLSA overtime threshold.
PHRFLSA_HRS_ACCRUED NUMBER 6 2 YES FLSA HOURS ACCRUED: The number of accrual hours
already compensated for.
PHRFLSA_CASH_PAID NUMBER 11 2 YES FLSA OVERTIME CASH PAID: The overtime dollar amount
already paid.
PHRFLSA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when record was inserted or last
modified.
Date: 21-JUN-2004 Page: 180
TABLE: PHRHIST
CREATOR: PAYROLL
Pay History Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRHIST_YEAR VARCHAR2 4 NO Year; The year of the payroll.
PHRHIST_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id of the event.
PHRHIST_PAYNO NUMBER 3 NO PAYROLL NUMBER: The pay number of the year for this
payroll.
PHRHIST_PIDM NUMBER 8 NO PIDM: Internal ID number.
PHRHIST_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: The sequence number of the event.
PHRHIST_DISP VARCHAR2 2 NO DISPOSITION: Indicates the status of this pay event
through the pay cycle.
PHRHIST_EVENT_DATE DATE 7 YES PAY EVENT DATE: The date on the checks or notices of
direct deposit. Or the date of the event when no
document is associated.
PHRHIST_GROSS NUMBER 11 2 YES GROSS AMOUNT: The total gross for the event.
PHRHIST_NET NUMBER 11 2 YES NET AMOUNT: The total net amount of the event.
PHRHIST_TYPE_IND VARCHAR2 1 NO TYPE INDICATOR: Indicates the type of pay event.
PHRHIST_CALC_IND VARCHAR2 1 NO CALCULATION INDICATOR: Indicates how this event was
calculated (manually or via the calc program).
PHRHIST_PRINT_IND VARCHAR2 1 NO PRINT INDICATOR: Indicates if the event was manually
printed outside of the system.
PHRHIST_ADJS_SEQ_NO NUMBER 2 YES ADJUSTS SEQUENCE NUMBER: The sequence number of the
pay event that this one adjusts.
PHRHIST_ADJS_DATE DATE 7 YES ADJUSTS DATE: The date of the pay event that this
event adjusts.
PHRHIST_ADJ_BY_SEQ_NO VARCHAR2 2 YES ADJUSTED BY SEQUENCE NUMBER: The sequence number of
the pay event that adjuststhis pay event.
PHRHIST_ADJ_BY_DATE DATE 7 YES ADJUSTED BY DATE: The date of the pay event that
adjusts this pay event.
PHRHIST_ASSOC_SEQ_NO NUMBER 2 YES ASSOCIATED SEQUENCE NUMBER: The sequence of the event
that corresponds to thisevent for two step
adjustments.
PHRHIST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (update or
insert) on this record.
PHRHIST_UI_WEEKS NUMBER 5 3 YES UI WEEKS: Unemployment Insurance insurable for this
pay period.
PHRHIST_UI_EXCEPTION_IND VARCHAR2 1 YES UNEMPLOYMENT EXCEPTION INDICATOR: (H)ourly, (M)aximum,
numbers, null can be accepted. This field is
associated with insurable earnings by pay period.
PHRHIST_UPDT_DATE DATE 7 YES UPDATE Date : The date that the phpupdt payroll
process was run for
supplemental pay or adjustments.
Used in Tax Reporting.
PHRHIST_POSTING_OVERRIDE_DATE DATE 7 YES POSTING OVERRIDE DATE: Finance Posting Override Date.
PHRHIST_USER_ID VARCHAR2 30 YES USER ID: User Identification Number.
PHRHIST_COMMENT VARCHAR2 2000 YES COMMENT: This field stores user comments
Date: 21-JUN-2004 Page: 181
TABLE: PHRHOUR
CREATOR: PAYROLL
Hour Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRHOUR_YEAR VARCHAR2 4 NO PAY PERIOD YEAR.
PHRHOUR_PICT_CODE VARCHAR2 2 NO PAY PERIOD PAY ID CODE.
PHRHOUR_PAYNO NUMBER 3 NO PAY PERIOD PAY NUMBER.
PHRHOUR_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PHRHOUR_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Unique sequence number for the each
begin date of daily or weekly.
PHRHOUR_POSN VARCHAR2 6 NO POSITION NUMBER: Position associated with the history
earnings code.
PHRHOUR_SUFF VARCHAR2 2 NO SUFFIX: Suffix attached to the position number.
PHRHOUR_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date on which the history earnings
record becomes effective.
PHRHOUR_EARN_CODE VARCHAR2 3 NO HOUR EARN CODE: History Earnings Code.
PHRHOUR_SHIFT VARCHAR2 1 NO Shift Associated with Earnings Code.
PHRHOUR_BEGIN_DATE DATE 7 NO HOUR BEGIN DATE: Begin date of the daily or weekly.
PHRHOUR_END_DATE DATE 7 NO END DATE: End date of daily or weekly.
PHRHOUR_HRS NUMBER 6 2 YES HOURS: Number of hours for daily or weekly period.
PHRHOUR_AMT NUMBER 12 2 YES HOUR AMOUNT: Daily or Weekly pay for this pay period
when (D)aily or (W)eekly is entered in Time Entry
Indicator in the PTRPICT form.
PHRHOUR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PHRHOUR_GEN_IND VARCHAR2 1 NO System Generated Indicator : Values are (Y)es or (N)o.
Date: 21-JUN-2004 Page: 182
TABLE: PHRJACR
CREATOR: PAYROLL
Current Leave Accruals by Jobs Repeating Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRJACR_YEAR VARCHAR2 4 NO YEAR: The year associated with the current pay period.
PHRJACR_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id associated
with the current pay period
PHRJACR_PAYNO NUMBER 3 NO PAY NUMBER: The pay number associated with the current
payroll.
PHRJACR_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PHRJACR_POSN VARCHAR2 6 NO POSITION: Position Number of the Assignment.
PHRJACR_SUFF VARCHAR2 2 NO SUFFIX: Suffix of the Assignment.
PHRJACR_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The effective date associated with the
leave by job record.
PHRJACR_LEAV_CODE VARCHAR2 4 NO LEAVE CODE: The code identifying which type of leave
it is. The code must be previously defined on the
Leave Codes Rule Form (PTRLEAV).
PHRJACR_CALC_GEN_IND VARCHAR2 1 NO PHPCALC GENERATED IND: Contains value of Y when record
was generated by PHPCALC.
PHRJACR_BANK_IND VARCHAR2 1 NO Indicates if hours accrued are to be banked.
PHRJACR_USER_ID VARCHAR2 30 NO The unique identification of the user who changed the
record.
PHRJACR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PHRJACR_CURR_ACCR NUMBER 6 2 YES CURRENT ACCRUAL: The number of hours accrued during
the current pay period.
PHRJACR_CURR_TAKEN NUMBER 6 2 YES CURRENT TAKEN: The number of hours taken during the
current pay period.
PHRJACR_MAX_HRS NUMBER 6 2 YES The maximum leave hours an employee will be allowed to
take.
Date: 21-JUN-2004 Page: 183
TABLE: PHRJOBS
CREATOR: PAYROLL
Pay History Jobs Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRJOBS_YEAR VARCHAR2 4 NO PAY PERIOD YEAR.
PHRJOBS_PICT_CODE VARCHAR2 2 NO PAY PERIOD PAY ID CODE.
PHRJOBS_PAYNO NUMBER 3 NO PAY PERIOD PAYROLL NUMBER.
PHRJOBS_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET ORGANIZATION CHART OF ACCOUNTS CODE: BANNER
FINANCE system defined Chart of Accounts Code under
which the Time Sheet Department is created.
PHRJOBS_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE.
PHRJOBS_TS_ROSTER_IND VARCHAR2 1 NO TIME SHEET ROSTER INDICATOR: Values (T)ime Sheet;
(R)oster; (O)rganizational Thime Sheet.
PHRJOBS_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PHRJOBS_SEQ_NO NUMBER 2 NO PAY PERIOD EVENT SEQUENCE: Value 0 implies Computer
Generated Event; Values > 0 imply Adjustments.
PHRJOBS_POSN VARCHAR2 6 NO Position Number of the Assignment.
PHRJOBS_SUFF VARCHAR2 2 NO Suffix of the Assignment.
PHRJOBS_EFFECTIVE_DATE DATE 7 NO Effective Date for the Assignment.
PHRJOBS_STATUS VARCHAR2 1 NO Status of the Assignment.
PHRJOBS_ECLS_CODE VARCHAR2 2 NO Employee Class Code.
PHRJOBS_BASE_SAL_HRS NUMBER 6 2 YES BASE SALARY HOURS: Regular hours worked during the Pay
Period.
PHRJOBS_SALARY_RATE NUMBER 11 6 NO Rate of Pay for the Assignment.
PHRJOBS_PER_PAY_SALARY NUMBER 11 2 NO PER PAY SALARY: Salary paid each pay period. Used for
defer pay calculations.Amount Deferred = Assignment
Salary - Per Pay Salary.
PHRJOBS_APPT_PCT NUMBER 5 2 NO APPOINTMENT PERCENT: Percentage of Full Time
Appointment. This percentage is applied to leave
accruals and when defaulting the salary from the
Salary Rule Form (NTRSALA).
PHRJOBS_DEFER_AMT NUMBER 11 2 YES DEFER AMOUNT: Amount of Money Defferred each pay
period.
PHRJOBS_CONTRACT_TYPE VARCHAR2 1 NO CONTRACT TYPE: Job Contract Type. Values (P)rimary;
(S)econdary; (O)verload.
PHRJOBS_SHIFT VARCHAR2 1 NO JOB SHIFT: Shift associated with the job.
PHRJOBS_PAY_CNT NUMBER 3 YES HISTORY PAY COUNT: Number of times the employee has
been paid for this pay Id.
PHRJOBS_DISP VARCHAR2 2 NO PAYROLL DISPOSITION: Indicates the level of processing
a row has attained during the payroll run.
PHRJOBS_ID_SEQ VARCHAR2 9 NO Personal Identification Number.
PHRJOBS_LAST_NAME_SEQ VARCHAR2 30 NO LAST NAME: Last Name of the Employee.
PHRJOBS_FIRST_NAME_SEQ VARCHAR2 15 NO FIRST NAME: First Name of the Employee.
PHRJOBS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PHRJOBS_EMPR_CODE VARCHAR2 4 NO EMPR_CODE: The Employer Identification Code.
PHRJOBS_LGCD_CODE VARCHAR2 4 YES LONGEVITY CODE: Longevity Code.
PHRJOBS_TIME_ENTRY_IND VARCHAR2 1 YES Time Entry Indicator: Values (P)ay Period, (F)LSA,
(W)eekly, (D)aily.
Date: 21-JUN-2004 Page: 184
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRJOBS_EFFECTIVE_UNTIL_DATE DATE 7 YES EFFECTIVE UNTIL DATE: The date until which this
history jobs record is effective.
PHRJOBS_PCAT_CODE VARCHAR2 4 YES Premium Pay Category Code: Controls premium pay
generation.
PHRJOBS_STRS_CONT_CODE VARCHAR2 2 YES STRS CONTRIBUTION CODE:
STRS Contribution Code for the
employee.
PHRJOBS_PERS_CONT_CODE VARCHAR2 2 YES PERS CONTRIBUTION CODE:
PERS Contribution Code for the
employee.
PHRJOBS_STRS_ASSN_CODE VARCHAR2 2 YES STRS ASSIGNMENT CODE:
STRS Assignment Code for the
employee.
PHRJOBS_STRS_PAY_CODE VARCHAR2 2 YES STRS PAY CODE:
STRS Pay Code for the employee.
PHRJOBS_PERS_PAY_CODE VARCHAR2 2 YES PERS PAY CODE:
PERS Pay Code for the employee.
PHRJOBS_FULL_ASSGN_SALARY NUMBER 11 2 YES FULL ASSIGN SALARY:
Full assign salary for the
employee for the effective date for the job.
PHRJOBS_PREV_FISCAL_YEAR_IND VARCHAR2 1 YES PREVIOUS FISCAL YEAR INDICATOR:
Previous Fiscal Year
Indicator if the retro earnings paid are for the
previous fiscal year.
PHRJOBS_LCAT_CODE VARCHAR2 2 YES Leave Category Code: A code which identifies a group
of leave types.
PHRJOBS_FTE NUMBER 6 3 YES FULL TIME EQUIVALENCY: The full time equivalency
percentage assigned to this job.
PHRJOBS_HRS_DAY NUMBER 6 2 YES HOURS PER DAY: The number of hours an employee filling
this job normally works in a day.
Date: 21-JUN-2004 Page: 185
TABLE: PHRMTIM
CREATOR: PAYROLL
Mass Time Entry Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRMTIM_YEAR VARCHAR2 4 NO YEAR: The year associated with the payroll.
PHRMTIM_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE: The pay id code
associated with this payroll.
PHRMTIM_PAYNO NUMBER 3 NO PAYROLL NUMBER: The pay number associated with this
payroll.
PHRMTIM_ID VARCHAR2 9 NO ID: This field defines the identification number used
to access a person
on-line.
PHRMTIM_POSN VARCHAR2 6 YES POSITION: Position code associated with the earnings.
PHRMTIM_SUFF VARCHAR2 2 YES SUFFIX: The suffix associated with the position.
PHRMTIM_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: The effective date associated with the
assignment.
PHRMTIM_EARN_CODE VARCHAR2 3 YES EARN CODE: History earnings code.
PHRMTIM_SHIFT VARCHAR2 1 YES SHIFT: Shift associated with earnings code.
PHRMTIM_BEGIN_DATE DATE 7 NO BEGIN DATE: Begin date of the number of hours for the
earnings code.
PHRMTIM_END_DATE DATE 7 YES END DATE: End date of the number of hours for the
earnings code.
PHRMTIM_SPECIAL_RATE NUMBER 12 6 YES RATE: Special rate of pay for this earnings code.
PHRMTIM_HRS NUMBER 6 2 YES HOURS: Number of hours associated with this earnings
code.
PHRMTIM_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Valued only if Banner Finance
is installed.
PHRMTIM_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX: Valued only if Banner Finance is
installed.
PHRMTIM_FUND_CODE VARCHAR2 6 YES FUND: Valued only if Banner Finance is installed.
PHRMTIM_ORGN_CODE VARCHAR2 6 YES ORGANIZATION: Valued only if Banner Finance is
installed.
PHRMTIM_ACCT_CODE VARCHAR2 6 YES ACCOUNT: Valued only if Banner Finance is installed.
PHRMTIM_PROG_CODE VARCHAR2 6 YES PROGRAM: Valued only if Banner Finance is installed.
PHRMTIM_ACTV_CODE VARCHAR2 6 YES ACTIVITY: Valued only if Banner Finance is installed.
PHRMTIM_LOCN_CODE VARCHAR2 6 YES LOCATION: Valued only if Banner Finance is installed.
PHRMTIM_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT: Free form account code to allow
update of an accounting
system other than Banner
Finance.
PHRMTIM_PERCENT NUMBER 5 2 YES PERCENT: Percent of pay to be applied to this labor
distribution.
PHRMTIM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when record was inserted or last
modified.
PHRMTIM_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
PHRMTIM_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
PHRMTIM_CHANGE_IND VARCHAR2 1 NO RECORD CHANGED INDICATOR: Values (N)ot changed; (Y)New
Record; (D)eleted; (O)ld Record (C)hanged Record.
PHRMTIM_DEEMED_HRS NUMBER 6 2 YES DEEMED HOURS: Reportable hours for Canadian Employment
Insurance.
Date: 21-JUN-2004 Page: 186
TABLE: PHRPENS
CREATOR: PAYROLL
California STRS/PERS Pension Contribution Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRPENS_YEAR VARCHAR2 4 NO YEAR: Calendar year of current pay event.
PHRPENS_PICT_CODE VARCHAR2 2 NO PICT CODE: Pay ID of current pay event.
PHRPENS_PAYNO NUMBER 3 NO PAY NUMBER: Pay number of current pay event.
PHRPENS_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Sequence number of current pay event.
PHRPENS_PIDM NUMBER 8 NO PIDM: Internal ID number.
PHRPENS_BDCA_CODE VARCHAR2 3 YES PENSION DEDUCTION CODE: A code
identifying pension
deduction.
PHRPENS_EMPL_CONT_RATE NUMBER 11 6 YES EMPLOYEE CONTRIBUTION RATE:
Employee contribution
rate.
PHRPENS_EMPR_CONT_RATE NUMBER 11 6 YES EMPLOYER CONTRIBUTION RATE:
Employer contribution
rate.
PHRPENS_POSN VARCHAR2 6 YES POSITION: Employee position number.
PHRPENS_SUFF VARCHAR2 2 YES SUFFIX: Employee suffix number.
PHRPENS_GROUP VARCHAR2 5 YES GROUP: Employee group or assignment code.
PHRPENS_ELIGIBLE_GRS NUMBER 11 2 YES ELIGIBLE GROSS: Eligible earnings.
PHRPENS_PAY_RATE NUMBER 11 6 YES PAY RATE: Rate to be reported by position.
PHRPENS_PAY_CODE VARCHAR2 2 YES PAY CODE: Pay code.
PHRPENS_CONT_CODE VARCHAR2 2 YES CONTRIBUTION CODE: Type of contribution.
PHRPENS_CALC_EMPL_AMT NUMBER 11 2 YES CALCULATED EMPLOYEE AMOUNT: Calculated employee
amount.
PHRPENS_CALC_EMPR_AMT NUMBER 11 2 YES CALCULATED EMPLOYER AMOUNT:
Calculated employer
amount.
PHRPENS_PENS_HOURS NUMBER 6 3 YES PENSION HOURS: Pension hours
for position.
PHRPENS_CALC_FTE NUMBER 10 8 YES CALCILATED FTE: Calculated FTE.
PHRPENS_USERID VARCHAR2 30 NO USER ID: User or process that
updated record.
PHRPENS_REPORT_IND VARCHAR2 1 NO REPORT INDICATOR: Indicates if this
deduction was
reported.
PHRPENS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of the action
was initiated.
PHRPENS_RETRO_PREV_FISC_IND VARCHAR2 1 YES RETRO PREVIOUS FISCAL YEAR IND: Retro previous fiscal
year indicator.
PHRPENS_PRETAX_IND VARCHAR2 1 YES STRS/PERS employee pretax deduction indicator
PHRPENS_SERVICE_BEGIN_DATE DATE 7 YES SERVICE BEGIN DATE: Reporting Service Begin Date
associated with Retro Deduction type.
PHRPENS_SERVICE_END_DATE DATE 7 YES SERVICE END DATE: Reporting Service End Date
associated with Retro Deduction type.
Date: 21-JUN-2004 Page: 187
TABLE: PHRREDS
CREATOR: PAYROLL
Payroll Labor Redistribution work table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRREDS_USER_ID VARCHAR2 30 NO USER ID: BANNER login user ID.
PHRREDS_SESSION_ID VARCHAR2 30 NO SESSION ID: BANNER session id.
PHRREDS_TYPE VARCHAR2 1 NO TYPE: Indicates whether the labor distribution is old,
new, or is a key.
PHRREDS_YEAR VARCHAR2 4 NO YEAR: The year associated with this payroll.
PHRREDS_PICT_CODE VARCHAR2 2 NO PAYROLL IDENTIFICATION CODE:
PHRREDS_PAYNO NUMBER 3 NO PAYROLL NUMBER:
PHRREDS_PIDM NUMBER 8 NO PIDM: The internal ID number.
PHRREDS_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: The sequence number of this pay
event.
PHRREDS_POSN VARCHAR2 6 NO POSITION NUMBER: The position associated with the
earnings that this labor distribution applies to.
PHRREDS_SUFF VARCHAR2 2 NO SUFFIX: The suffix relating to the employees position.
PHRREDS_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: The effective date of the job
assignment.
PHRREDS_EARN_CODE VARCHAR2 3 NO EARNINGS CODE: The earnings code associated with this
set of labor distributions.
PHRREDS_SHIFT VARCHAR2 1 NO SHIFT CODE: The shift associated with the earnings
code.
PHRREDS_GEN_IND VARCHAR2 1 NO SYSTEM GENERATED INDICATOR : Values are (Y)es or (N)o.
PHRREDS_COAS_CODE_TS VARCHAR2 1 YES TIME SHEET CHART OF ACCOUNTS CODE: Chart of accounts
associated with the employees time sheet organization.
PHRREDS_ORGN_CODE_TS VARCHAR2 6 NO TIME SHEET ORGANIZATION CODE:
PHRREDS_TS_ROSTER_IND VARCHAR2 1 NO TIME SHEET/ROSTER INDICATOR:
PHRREDS_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Chart of accounts code as
defined on the BANNER Finance system.
PHRREDS_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE; Index defined in the BANNER
Finance system.
PHRREDS_FUND_CODE VARCHAR2 6 YES FUND CODE: The Fund Code as defined in the BANNER
Finance system.
PHRREDS_ORGN_CODE VARCHAR2 6 YES ORGANIZATION CODE: Code as defined in the BANNER
Finance system.
PHRREDS_ACCT_CODE VARCHAR2 6 YES ACCOUNT CODE: Account Code as defined in the BANNER
Finance system.
PHRREDS_PROG_CODE VARCHAR2 6 YES PROGRAM CODE: Program Code as defined in the BANNER
Finance system.
PHRREDS_ACTV_CODE VARCHAR2 6 YES ACTIVITY CODE: Activity Code as defined on the BANNER
Finance system.
PHRREDS_LOCN_CODE VARCHAR2 6 YES LOCATION CODE: Location Code as defined in the BANNER
Finance system.
PHRREDS_PROJ_CODE VARCHAR2 8 YES PROJECT CODE: Project within Finance Cost Accounting
Module.
PHRREDS_CTYP_CODE VARCHAR2 2 YES COST TYPE CODE: Cost Type within Finance Cost
Accounting Module.
PHRREDS_ACCT_CODE_EXTERNAL VARCHAR2 60 YES EXTERNAL ACCOUNT CODE: Full account number for use
when interfacing to a finance system other than BANNER
Finance.
Date: 21-JUN-2004 Page: 188
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRREDS_PERCENT NUMBER 5 2 NO LABOR DISTRIBUTION PERCENTAGE: The percentage of the
earnings code amount to be charged to this labor
distribution.
PHRREDS_HRS NUMBER 6 2 YES Hours : Number of Earnings Hours Associated With the
Labor Distribution.
PHRREDS_ENCD_NUM VARCHAR2 8 YES ENCUMBRANCE NUMBER: Encumbrance Number.
PHRREDS_ENCD_SEQ_NUM NUMBER 4 YES ENCUMBRANCE SEQUENCE NUMBER: Encumbrance Sequence
Number.
PHRREDS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity (insert or
update) on this record.
PHRREDS_REDISTRIBUTION_AMT NUMBER 11 2 YES REDISTRIBUTION AMOUNT: Amount of redistributed
dollars.
PHRREDS_STATUS VARCHAR2 1 YES STATUS: Indicates whether the Labor Distribution is
Erased, Approved, or Changed.
Date: 21-JUN-2004 Page: 189
TABLE: PHRTDED
CREATOR: PAYROLL
Temporary Deduction Table For Check/Direct Deposit Process
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRTDED_YEAR VARCHAR2 4 NO PAY PERIOD YEAR.
PHRTDED_PICT_CODE VARCHAR2 2 NO PAY PERIOD PAY ID CODE.
PHRTDED_PAYNO NUMBER 3 NO PAY PERIOD PAY NUMBER.
PHRTDED_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PHRTDED_BDCA_CODE VARCHAR2 3 NO BENEFIT/DEDUCTION CATEGORY CODE.
PHRTDED_DESC VARCHAR2 8 YES DEDUCTION DESCRIPTION.
PHRTDED_DEDN_AMT NUMBER 11 2 YES DEDUCTION AMOUNT.
PHRTDED_DEDN_YTD NUMBER 11 2 YES DEDUCTION YEAR TO DATE.
PHRTDED_PRIORITY NUMBER 2 YES PRIORITY CODE: The priority code indicates the order
in which the deduction should be processed. For
example, it is important that a deduction which is
exempt from taxes, such as a 401K contribution, be
calculated before the tax.
PHRTDED_SEQ_NO NUMBER 2 YES SEQUENCE NUMBER: Sequence Number.
Date: 21-JUN-2004 Page: 190
TABLE: PHRTERN
CREATOR: PAYROLL
Temporary Table To Implement Roster and Organizational Time Sheet Reports
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRTERN_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PHRTERN_POSN VARCHAR2 6 NO POSITION: Position Number.
PHRTERN_SUFF VARCHAR2 2 NO SUFFIX: Suffix attached to the position.
PHRTERN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Date the record becomes effective.
PHRTERN_SESSIONID VARCHAR2 30 NO SESSION ID: Unique ORACLE defined Session
Identification Number.
PHRTERN_EARN_CODE VARCHAR2 3 YES EARN CODE: System defined code to identify earnings.
PHRTERN_HRS NUMBER 6 2 YES HOURS: Hours associated with the earn code.
PHRTERN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
PHRTERN_SHIFT VARCHAR2 1 YES SHIFT: Earnings Shift
PHRTERN_WKSH_IND VARCHAR2 1 YES WORK SCHEDULE INDICATOR: Values (Y)es, Employee's Job
has a Work Schedule, (N)o, it does not.
PHRTERN_HOL_CNT NUMBER 3 YES HOLIDAY COUNT: Number of Holidays in Pay Period.
Date: 21-JUN-2004 Page: 191
TABLE: PHRTHRS
CREATOR: PAYROLL
Temporary Table To Implement Work Schedules.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRTHRS_SESSIONID VARCHAR2 30 NO SESSION ID: Unique ORACLE defined Session
Identification Number.
PHRTHRS_PIDM NUMBER 8 NO PIDM: Internal System Identification Number.
PHRTHRS_POSN VARCHAR2 6 NO POSITION: Position Number.
PHRTHRS_SUFF VARCHAR2 2 NO SUFFIX: Suffix attached to the position.
PHRTHRS_PAY_PERIOD_DATE DATE 7 NO PAY PERIOD DATE: Each day in the pay period.
PHRTHRS_HRS NUMBER 6 2 YES HOURS: Hours worked during the pay period date.
PHRTHRS_SHIFT VARCHAR2 1 YES SHIFT: Shift for which the Hours were worked during
the pay period date.
PHRTHRS_WKSH_IND VARCHAR2 1 YES WORK SCHEDULE IND: (Y)es Person has work schedule,
(N)o, person has no work schedule.
PHRTHRS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date when the record was inserted or
last modified.
Date: 21-JUN-2004 Page: 192
TABLE: PHRTLBD
CREATOR: PAYROLL
Temporary History Labor Distributions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PHRTLBD_PIDM NUMBER 8 NO PIDM: Internal person identification number.
PHRTLBD_POSN VARCHAR2 6 NO POSITION: The position code associated with the
earnings that this labor distribution applies to.
PHRTLBD_SUFF VARCHAR2 2 NO SUFFIX: The suffix relating to the employee's
position.
PHRTLBD_ECLS_CODE VARCHAR2 2 YES EMPLOYEE CLASS CODE: Employee class associated with
this labor distribution record.
PHRTLBD_COAS_CODE VARCHAR2 1 YES CHART OF ACCOUNTS CODE: Chart of accounts code as
defined by the Banner Finance system.
PHRTLBD_ACCI_CODE VARCHAR2 6 YES ACCOUNT INDEX CODE: Index defined in the BANNER
Finance system.
PHRTLBD_FUND_CODE VARCHAR2 6