[Home] [Help] [Dependency Information]
Object Name: | PAY_GB_RTI_ASG_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RTI_ASG_EXTRA_INFO_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | |
RTI_OBJECT_VERSION_NUM | NUMBER | (9) | ||
AEI_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
RTI_NEW_ST_DEC | VARCHAR2 | (150) | ||
RTI_PREV_EMP_PAYE_REF | VARCHAR2 | (150) | ||
RTI_PREV_TAX_CDE | VARCHAR2 | (150) | ||
RTI_DT_LF_PREV_EMP | VARCHAR2 | (150) | ||
RTI_PREV_TAX_BASIS | VARCHAR2 | (150) | ||
RTI_LAST_PAY_PERIOD | VARCHAR2 | (150) | ||
RTI_LAST_PAYMENT_PER_TYPE | VARCHAR2 | (150) | ||
RTI_NS_RTI_SENT | VARCHAR2 | (150) | ||
RTI_PEN_RTI_SENT | VARCHAR2 | (150) | ||
RTI_STUDENT_LOAN | VARCHAR2 | (150) | ||
RTI_NT_PAID_BET | VARCHAR2 | (150) | ||
RTI_DT_PEN_START | VARCHAR2 | (150) | ||
RTI_ANN_PEN_AMT | VARCHAR2 | (150) | ||
RTI_REC_BER_FLG | VARCHAR2 | (150) | ||
RT_EXPAT_ST | VARCHAR2 | (150) | ||
RTI_DT_EMP_ST | VARCHAR2 | (150) | ||
RTI_EEA_COMMON_CITIZEN | VARCHAR2 | (150) | ||
RTI_EPM6_SCH | VARCHAR2 | (150) | ||
RTI_EXPAT_RTI_SENT | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT RTI_ASG_EXTRA_INFO_ID
, ASSIGNMENT_ID
, INFORMATION_TYPE
, RTI_OBJECT_VERSION_NUM
, AEI_INFORMATION_CATEGORY
, RTI_NEW_ST_DEC
, RTI_PREV_EMP_PAYE_REF
, RTI_PREV_TAX_CDE
, RTI_DT_LF_PREV_EMP
, RTI_PREV_TAX_BASIS
, RTI_LAST_PAY_PERIOD
, RTI_LAST_PAYMENT_PER_TYPE
, RTI_NS_RTI_SENT
, RTI_PEN_RTI_SENT
, RTI_STUDENT_LOAN
, RTI_NT_PAID_BET
, RTI_DT_PEN_START
, RTI_ANN_PEN_AMT
, RTI_REC_BER_FLG
, RT_EXPAT_ST
, RTI_DT_EMP_ST
, RTI_EEA_COMMON_CITIZEN
, RTI_EPM6_SCH
, RTI_EXPAT_RTI_SENT
FROM APPS.PAY_GB_RTI_ASG_INFO_V;
APPS.PAY_GB_RTI_ASG_INFO_V is not referenced by any database object
|
|
|