HR_DR_CONTROL

(SQL Table)
Index Back

Direct Reports Control Table

Direct Reports Tables Loaded Control Table. The values in this table are set to yes when the corresponding Direct Reports table is loaded successfully.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HR_DR_READY_2 Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the HR_DIRECT_REP_2 table is loaded.
2 HR_DR2BLD_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
3 HR_DR_READY_3 Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the HR_DIRECT_REP_3 table is loaded.
4 HR_DR3BLD_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last build of the table
5 HR_DR_READY_4 Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the HR_DIRECT_REP_4 table is loaded.
6 HR_DR4BLD_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last build of the table
7 HR_DR_READY_5 Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the HR_DIRECT_REP_5 table is loaded.
8 HR_DR5BLD_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last build of the table
9 HR_DR_READY_6 Character(1) VARCHAR2(1) NOT NULL Y/N field to determine if the HR_DIRECT_REP_6 table is loaded.
10 HR_DR6BLD_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last build of the table