PR_EmployeeDocuments PR Employee Documents Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PR_EmployeeDocuments_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/PR"+%C$+"/PR_EmployeeDocuments.M4T"
KPRIMARY: DepartmentNo+EmployeeNo kEMPLOYEEPASSWORD: DocumentPassword(**)+DepartmentNo+EmployeeNo **=Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 DepartmentNo. . . . . . . . . 2 SYY Department Number . . . . . . .DEPARTMENT Mask:00 2 EmployeeNo. . . . . . . . . . 7 SYY Employee Number . . . . . . . .EMPLOYEENO FmtType:MASTERNUM 3 Document. . . . . . . . . . . 30 SYY Document Name . . . . . . . . . 4 PrintDocument . . . . . . . . 1 SYN Print Document. . . . . . . . .YESNO DfltVal:Y Valid:Y,N 5 EmailDocument . . . . . . . . 1 SYN Email Document. . . . . . . . .YESNO DfltVal:N Valid:Y,N 6 DocumentPassword. . . . . . . 33 SNY Document Password . . . . . . . 7 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .EMAILADDRESS 8 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE 9 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . . 10 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER Mask:0000000000 11 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE 12 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . 13 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER Mask:0000000000