[Home] [Help] [Dependency Information]
Object Name: | PER_CA_EE_REPORT_LINES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_CA_EE_REPORT_LINES |
Subobject Name: | |
Status: | VALID |
This Report is used as a temporary table in the Canadian Employment Report. The table holds all the data for different forms (Canadian employment Equity Report - needs to print minimum 11 forms but the number can change based upon the number of temporary work force and each province/CMA having more certain number of employee The data gets deleted from the table once the report is completed.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | This column holds the request id of the submitted process. | |
LINE_NUMBER | NUMBER | Yes | This is Part of the unique Key and will generated by the Canadian Employment Equity Report process. | |
CONTEXT | VARCHAR2 | (60) | This Stores the Form Name (FORM1/FORM2/FORM3...) based upon the form that is processed. | |
SEGMENT1 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT2 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT3 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT4 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT5 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT6 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT7 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT8 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT9 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT10 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT11 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT12 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT13 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT14 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT15 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT16 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT17 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT18 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT19 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT20 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT21 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT22 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT23 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT24 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT25 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT26 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT27 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT28 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT29 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information | |
SEGMENT30 | VARCHAR2 | (60) | The is used to store Canadian Employment Equity Information |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, LINE_NUMBER
, CONTEXT
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM HR.PER_CA_EE_REPORT_LINES;
HR.PER_CA_EE_REPORT_LINES does not reference any database object
HR.PER_CA_EE_REPORT_LINES is referenced by following:
|
|
|