C6HOUSERNT

UPDATED BY
BN66.1 PR140 PR189 PR195 PR197 PR80.1
PR80.4 PR89.1 PRAT.1 PR141 PR139

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
C6H-COMPANY
Element: Company Hr
Numeric 4
C6H-PAYROLL-YEAR
Element: Payroll Year
Numeric 4
C6H-EMPLOYEE
Element: Employee
Numeric 9
C6H-PRD-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
C6H-PRD-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
C6H-RENT-PAID-FROM
Element: Start Date
Numeric 8 (yyyymmdd)
C6H-RENT-PAID-TO
Element: End Date
Numeric 8 (yyyymmdd)
C6H-ACT-RENT-PAID
Element: Amount Ytd
Signed 13.2
C6H-PAID-MET-CITY
Element: Flag
Alpha 1
C6H-RENT-FROM
Element: Start Date
Numeric 8 (yyyymmdd)
C6H-RENT-TO
Element: End Date
Numeric 8 (yyyymmdd)
C6H-RENT-PER-MNTH
Element: Amount Ytd
Signed 13.2
C6H-RENT-MET-CITY
Element: Flag
Alpha 1
C6H-RENT-PAN
Element: Fica Nbr
Alpha 20
C6H-PROC-STATUS
Element: Flag
Alpha 1
BN66.1 PR140
PR189 PR195
PR197 PR80.1
PR80.4 PR89.1
PRAT.1
C6H-APPROVE-FLG
Element: Approve Flg
Alpha 1
C6H-REQUEST-AMT
Element: Request Amt
Signed 13.2
C6H-APPROVED-AMT
Element: Approved Amt
Signed 13.2
C6H-C6H-SEQ-NBR
Element: Seq Nbr
Numeric 4
C6H-USER-FLAG
Element: Flag Num
Numeric 1

0 = No
1 = Yes
C6H-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
C6H-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
C6H-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
C6H-USER-ID
Element: User
Alpha 10 (Lower Case)
C6H-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
C6H-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)


C6HOUSERNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
C6HSET1 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
C6H-SEQ-NBR
BN66.1 PR140
PR141 PR189
PR195 PR197
PR80.1 PR80.4
PR89.1 PRAT.1
C6HSET2 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
C6H-SEQ-NBR
Subset
WhereAPPROVE-FLG ="Y"
C6HSET3 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
C6H-SEQ-NBR
Subset
WhereAPPROVE-FLG ="N"
C6HSET4 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
C6H-SEQ-NBR
Subset
WhereAPPROVE-FLG ="R"
C6HSET5 COMPANY
PAYROLL-YEAR
EMPLOYEE
PRD-START-DATE*
C6H-SEQ-NBR*
BN66.1 PR139
PR140 PR189
PR195 PR80.1
PR80.4 PR89.1
PRAT.1


C6HOUSERNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
C6H-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
C6H-COMPANY->EMP-COMPANY
C6H-EMPLOYEE->EMP-EMPLOYEE


File created: Thu Jun 09 02:11:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.