CHILD_ORG
Indexed - yes
Format - char (4)
May be null? no
|
The 4-character code for the ORGANIZATION associated with the PARENT_ORG
(or rollup group). Amounts for the CHILD_ORG will be included when data
is summarized by the PARENT_ORG.
A given PARENT_ORG may be associated with more than one CHILD_ORG, and
a given CHILD_ORG may have more than one parent. For example, ORGANIZATION
1319 (SEAS COPY CTR) has parents DEAS (SEAS OFFICE OF THE DEAN) and 13XX
(School of Engineering and Applied Sciences Parent) An ORGANIZATION is
a subdivision of the University created for management purposes.
Values:
Refer to the ORG_CODES Table for values.
|
PARENT_ORG_DESC
Indexed - yes
Format - varchar2 (240)
May be null? yes
|
The description that corresponds to the PARENT_ORG, the rollup group
for a subdivision of the University created for management purposes.
There may be records for ORGs that do not play a role in the organization
hierarchy. These ORGs exist in the Ledger for particular operational
purposes, and may not have parents."
Examples: SEAS OFFICE OF THE DEAN (DEAS); School of Engineering and Applied
Science Parent (13XX)
Values:
List of values not available.
|
PARENT_ORG
Indexed - yes
Format - char (4)
May be null? no
|
The 4-character code for the ORGANIZATON that serves as the parent (or
rollup group) for one or more other ORGANIZATONS, allowing amounts to
be summarized at the parent level. There may be records for ORGs that
do not play a role in the organization hierarchy. These ORGs exist in
the Ledger for particular operational purposes, and may not have parents.
A given ORGANIZATION may have more than one parent. For example, ORGANIZATION
1319 (SEAS COPY CTR) has parents DEAS (SEAS OFFICE OF THE DEAN) and 13XX
(School of Engineering and Applied Sciences Parent). An ORGANIZATION is
a subdivision of the University created for management purposes.
Values:
Refer to the ORG_CODES table for values.
|